[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2315?page=c...
]
Julien HENRY commented on HHH-2315:
-----------------------------------
For Oracle this is even more complicated because of synonyms/subtypes:
http://ss64.com/ora/syntax-datatypes.html
Here is a sample of a failing case with Oracle 9i and Hibernate 3.5.0-Beta-2:
Mapping is:
@Column(name="DATE_STRUC", precision=6, scale=3)
private Double dateStructure;
SQL Type in DB is NUMBER(6,3)
Hibernate validation fails with:
org.hibernate.HibernateException: Wrong column type in S3.DECOM for column DATE_STRUC.
Found: number, expected: double precision
at org.hibernate.mapping.Table.validateColumns(Table.java:284)
[hibernate-core-3.5.0-Beta-2.jar:3.5.0-Beta-2]
at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1156)
[hibernate-core-3.5.0-Beta-2.jar:3.5.0-Beta-2]
at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)
[hibernate-core-3.5.0-Beta-2.jar:3.5.0-Beta-2]
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:364)
[hibernate-core-3.5.0-Beta-2.jar:3.5.0-Beta-2]
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1367)
[hibernate-core-3.5.0-Beta-2.jar:3.5.0-Beta-2]
at
org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:858)
[hibernate-annotations-3.5.0-Beta-2.jar:3.5.0-Beta-2]
at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:733)
[hibernate-entitymanager-3.5.0-Beta-2.jar:3.5.0-Beta-2]
Relax SchemaUpdate/SchemaValidator complaining about compatible
types
---------------------------------------------------------------------
Key: HHH-2315
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2315
Project: Hibernate Core
Issue Type: Improvement
Components: core
Reporter: Max Rydahl Andersen
Assignee: Max Rydahl Andersen
http://jira.jboss.com/jira/browse/JBSEAM-596
SchemaUpdate and SchemaValidator must accept compatible types, like:
- CHAR, VARCHAR
- NUMERIC, DECIMAL
--
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