Hi Folks.
After following the advice of the responses:
1. Removing capitals from the first two letters of the property name
2. Adding the nullValue attribute in the result map
it works now. Thanks.
- Paul
Prashanth Sukumaran <[EMAIL PROTECTED]> wrote on 08/16/2005 09:29:50 AM:
> Hi Paul,
>
> make the line
>
> <result property="pnoticeCompanyNo" column="P_NOTICE_COMPANY_NO"
> javaType="long"
> jdbcType="INTEGER"/>
>
> to
>
> <result property="pnoticeCompanyNo" column="P_NOTICE_COMPANY_NO"
> javaType="long"
> jdbcType="INTEGER" nullValue="0"/>
>
>
> This is ridiculous, I know. I have also wasted so much time on this
> thing before. But the issue
> is since it is a privimitive type and if the sql returns a NULL it
> throws an nullpointer
> exception.
>
> Rgds
>
> Prashanth Sukumaran.
