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

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

Environment

Operating System: Linux
Platform: PC

• Bugzilla Id: 29212
• Assignee: Unassigned
• Reporter: Corey Sanders
• Created: 26/May/04 01:29
• Updated: 02/Jan/08 07:29
• Resolved: 02/Jan/08 07:29

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.