I am using auto table creation to get things up and running quickly, however I am seeing some unexpected behaviour. When the oracle schema is empty and I startup hibernate I see the following:
Code:
org.hibernate.tool.hbm2ddl.DatabaseMetadata - table not found: table1
org.hibernate.tool.hbm2ddl.DatabaseMetadata - table not found: table2
org.hibernate.tool.hbm2ddl.DatabaseMetadata - table not found: table3
org.hibernate.tool.hbm2ddl.TableMetadata - table found: OTHERSCHEMA.TABLE4
org.hibernate.tool.hbm2ddl.TableMetadata - columns: [id, last_update, name, code, type, disabled, parent_id]
org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys: []
org.hibernate.tool.hbm2ddl.TableMetadata - indexes: [u141584807, sys_c0058351]
org.hibernate.tool.hbm2ddl.DatabaseMetadata - table not found: table5
It works fine in mysql, however when we use oracle it picks up duplicate table names in other schemas and does not create those tables. Any ideas on how to sort this out?