0 Replies Latest reply on Feb 26, 2006 7:10 AM by Peter Westlin

    hibernate.default_schema not working (with bundled HSQLDB)?

    Peter Westlin Newbie

      I see some strange behaviour when I'm using hibernate.default_schema in persistence.xml with bundled HSQLDB.
      I deploy a new EAR and the server-log says:

      org.hibernate.tool.hbm2ddl.SchemaExport[ERROR] 2006-02-26 12:59:37,937 create(SchemaExport.java:272)
      ** invalid schema name: MOVIES in statement [create table movies.Movie] **
      

      When I look in the newly created data/hypersonic/Movies.log, I see:
      CREATE USER SA PASSWORD "" ADMIN
      /*C1*/SET SCHEMA PUBLIC
      CONNECT USER SA
      /*C2*/SET SCHEMA PUBLIC
      CONNECT USER SA
      /*C1*/ drop table movies.Movie if exists
      

      It is not using my defined schema but the logs says it does.

      Then I create the schema with
      CREATE SCHEMA movies AUTHORIZATION DBA

      and redeploy my EAR and everything works.

      Any thoughts?

      Regards Peter