[ http://issues.apache.org/jira/browse/IBATIS-176?page=all ] Jeff Butler closed IBATIS-176: ------------------------------
Fix Version: 2.2.0 Resolution: Fixed Fixed in SVN > 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 > Assignee: Jeff Butler > Priority: Minor > Fix For: 2.2.0 > 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