1 Reply Latest reply on Feb 4, 2005 6:51 AM by lahirukarunatilake

    null returned for DOUBLE value after a findByPrimaryKey()

    lahirukarunatilake Newbie

      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.