Uploaded image for project: 'Commons DbUtils'
  1. Commons DbUtils
  2. DBUTILS-18

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

    Details

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

      Operating System: Linux
      Platform: PC

    • Bugzilla Id:
      29212

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              coreysanders@email.com Corey Sanders
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: