[ http://issues.apache.org/jira/browse/IBATIS-176?page=all ]
Jeff Butler updated IBATIS-176:
-------------------------------
Attachment: DecimalTest.zip
This file includes a simple test case showing how to use decimal output
parameters with iBATIS. The test case works with DB2 8.1.9, but likely fails
with DB2 7.1.
> Add support for DECIMAL/NUMERIC scale on Stored Procedure Output Parameters
> ---------------------------------------------------------------------------
>
> Key: IBATIS-176
> URL: http://issues.apache.org/jira/browse/IBATIS-176
> Project: iBatis for Java
> Type: New Feature
> Components: SQL Maps
> Versions: 2.1.5
> Environment: iBATIS is currently known to fail with DB2 7.1 CLI drivers.
> Reporter: Jeff Butler
> Priority: Minor
> Attachments: DecimalTest.zip
>
> The JDBC spec recommends setting the numeric scale when registering output
> parameters of type DECIMAL/NUMERIC. iBATIS should support this
> recommendation so that weaker JDBC drivers (like DB2 7.1 driver) won't fail.
> The enhancement will require a change to the <parameter> element of a
> <parameterMap> - someway to specify the scale. Either add syntax the the
> jdbcType attribute (e.g. DECIMAL:2), or add another optional attribute (e.g.
> jdbcNumericScale="2"). Then the method "registerOutputParameters" in the
> SqlExecuter class should change to support setting the scale for
> DECIMAL/NUMERIC types if specified.
> The SQL parsing logic will also have to change.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
