Hibernate version:
tools.3.0.0.alpha4
Name and version of the database you are using:
Oracle 8.1.7

Hello, I've encountered the following problem trying reverse enginnering through Ant task:
jdbcconfiguration task with >hbm2java< incorrectly maps Oracle's INTEGER (NUMBER(38,0)) into java.math.BigInteger.

I've tried to solve this by adding the follwing to reveng.xml:


and it doesn't help.

How can I map Oracle's INTEGER to long type in Java?
Is it <type-mapping> problem or another jdbc-type is needed?

Thanks in advance.

P.S. I've seen some threads in forum on this problem, but there were no straight answer. Had anyone found solution?

It doesn't seem incorrect to me. NUMBER(38,0) is a *BIG* integer! Using BigInteger would be the only way to handle the range.

Anyway, is there any way to force mapping of INTEGER to long in Java?

use precision/scale for this. not length

Sadly, it doesn't help. I've looked on field's jdbc type, it equals 2 (or NUMERIC). Even more, VARCHAR custom mapping fails too (numbers instead of JDBC types too).
It seems that overrides in reveng.xml aren't applied. The reason is unclear to me, reveng.xml is definitely used, because table filtering works fine.
Now it seems that generator uses class types recommended by JDBC metadata and ignores <type-mapping> section. Why can this happen?

you will have to give me a reproducable test case.

the type overrides works in the unit tests.

best thing is probably to simply just step through with a debugger to see why it chooses that type.

Another little problem (may be should post to JIRA) - reverse engeneering tool uses table name (even if it is from java keywords list) as a property name, in many-to-one associaton, for example. Resulting code won't compile in case table name is equal to any java keyword ('interface' for example).

and what name should i use instead ?

this what users must specify. right now only possibly programmatically.

But for running the first reverse engineering without problems we could probably keep a list of "bad" names that will be prefixed with something to avoid collisions.

Hi there !!

I'm having the very same problem as Bruzz, but I just want to discriminate every NUMERIC type in Oracle into Long or Double java Types:



but I always get only java.math.BigDecimal types...

Am I doing anything wrong in my hibernate.reveng.xml file?

Thank you and best regards !!

I realize the post is over 3 years old but, for the sake of posterity, if using Oracle the JDBC type will be DECIMAL. If you use DECIMAL instead of NUMERIC your config file will generate Long and Double types as desired.