Datatype mapping to Oracle datatypes

[jaboj]

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

[epbernard]

forget about the CMP doc, this is not related to EJB3
you have to defined the dialect class in your persistence.xml

[jaboj]

It seems to work if I change hibernate.dialect in persistence.properties to Oracle9Dialect. Now the default NUMBER size is (10,0) which is ok but the default VARCHAR2 size is still 255. Maybee this isn't changeable. What datatype mapping file is in use?

[epbernard]

use @Column(length=100)

[darquerus]

Is there a general way to define my own datatype mappings?

I cannot set on 250 attributes the annotations for the datatype and the length per hand. ^^