[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1961?page=c...
]
richard yang commented on HHH-1961:
-----------------------------------
I have the same issue with Oracle 10g. I cannot map a double or big_decimal type to oracle
NUMBER wtih precision and scale. I tried many combination including using
sql-type="DECIMAL(4,1)" and sql-type="NUMERIC(4,1)". No luck. Can the
validator skip this check? I am dead in the water with our project. We might have to not
use hibernate anymore.
We use java 1.6 and jboss 4.0.3sp1.
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira