Dear all
My case is for example I have got one table called MEMBERS that has detail like this:

MEMBERS(memberId, name, surname);

and in this table has contained 150 records already. If oneday my customer would like to add more information to this TABLE, email, so I have to change my schema in HB mapping.
How can I tell hibernate to change DATABASE schema in my table without delete all my data in MEMBERS table
Thanks

I would assume you would have to start with the database. Most major databases will allow you to add a column, or even remove a column from a table (unless part of an index, in which case, first drop the index etc) without deleting the data in the table.

All you need to do is (e.g for postrges)



and then add the email field to the hibernate mapping... (and of course use it wherever you want to in your application)
Cheers
Ati

Thanks Guys
That's my false, I'm using Xdoclet and Maven and I forgot to disable auto-create table in database. That's a reason why everytime I change mapping file my data will be removed.

Cheers