null returned for DOUBLE value after a findByPrimaryKey()

[lahirukarunatilake]

HI,

Im using JBOSS 3.2.3 and mysql 5. My table has a field with DOUBLE(5,2) as the data type. When I try to do a findByPrmaryKey on that table using the EJB it returns a null value. but I can use ejbCreate and insert values to that field. Further I can get the value to that field by using an EJB-QL. The type of the cmp field is of java.lang.Double.

The funny thing is when I change the data type of the cmp field to java.math.BigDecimal it works fine.

Any ideas ???

Thanks in advance...
Lahiru.

[lahirukarunatilake]

Found a workaround.

I used

user-type-mappings

element in standardjbosscmp-jdbc.xml and convert the

java.math.BigDecimal

to

java.lang.Double

while keeping

java.lang.Double

as CMP type. Help is there in follwoing URL to carryout this convertion.

http://www.jboss.org/wiki/Wiki.jsp?page=UserTypeMapping