5 Replies Latest reply on Dec 22, 2005 4:47 AM by fire-fly

    schema updates with  mysql-connector-java-3.1.11-bin.jar fai

    Jens Elkner Apprentice

      Hmmm,
      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 ?