Wednesday, July 28, 2010

iBatis int(1) to boolean map

In SELECT statement:

SELECT
DECODE(VALUE,'Y',1,'y',1,0) AS value
FROM XYZ_TABLE

In result map:
result property="value" column="value" jdbcType="BOOLEAN" javaType="java.lang.Boolean"

No comments:

Post a Comment