1. Problem: Schema update closes session forum.hibernate.orgNewbie 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.orgWe 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.orgINFO [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. |