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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3926347#3926347 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3926347 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
