BigDecimal Oracle mapping

hakans · **Joined:** Tue Jan 10, 2012 3:49 am **Posts:** 7

Hi,

We are using Hibernate 3.6 and Oracle 11g. We generate db schema with hibernate tools. If we don't specify precision and scale on bigdecimal properties, they are created with number(19, 2). Can we change this setting to number(19,6) globally without giving scale and precision on every bigdecimal property.

mmerder · **Posted:** Tue Jan 10, 2012 5:15 am

One solution could be to subclass your dialect and override registerNumericTypeMappings. In this method you should just call the super-method and add

Code:

registerColumnType( Types.NUMERIC, "number(19,6)" );
registerColumnType( Types.DECIMAL, "number(19,6)" );

Then use this dialect in your config (e.g. persistence.xml).

Also see the src of Oracle8iDialect, if that helps.

hakans · **Joined:** Tue Jan 10, 2012 3:49 am **Posts:** 7

Thanks for reply.
But if we register types like you suggest, we can not override precision and scale with column annotation.
We have lots of big decimal properties but only small of amount of them have different precision and scale.

hakans · **Joined:** Tue Jan 10, 2012 3:49 am **Posts:** 7

Any help really appreciated.

jacktheripper · **Joined:** Mon Jan 16, 2012 10:52 am **Posts:** 2

Hi,

We are facing a similar problem in our project. We are subclassing our dialect and overriding registerNumericTypeMappings as mmerder suggested.
However we would like to override it for some of them.

Is there a possible way to do this ?

Need help also.

Thank you.