I'm using Hibernate to maintain databases with dynamic structure. I'm using SchemaUpdate class to keep mapping files and db tables synchronized. Mapping file is a source, so I want DB schema to be same as its description in .hbm.xml file.
Problem is followed. When I REMOVE one property from mapping file, schema updator does not delete this column in database. Hibernate sources analysis showed that Hibernate can only add columns, but can't drop them.
Is there any way to drop those columns except from direct SQL query?
DB server is MySql, Hibernate v. 2.0.3
Thanks in advance
|