Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 1.1dp
    • Fix Version/s: None
    • Component/s: Core
    • Security Level: Public
    • Labels:
      None

      Description

      I have a view with string keys which happen to also be valid integers. In this case routing numbers that can have leading zeros. When I perform a get in using the Java API, the request forwarded to the database assumes I actually meant to send an integer type and the quotes are not sent to as apart of the database query, along with the leading zero now trimmed. If I try to force quotes into the key string, I get extra keys sent with the query.

      I'm assuming the API is guessing the query type based on my input but wouldn't it be better to overload the method for specific types, specifically the primitive types?

      Example:

      query.setKey("011601087"); results in ?stale=false&key=011601087 but I need ?stale=false&key="011601087"

      If I try:
      query.setKey("\"011601087\""); results in ?stale=false&key=011601087 but I need ?stale=false&key=""011601087""

      No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

        Hide
        pgallagher Patrick Gallagher added a comment -

        Sorry, I meant the second example ( query.setKey("\"011601087\"") results in ?stale=false&key=""011601087""

        Show
        pgallagher Patrick Gallagher added a comment - Sorry, I meant the second example ( query.setKey("\"011601087\"") results in ?stale=false&key=""011601087""
        Hide
        SteveC Steven Cooke added a comment -

        This is the same issue as JCBC-41

        Show
        SteveC Steven Cooke added a comment - This is the same issue as JCBC-41
        Hide
        pgallagher Patrick Gallagher added a comment -

        Thanks Steven.

        Show
        pgallagher Patrick Gallagher added a comment - Thanks Steven.
        Hide
        SteveC Steven Cooke added a comment -

        and also SPY-62

        Show
        SteveC Steven Cooke added a comment - and also SPY-62
        Hide
        mikew Mike Wiederhold added a comment -

        Closing as a duplicate of SPY-41. We will get this issue resolved as soon as possible.

        Show
        mikew Mike Wiederhold added a comment - Closing as a duplicate of SPY-41 . We will get this issue resolved as soon as possible.

          People

          • Assignee:
            rags Raghavan Srinivas (Inactive)
            Reporter:
            pgallagher Patrick Gallagher
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Gerrit Reviews

              There are no open Gerrit changes