The NUnit test implement an example of custom type hander which convert a yes/no db value to a True/False bool value, search 'OuiNonBoolTypeHandlerCallback'.
Cheers
-Gilles
On 8/18/05, Zarar Siddiqi <[EMAIL PROTECTED]> wrote:
I'm having an issue with using a custom type hander. I'm trying to convert a yes/no db value to a True/False bool value. The read part of the type handler works fine as in when there is a Yes/No stored in db, it gets converted to the proper bool value.
However, no conversion occurs when I try to update the DB. I've looked at docs and can't see what I'm doing wrong. The SetParameter(..) method which I've implemented based on the ITypeHandlerCallback is NEVER called and the logs read as "param6=[Stackable,True]" which I think should be "param6=[Stackable,Yes]"
Here is my XML. Any help is appreciated. Thanks.
<alias>
<typeAlias alias="BoolYesNo" type="my.namespace.BoolYesNoTypeHandler"/>
</alias>
<insert id="insertShipmentDimensions" parmaterMap="parameterDimensions">
INSERT INTO nlmi_dimensions (ShipmentId, Pieces, Weight, Length, Width, Height, Stackable)
VALUES (#ShipmentId#, #Pieces#, #Weight#, #Length#, #Width#, #Height#, #Stackable#)
</insert>
<parameterMaps>
<parameterMap id="parameterDimensions" class="my.namespace.vo.Dimensions">
<parameter property="ShipmentId" column="ShipmentId"/>
<parameter property="Pieces" column="Pieces"/>
<parameter property="Weight" column="Weight"/>
<parameter property="Length" column="Length"/>
<parameter property="Width" column="Width"/>
<parameter property="Height" column="Height"/>
<parameter property="Stackable" column="Stackable" typeHandler="BoolYesNo"/>
</parameterMap>
</parameterMaps>
<!-- READING FROM THE DATABASE WORKS FINE SO BELOW CODE IS NOT A PROBLEM. JUST INCUDED FOR COMPLETENESS -->
<select id="getDimensions" resultMap="resultDimensions">
SELECT *
FROM dimensions
WHERE ShipmentId = #value#
</select>
<resultMaps>
<resultMap id="resultDimensions" class="my.namespace.vo.Dimensions">
<result property="ShipmentId" column="ShipmentId"/>
<result property="Pieces" column="Pieces"/>
<result property="Weight" column="Weight"/>
<result property="Length" column="Length"/>
<result property="Width" column="Width"/>
<result property="Height" column="Height"/>
<result property="Stackable" column="Stackable" typeHandler="BoolYesNo"/>
</resultMap>
</resultMaps>
