ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kai Grabfelder (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATIS-568) Configured type handler not invoked on insert
Date Sun, 07 Jun 2009 08:42:07 GMT

    [ https://issues.apache.org/jira/browse/IBATIS-568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12717021#action_12717021
] 

Kai Grabfelder commented on IBATIS-568:
---------------------------------------

could you add a patch and testcase against the current ibatis trunk? We would be glad to apply
it then.

> Configured type handler not invoked on insert
> ---------------------------------------------
>
>                 Key: IBATIS-568
>                 URL: https://issues.apache.org/jira/browse/IBATIS-568
>             Project: iBatis for Java
>          Issue Type: Bug
>          Components: SQL Maps
>    Affects Versions: 2.3.3
>         Environment: Windows XP Professional
>            Reporter: Richard R. Duffy
>
> Custom type handler which is configured in the SqlMapConfig is not being invoked for
an insert.  The configured handler is as follows:
> <typeHandler javaType="javax.xml.datatype.XMLGregorianCalendar" jdbcType="TIMESTAMP"
callback="com.aac.engine.dao.impl.TimeStampHandler"/>
> The handler is called for queries (SELECT) and all TIMESTAMP data is processed through
the handler.  However, the handler is not called on insert statements.
> Sample map file entry:
> <insert id="insertAllowance" parameterClass="Allowance">
>     INSERT INTO allowance
>     (
>       jobid,
>       createdate,
>       allowancereminderid,
>       allowancetype,
>       allowancecategory,
>       allowanceworkarea,
>       allowanceduedate,
>       allowancedescription,
>       allowancematerialamounttype,
>       allowancematerialamount,
>       allowancematerialunits,
>       allowancematerialunittype,
>       allowancelaboramount,
>       allowancelaborvisible
>       <dynamic>
>         <isPropertyAvailable property="selection">
>          ,selectiondescription,
>          selectionmaterialamount,
>          selectionlaboramount
>         </isPropertyAvailable>
>       </dynamic>
>     )
>     VALUES
>     (
>       #jobid#,
>       NOW(),
>       #reminderid#,
>       #type#,
>       #category#,
>       #workarea#,
>       #duedate#,
>       #description#,
>       #materialcalculation.type#,
>       #materialcalculation.typevalue#,
>       #materialunits#,
>       #materialunittype#,
>       #labortotal#,
>       #laborvisible#
>       <dynamic>
>         <isPropertyAvailable property="selection">
>          ,#selection.description#,
>          #selection.materialamount#,
>          #selection.laboramount#
>         </isPropertyAvailable>
>       </dynamic>
>     )
>     <selectKey type="post" resultClass="Integer">
>       SELECT LAST_INSERT_ID() AS value
>     </selectKey>
>   </insert>
> If I use an inline type handler for the date column (duedate) within the insert map (such
as #private,handler=com.aac.engine.dao.impl.TimeStampHandler#) then it works fine.  
> Sample inline specification:  #duedate,handler=com.aac.engine.dao.impl.TimeStampHandler#,
> There was a similar issue reported for primitives (IBATIS-244) that was resolved in 2.3.3.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message