1. Problem: Schema update closes session forum.hibernate.org
Newbie Joined: Thu Oct 13, 2005 11:43 am Posts: 11 I'm using Hibernate in a standalone application with a PostgreSQL database. Using c3p0 and setting "hibernate.hbm2ddl.auto" to "update" I'm getting the exceptions shown below when trying to open a session. When I change the parameter to "create" or "off" it works (if the schema exists). Also using the build in hibernate ...
2. C3P0 and altering session schema forum.hibernate.org
We are attempting to transition to using C3P0 connection pooling and have run into an issue with initializing the connections. We are using a session-per-conversation pattern. We use Oracle to provide authentication for each user of our application (each user has their own oracle userId). Once a user succesfully authenticates via Oracle we switch the schema to the common hibernate schema ...
3. Replacement failed:alter session set current_schema=:schema forum.hibernate.org
4. Configurable SchemaExport import file (2 session factories) forum.hibernate.org
INFO [org.hibernate.tool.hbm2ddl.SchemaExport] Running hbm2ddl schema export INFO [org.hibernate.tool.hbm2ddl.SchemaExport] exporting generated schema to database INFO [org.hibernate.tool.hbm2ddl.SchemaExport] Executing import script: /import.sql ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] schema export unsuccessful org.hibernate.JDBCException: Error during import script execution at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:258) at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:192) at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133) at org.hibernate.impl.SessionFactoryImpl.