Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.1

Code between sessionFactory.openSession() and session.close(): using hivetranse

Name and version of the database you are using:MySQL

I am thinking that it should be possible for hibernate to update my schemas if I alter the persistant classes (adding or removing properties). I have been messing with hibernate.hbm2ddl.auto, setting it to create etc. but that will result in dropping all tables and re-create them, thus loosing all data.

It should, as far as I can see, possible to just alter the tables as there are a ALTER in SQL and I have provided a SQLDialect.

Is this possible, and if so could someone please lead me in the right direction?

Yes, I believe so. The documentation lists three modes: update | create | create-drop. Use update. The documentation is not very detailed: http://www.hibernate.org/hib_docs/v3/re ... ml_single/

Post if it works for you.

Ah, sorry!
I did try that but for some reason came I to the conclusion that it didn't work.
But it does!

thanks merlyn!

Sweet. Any chance you could rate the post?

I did? Didn`t I?