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
