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.
