Hi,

I'm totally new to Hibernate. My project requires me to work on Hibernate. So I'm trying to run a sample application.

The issue is since I'm connecting to production database, I want to make sure that I don't end up modifying the database.

Came across which depending on the values [create, create-drop, update etc.] would drop and create the databse schema.

Please advice me on what value to be assigned o this configuration property so that I just read some records from the database without altering the database schema.

Also whats the default value for this property?

Thanks in advance
sara.

hibernate.hbm2ddl.auto has three options create, create-update and validate.

Create will drop and create all tables.
create-update will only modify the tables which can be modified and ignore the rest.
Validate will only validate the schema and throw exception if there are any mismatches. Validation is very very strict and generally conflicts with the generated schema itself :-s.

Default option is create-update

*Please do rate if it helps*

Regards,
Jitendra

Thanks for the reply Jiten.

So can I be sure that if I use 'validate' as value for 'hibernate.hbm2ddl.auto', it will not affect the database at all?

Just don't put it in your configuration file and NOTHING will happen. There is no default.

Hi Christian,

Has this been changed in recent releases? I remember reading that default was create-update.

We had a big issue in our project because of it, if it has been solved in any recent release, we would like to upgrade to that.

Regards,
Jitendra

There is NO DEFAULT. If you don't put it in your configuration file, nothing will happen.

Thanks Christian.

I got confused seeing the following thread.

http://jboss.com/?module=bb&op=viewtopic&t=69683

Regards
sara

This has apparently been a wrong out-of-the-box setting in the EJB3 RC2 release, which is now 2 years old and has been superseded by almost 10 other releases.