Commons DbUtils
  1. Commons DbUtils
  2. DBUTILS-18

[dbutils] Allow user to provide type information for input parameters

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 1.0
    • Fix Version/s: 1.1
    • Labels:
      None
    • Environment:

      Operating System: Linux
      Platform: PC

      Description

      I am having trouble using dbutils with the DB2 v8.1.3 JDBCdriver because my
      driver does not support the Types.OTHER datatype and that datatype is
      automatically assigned to input parameters whose values are null.

      As a workaround to this issue, I suggest adding another overload to the
      QueryRunner::query method, which accepts an additional Object[] list containing
      the types of the parameters being passed. Alternatively, you could create a
      Parameter object that encapsulates the type and value of the input parameter
      and pass an array of those objects to query.

        Activity

        Corey Sanders created issue -
        Henri Yandell made changes -
        Field Original Value New Value
        issue.field.bugzillaimportkey 29212 12341478
        Henri Yandell made changes -
        Key COM-1326 DBUTILS-18
        Assignee Jakarta Commons Developers Mailing List [ commons-dev@jakarta.apache.org ]
        Affects Version/s 1.0 Final [ 12311651 ]
        Component/s DbUtils [ 12311110 ]
        Project Commons [ 12310458 ] Commons DbUtils [ 12310470 ]
        Henri Yandell made changes -
        Affects Version/s 1.0 Final [ 12311724 ]
        Henri Yandell made changes -
        Fix Version/s 1.1 [ 12311973 ]
        Henri Yandell made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Corey Sanders
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development