[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1961) Schema validation fails with floating point column in Oracle 10g

[Julie Chi (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28454 ] 

Julie Chi commented on HHH-1961:
--------------------------------

Try Jboss4.0.5GA. the problem goes away *magically* .  I have the same issue when mapping Double to Oracle column type NUMBER with JBOSS-4.0.4RC1 at startup time, however it just works fine if using JBOSS-4.0.5.GA. Both are using hibernate3.jar.  Does anybody know why? Thanks.

> Schema validation fails with floating point column in Oracle 10g
> ----------------------------------------------------------------
>
>                 Key: HHH-1961
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1961
>             Project: Hibernate3
>          Issue Type: Bug
>    Affects Versions: 3.2.0.cr2
>         Environment: 3.2 CR 2, Oracle 10g express edition release 2, Windows XP service pack 2, JDK 1.5.0_06
>            Reporter: Daniel Dyer
>
> I have a table (created automatically by Hibernate) for mapping a double field.  The table creation from Ant works fine but when starting up JBoss with the hibernate.hbm2ddl.auto property set to validate, I get the following exception:
> Caused by: org.hibernate.HibernateException: Wrong column type: percentage, expected: double precision
>         at org.hibernate.mapping.Table.validateColumns(Table.java:219)
>         at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:965)
>         at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:116)
>         at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:296)
>         at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
>         at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:414)
>         at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:575)
>         at org.hibernate.ejb.Ejb3Configuration.createContainerEntityManagerFactory(Ejb3Configuration.java:245)
>         at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:108)
>         at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:260)
>         ... 127 more
> Doing a "desc" on the table reveals that the column is of type FLOAT with a length of 22.
> I think this may be related to issue HHH-1566 or HHH-1008.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira