schema updates with mysql-connector-java-3.1.11-bin.jar fai
elkner Nov 5, 2005 1:18 AMHmmm,
just "tested" the mysql-connector-java-3.1.11-bin.jar instead of the mysql-connector-java-3.1.10-bin.jar and found out, that schema updates do nit work at all. E.g.:
2005-11-05 06:35:26,859 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: address
2005-11-05 06:35:26,861 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: eventCategories
2005-11-05 06:35:26,864 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: events
2005-11-05 06:35:26,867 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: memberstatus
2005-11-05 06:35:26,869 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: pinfo
2005-11-05 06:35:26,872 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: statustype
2005-11-05 06:35:26,875 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: address
2005-11-05 06:35:26,877 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: eventCategories
2005-11-05 06:35:26,880 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: events
2005-11-05 06:35:26,882 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: memberstatus
2005-11-05 06:35:26,885 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: pinfo
2005-11-05 06:35:26,888 INFO [main:org.hibernate.tool.hbm2ddl.DatabaseMetadata:91] - table not found: statustype
2005-11-05 06:35:26,891 ERROR [main:org.hibernate.tool.hbm2ddl.SchemaUpdate:157] - Unsuccessful: create table address (aid integer not null auto_increment, cstate varchar(64), country char(2) not null, city varchar(64) not null, delivery varchar(64), street varchar(64) not null, street2 varchar(64), plz varchar(10) not null, primary key (aid)) type=InnoDB
2005-11-05 06:35:26,892 ERROR [main:org.hibernate.tool.hbm2ddl.SchemaUpdate:158] - Table 'address' already exists
2005-11-05 06:35:26,896 ERROR [main:org.hibernate.tool.hbm2ddl.SchemaUpdate:157] - Unsuccessful: create table eventCategories (id integer not null auto_increment, name varchar(23) not null unique, note varchar(255), abbrev varchar(5) not null unique, primary key (id)) type=InnoDB
2005-11-05 06:35:26,897 ERROR [main:org.hibernate.tool.hbm2ddl.SchemaUpdate:158] - Table 'eventCategories' already exists
...
To make sure, that it is not really server dependend, I tried this with MySQL 4.1.7 and 5.0.15
So, do we have a hibernate or a mysql jdbc driver bug ?