Some words on the SchemaUpdate

rocket · **Posted:** Tue Dec 28, 2004 7:13 pm

Hi,
SchemaUpdate is a very useful feature. However...
It has times I successfully used the schemaupdate in Posgres 7.3 and the SQL Server 2000 with Microsoft's driver.
However, for my surprise, today it does not function more (I did not forget the parameter "text" available from version 2.1.2).
The problem is caused by driver:

See my tests:

Hibernate 2.1.1, Postgres 7.3, driver pg73jdbc3.jar > schemaupdate work
Hibernate 2.1.7c, Postgres 7.4, driver pg74.215.jdbc3.jar > schemaupdate does not work
Hibernate 2.1.7c, MSSQL 2000, driver microsoft > schemaupdate work
Hibernate 2.1.7c, MSSQL 2000, driver jtds 0.9 > schemaupdate does not work
Hibernate 2.1.7c, Postgres 8rc1 (on Windows), driver pg80b1.308.jdbc3.jar > schemaupdate does not work

Well, I think that Postgres users have limitations :-(

max · **Posted:** Wed Dec 29, 2004 3:52 am

Define "not work" ?

we haven't changed anything vital i schemaupdate for ages...it just rely on a jdbc driver that can tell enough about the current database structure.

rocket · **Posted:** Wed Dec 29, 2004 9:59 am

Exactly.
I think that the problem not is with SchemaUpdateTool, but with the JDBC driver.
I am making more tests and then, that they will be ready, I publish it.

Quote:

Define "not work" ?

I think that because metadata is not retrevied (or is incorrect) by JDBC, the SchemaUpdate is unable to create a correct ddl script. The generated script is, always, a create's ddl.