Hello, I want a seperate DB schema for every mandator in our application so that the data is not mixed between different mandators. The schemas should be generate dynamicly during runtime. I use something like this to generate the tables of the schema: | Map<String, String> props = new Hashtable<String, String>(); | props.put(HIBERNATE_DEFAULT_SCHEMA, userName); | Ejb3Configuration cfg = new Ejb3Configuration(); | Ejb3Configuration configured = configured = cfg.configure(persistenceUnitName, properties); | String[] lines = cfg.getHibernateConfiguration().generateSchemaCreationScript(new PostgreSQLDialect()); | for (int i = 0; i < lines.length; i++) { | entityManager.createNativeQuery(lines).executeUpdate(); | } | So far every thing work pretty good. The tables in the database are generated during runtime for a new "userName" (I generate the schema in the db with something like "CREATE SCHEMA %%username%%" before) So far so good. Now my problem: I want to persist some data into the new generated tables within the new schema. For that I want to change the property "hibernate.default_schema" of the persistence.xml config file during runtime. I tried several things to do so, but nothing help me to solve the problem. I'm not able to generate a new EntityManager because of transaction reasons. So I have to change the existing EntityManager during runtime. Different things I tried: 1. EntityManagerFactory I use the EntityManagerFactory and call the method "createEntityManager(Map arg)". My map looks like this: | Map<String, String> props = new Hashtable<String, String>(); | props.put("hibernate.default_schema", userName); | I get a new EntityManager but this instance is still using the hibernate.default_schema out of persistence.xml 2. Ejb3Configuration I use the Ejb3Configuration class to generate a new EntityManager with the new "hibernate.default_schema". Perhaps this would work, but I can't do this because of transaction reasons. 2. Hibernate Delegate | Map<String, String> props = new Hashtable<String, String>(); | props.put("hibernate.default_schema", userName); | SessionImpl sessionImpl = ((org.hibernate.impl.SessionImpl) entityManager.getDelegate()); | sessionImpl.getFactory().getConnectionProvider().configure(props); I tried to use the Hibernate delegate of JPA to reconfigure the ConnectionProvider too. After that I establish a new database connection, but the "default_schema" do not change after this reconfiguration. Is it possible to reconfigure the "hibernate.default_schema" during runtime? And how? Hibernate version: 3.2.4.sp1 App-Server: JBoss 4.2.3.GA DB: postgresql-8.3-603 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4167506#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...