[jira] Commented: (IBATIS-224) isNotNull node causes typehandler mappings in statement to fail

["Sven Boden (JIRA)" <ib...@incubator.apache.org>]

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

Sven Boden commented on IBATIS-224:
-----------------------------------

I spent 2 hours to create a test case to mimic the problem above, I failed. iBATIS keeps on working as it should.

Possibly something is wrong with the mapping of the custom type handlers in use in the original problem. So if the original reporter could post more of his application, or construct a small (complete) test case that shows the failure then we can debug and fix it.

Regards,
Sven



> isNotNull node causes typehandler mappings in statement to fail
> ---------------------------------------------------------------
>
>          Key: IBATIS-224
>          URL: http://issues.apache.org/jira/browse/IBATIS-224
>      Project: iBatis for Java
>         Type: Bug
>   Components: SQL Maps
>     Versions: 2.1.6
>  Environment: linux/java 1.5
>     Reporter: Reuben Firmin
>     Priority: Critical

>
> Here's my insert statement.
>     <insert id="createDeployment" parameterClass="deployment">
>         INSERT INTO Deployment (
>             environmentId, deploymentTypeId, deploymentStatusId, deploymentTime
>                 <isNotNull property="threadCountOverride">,threadCountOverride</isNotNull>
>         ) VALUES (
>             #environmentId#, #deploymentTypeId#, #deploymentStatusId#, #deploymentTime#
>                 <isNotNull property="threadCountOverride">,#threadCountOverride#</isNotNull>
>         )
>         <selectKey resultClass="int" keyProperty="deploymentId">
>             SELECT @@IDENTITY as value
>         </selectKey>
>     </insert>
> deploymentTypeId and deploymentStatusId are enums in the bean, mapped to values using custom type handlers. Without the isNotNull structure around threadCountOverride (which *is* nullable), the statement works. With the isNotNull, deploymentStatusId and deploymentTypeId are mapped to UnknownTypeHandler, and the insert fails to map the parameters from the bean.

-- 
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