3 Replies Latest reply on Dec 20, 2007 6:09 AM by Pete Muir

    PersistenceException when using double in Oracle10g

    Erik Hellman Newbie

      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:

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

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