4 Replies Latest reply on Jul 11, 2007 6:19 AM by Roland Burgermann

    Datatype mapping to Oracle datatypes

    Jacob Boje Newbie

      HI,

      We're evaluating JBOSS with EJB3 using a Oracle database. I can't get datatype mapping to work correctly.

      I seems like the Integer datatype i mapped to NUMBER(38) which is the maximum number size i Oracle. The Long datatype is mapped to BIGINT which isn't a datatype in Oracle and therefore an exceptino i raised.

      I've tried altering standardjaws.xml and standardjbosscmp-jdbc.xml in the conf-catalog and also the oracle-ds.xml in the deploy-catalog. This do not have any effect. I've also tried to change the default size of VARCHAR2 from 255 to 100 - this haven't any effect either....

      I would like to know if this type mapping is a bug in JBOSS 4.0.3SP1 with EJB3 or what?

      Regards
      Jaboj