PersistenceException when using double in Oracle10g

[erik.d.hellman]

We get an exception when trying to startup our Seam application with Hibernate setting hibernate.hbm2ddl.auto set to "validate":

javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: POST_DELIVERY_ITEM_COUNT, expected: double precision

I tried both OracleDialect and Oracle9Dialect, with no success. The strange thing is that the database was generated by Hibernate in the first place, so there seems to be some weird inconsistency somewhere. I also tried adding a type mapping in seam-gen.reveng.xml with no success:

<type-mapping>
 <sql-type jdbc-type="FLOAT" hibernate-type="double"/>
</type-mapping>

I've searched the Hibernate forums and other sources and there doesn't seem to be any good solution to this. Any suggestions?

[pmuir]

Ask on the hibernate forum :)

[saeediqbal1]

I have the same issue. I disabled validation for now.

Pete this isnt a hibernate issue, i think its a seam issue because the mapping is saved in a seam reverse engineering xml file but it doesnt pick up the mapping. why?. Please help!!

[pmuir]

It is a hibernate issue. The reveng.xml is from Hibernate Tools, and it isn't used to store mappings either.

The answer is that hibernate-tools isn't perfect, and sometimes makes mistakes (like this) which you have to correct by hand. If you come across such a problem you need to (1) fix it in your app, (2) report it in the hibernate tools forum so they can add it to the mapping files which come with hibernate tools.

You can also ask about reveng.xml on the hibernate tools forum.