Strange behaviour when column is null

[Jonathan Tse]

Hi all,

   I experienced a very strange problem with iBatis. Everything is fine 
until I add one more field named imagePath (String in java, varchar in 
Mysql) to the DB and the product POJO. If the field is null in MySQL , 
iBatis result a NestedSQLException. But a similar field called 
description have no problem at all when the field in DB is null. Then i 
replace the null field with something, then the exception is not thrown.

   Any input is appreciated.

Best regards,
Jonathan Tse

   Product.java (other member omitted for simplicity)
   private Long productId
   private String description;
   private String imagePath;

   And my xml file for this pojo :

<resultMap id="productResult" class="product">
       <result property="productId" column="product_id" />
       <result property="description" column="description" />
       <result property="imagePath" column="imagepath" />
   </resultMap>

<select id="getProductListByCategory" resultMap="productResult">
       <![CDATA[
           select product_id, name, description, categoryid, listprice, 
hot, enabled, imagepath from product where
           categoryid = #value#
       ]]>
   </select>