[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2315?page=c... ] Diego Pires Plentz updated HHH-2315: ------------------------------------ Description: http://jira.jboss.com/jira/browse/JBSEAM-596 SchemaUpdate and SchemaValidator must accept compatible types, like: - CHAR, VARCHAR - NUMERIC, DECIMAL was:http://jira.jboss.com/jira/browse/JBSEAM-596 Summary: Relax SchemaUpdate/SchemaValidator complaining about compatible types (was: relax schemaupdate complaining about 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2315?page=c... ] Diego Pires Plentz commented on HHH-2315: ----------------------------------------- The method that *do* the validation is org.hibernate.mapping.Table.validateColumns(Dialect dialect, Mapping mapping, TableMetadata tableInfo). More info: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Types.html http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/mapping.html -- 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

[ 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] -- 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