I want to generate hbm mapping files from my hibernate reverse engeenering file but i get big_decimal type instead of integer, i don't udnerstand :

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd" >

<hibernate-reverse-engineering>
<schema-selection match-schema="FC" />
<type-mapping>
<sql-type jdbc-type="INTEGER" hibernate-type="double" />
</type-mapping>
</hibernate-reverse-engineering>



Hibernate version: 3.2

<class name="com.mach.model.to.AccountingDocumentTO" table="ACCOUNTING_DOCUMENT" schema="FC">
<id name="docId" type="big_decimal">
<column name="DOC_ID_" precision="22" scale="0" />

<generator class="assigned" />
</id>


Name and version of the database you are using: ORACLE


THANK YOU.

<sql-type jdbc-type="INTEGER" hibernate-type="double" />

Oooooooooooooops he says.

Yes you"re right ...sorry.
it's
<sql-type jdbc-type="INTEGER" hibernate-type="Integer" />

for information with double it doesn't work too.

Any suggestions ?


thanks.

suggestion: ask tools question in the tools forum ;)

note, the reason big_decimal is chosen is because your INTEGER at db level can hold more than the java integer.