Hi all,

i'm trying to setup my development environment to use the hibernate.hbm2ddl.auto setting.

It seems that none of the available settings provide the behaviour i want. The ideal solution for me would be a cross between the create and the update, as i don't want to loose the data but i want the schema to be update to reflect exactly my domain model.

A possible solution would be for me would be to use the create option, do an export of the data just before the tables are dropped, and do an import after the tables are created. If an error occurred with the execution,like when a column was dropped, then the user himself would have to deal with it.

Anyway, is there i way i can listen to these drop and create events ?

Thanks in advance.

not currently.

Can you tell me if something like this is going to be implemented soon ?

we want to make the ddl generation more pluggable (so we don't have to provide every conceivable DBA optimization ;) ...but it when it will be done i cannot say. It is not a top priority at the moment.

Is there any more info on this? I'm dealing with the same problem. I am willing to spent some time here, if there already is an issue or piece of iplementation somewhere?

okay never mind, I've just not implemented my custom generator properly, so the update SQL threw me an exception, that's why my new tables weren't created. It seems the update value just is what i need, sorry for the spam :)

Can you please tell me if it's possible to generate hibernate mapping files having existing mysql database?
Thanks for help.

yes it is possible like with any other db that has proper jdbc support.