Hi All,

I work with the Hibernator plugin (0.9.6) in Eclipse 3.0M8 and i have a problem with the Update Schema functionwhich may be part of a larger problem with the ShemaUpdate tool.

The Update Schema button recreates the whole database (drops all of the tables, indexes...etc) instead of modifying the schema where it changed (adding new columns, dropping unused columns...etc).

Is SchemaUpdate capable of updating the schema incrementally (making the changes only not re-creating everything)?

If SchemaUpdate is capable of incremental updates, is there a way to tell Hibernator to call it that way?

I think you should read the section "15.1.5. Incremental schema updates" from the Hibernate user manual...

There is another class used for the update operation,

net.sf.hibernate.tool.hbm2ddl.SchemaUpdate,

replacing the cretation one,

net.sf.hibernate.tool.hbm2ddl.SchemaExport

You seem to have misunderstood the original question.

I know that SchemaExport creates the schema completely and SchemaUpdate is supposed to incrementaly update the schema.

The question was why SchemaUpdate doesn't do incremental updates (because it drops the whole schema and recreates it which hardly can be called incremental update).

Most likely because the metadata provided by your JDBC driver sucks.