[jboss-user] [JBoss Seam] - PersistenceException when using double in Oracle10g

[erik.d.hellman@gmail.com]

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?


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4111874#4111874

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4111874