[jira] Commented: (IBATIS-176) Add support for DECIMAL/NUMERIC scale on Stored Procedure Output Parameters

["Jeff Butler (JIRA)" <ib...@incubator.apache.org>]

    [ http://issues.apache.org/jira/browse/IBATIS-176?page=comments#action_12317091 ] 

Jeff Butler commented on IBATIS-176:
------------------------------------

Excuse me - I meant that the XML parsing logic would have to change, not the SQL parsing logic (of which there is none).

> 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