[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2315) Relax SchemaUpdate/SchemaValidator complaining about compatible types

[Julien HENRY (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=34490#action_34490 ] 

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira