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...
Found a workaround.
user-type-mappingselement in standardjbosscmp-jdbc.xml and convert the
java.lang.Doubleas CMP type. Help is there in follwoing URL to carryout this convertion.