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

[Carsten Blieske (JIRA)]

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

Carsten Blieske commented on HHH-2315:
--------------------------------------

Hi,

we have the same Problem after Updating from Hibernate 3.5.0 to 3.5.6 (3.6.0).

Config:
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
hibernate.hbm2ddl.auto=validate

Message:
Caused by: org.hibernate.HibernateException: Wrong column type in table.XYZ for column creationDate. Found: datetime, expected: date
at org.hibernate.mapping.Table.validateColumns(Table.java:283)
at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1313)
at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:376)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1842)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:860)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:779)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)


The same Problem occured with our type text columns, which were expected to be longtext.

> 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