Hello. I have the following problems:
I try to do a SchemaUpdate over a MySQL DB over database where the update should add some fields to some table, but the SchemaUpdate try to re-create the table, with <<SQLException>> results...

I did a debug to see what happens and the problem is at net.sf.hibernate.tool.hbm2ddl.DatabaseMetadata at line 47 , where the tool finds if the table exists or not, to create or update the table, :

public TableMetadata getTableMetadata(String name) throws HibernateException {

...

String[] types = {"TABLE"};
ResultSet rs = null;
try {
   try {

THIS>>rs = meta.getTables(null, "%", name.toUpperCase(), types);
      while ( rs.next() ) {
      if ( name.equalsIgnoreCase( rs.getString("TABLE_NAME") ) ) {
         table = new TableMetadata(rs, meta);
         tables.put( name.toUpperCase(), table );
         break;
      }

The line 47 is rs=meta.getTables(null, "%", name.toUpperCase(),Types);
The problem is that hibernate creates the tables (with SchemaExport) with lower case, and MySQL is case sensitive for table names on Unix (see http://www.mysql.com/doc/en/Name_case_sensitivity.html). But the .getTables call finds the upper case table name. Then, never is found, and it try to create the table when it exists.

The fix is remove the .toUpperCase() :
rs = meta.getTables(null, "%", name, types);

or SchemaExport should create the tables with upper case.

Hibernate is great. Thanks for all.