You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@commons.apache.org by bu...@apache.org on 2004/05/25 20:29:33 UTC

DO NOT REPLY [Bug 29212] New: - Allow user to provide type information for input parameters

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=29212>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=29212

Allow user to provide type information for input parameters

           Summary: Allow user to provide type information for input
                    parameters
           Product: Commons
           Version: 1.0 Final
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: Enhancement
          Priority: Other
         Component: DbUtils
        AssignedTo: commons-dev@jakarta.apache.org
        ReportedBy: coreysanders@email.com


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.

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org