forget about the CMP doc, this is not related to EJB3
you have to defined the dialect class in your persistence.xml
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?
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. ^^