why does SchemaExport turn BigInteger into numeric(19,2)?

Dwightd · **Joined:** Wed Nov 30, 2005 2:41 pm **Posts:** 29

Hibernate version: 3.1rc3; jdk 1.4.2_06
SchemaExport (hbm2ddl) takes a BigIntegerType and makes it numeric(19,2) for the DB2 (and DB2400) dialects. Should be (n,0) I would think. For HSQL it's just "numeric".
Mapping documents:

Code:

<property name="TestNonNegInteger">
<column name="TestNonNegInteger"/>
<type name="org.hibernate.type.BigIntegerType"/>
</property>

SQL:

Code:

create table Test1 (..., TestNonNegInteger numeric(19,2), ...);

I'm actually using a hyperJaxb2 ant script to run this, but for this particular step, I believe only hibernate (SchemaExportTask) is involved.
I looked at the hbm2ddl code briefly, but couldn't figure out where the default scale of 2 was coming from.

any ideas?

max · **Posted:** Wed Nov 30, 2005 5:43 pm

2 is the default scale used in hibernate when you don't specify anything - the same is 19 the default for length and precision.

Dwightd · **Joined:** Wed Nov 30, 2005 2:41 pm **Posts:** 29

But shouldn't any Integer type have a scale of zero? Actually, since DB2 supports BIGINT, that would seem the most natural conversion for BigIntegerType. In fact, DB2Dialect.java includes this:

registerColumnType( Types.BIGINT, "bigint" );

but that's apparently not used in this situation.

My other option is to look at the hyperjaxb side to see how to generate an explicit scale for that case.

max · **Posted:** Wed Nov 30, 2005 6:38 pm

did you try with big_integer?

max · **Posted:** Wed Nov 30, 2005 6:42 pm

in any case scale="0" would do what you want.

Dwightd · **Joined:** Wed Nov 30, 2005 2:41 pm **Posts:** 29

did i try big_integer where? I haven't tried modifying any of the hibernate code yet.

I tried scale="0" in hbm & that worked -- got 'numeric(19,0)' -- Thanks! I just have to get hyperjaxb to do that automatically.

But it still seems odd to have to specify scale for an integer type.

I think it'd be better/simpler if SchemaExport generated a DB2 type of BIGINT for BigIntegerType.