I am using an Entity called User, with the table "Users". Unfortunately, without DDL scripts and using metadata only DDL in persistence.xml for drop-and-create, OpenJPA is finding the USERS table from the INFORMATION_SCHEMA, instead of the PUBLIC schema (where the table does not yet exist).
As a result it does not send the "CREATE TABLE" SQL and tries to alter the non-existent USERS table with "ALTER TABLE" (since SQL statements target the H2 PUBLIC schema). Hibernate: it does not detect any USERS table in PUBLIC schema and so sends "CREATE TABLE" DDL. Is this a "bug" ? Cheers Anthony
