0 Replies Latest reply on May 26, 2003 5:19 AM by russell

    Sybase NUMERIC fields getting rounded in CMP

    russell Newbie

      We are having a problem with inserting values into a NUMERIC field in Sybase using CMP.

      The entity bean's field is defined as BigDecimal.
      The Sybase table field is defined as NUMERIC(18,4).

      In jaws.xml, a type mapping is defined for the bigdecimal field as


      We define the mapping in jaws.xml instead of standardjaws.xml because changing standardjaws doesnt seem to have any effect and still uses the mapping for IMAGE instead of NUMERIC.

      When inserting a value with a decimal part, such as new BigDecimal("1234.123"), the value stored in the database is just the integer part (1234).

      Are we using the correct type mapping?

      JBoss version is 2.4.10.