jpa hibernate.hbm2ddl.auto = validate issue

[satish bodas]

Hello ,
Facing an issue with the "validate" value for hibernate.hbm2ddl.auto

I have executed my DDL statements separately .

I never did like this idea of the ORM tool executing my DDL's !

To prevent this I set the value to validate ( previously tried Create / create-drop )

  <property name="hibernate.hbm2ddl.auto" value="validate"/>   

Now with the value set to Validate - I get the error ::

    
Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: childid, expected: int8 
   at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:720) 
   at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121) 
   at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:51) 
   at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:33) 
   at com.onetoone.postgres.ChildContainsParent.Client.main(Client.java:15) 
Caused by: org.hibernate.HibernateException: Wrong column type: childid, expected: int8 
   at org.hibernate.mapping.Table.validateColumns(Table.java:261) 
   at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1083) 
   at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:116) 
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:317) 
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294) 
   at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:713) 
 

If I change the setting to "update" things work .

Dont seem to understand why ?
I had also posted the same question on Hibernate forums but didnt get no response ( http://forum.hibernate.org/viewtopic.php?p=2389891 )

Any help in understanding this issue is appreciated
Thanks ,
~satish
[ July 24, 2008: Message edited by: satish bodas ]

[Rodrigo Lopes]

The "validate" option will check if your mapping is consistent with your database. If not, it throws an error.
The "update" option will check if your mapping is consistent with your database. If not, it will update your database to make it consistent to your mapping.

Verify where the childid field is defined and check if it's mapped accordingly to you database.

[satish bodas]

Thanks for the response .

In the db it is defined as datatype - bigint and in java it is defined as Long

Also when I dont use validate it works fine .

Thanks ,
~satish