Exception - when create a new factory by Persistence class

avihaimar77 · **Joined:** Wed May 02, 2007 2:42 pm **Posts:** 101

Hey,

I need to create factory in run time because i dont know the shema names.
A new schema is allocated to the user after he register to the system.

I am working in Jboss 4.2.

I have a stateless session bean with the following method:

Code:

   public void createEntityManagerFactoryWithPersistenceAPI() {
      try {
         Hotel  h  = new Hotel("Bla","Bla");
         //******************   Map configuration
         Map configOverrides = new HashMap();
         configOverrides.put("javax.persistence.jtaDataSource", "java:/TestDS");
         configOverrides.put("hibernate.hbm2ddl.auto", "create");
         configOverrides.put("hibernate.connection.driver_class", "com.mysql.jdbc.Driver");
         configOverrides.put("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");

         configOverrides.put("hibernate.default_schema", "Test");

         EntityManagerFactory programmaticEmf =
             Persistence.createEntityManagerFactory("Demo",configOverrides);
               new InitialContext().rebind("java:/TestEMF", programmaticEmf);
      }catch(Exception e){
         
      }
   }

I get an exception when i try to create the factory:
19:14:49,492 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.HibernateException: The chosen transaction strategy requir
es access to the JTA TransactionManager
19:14:49,492 ERROR [STDERR] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:720)
19:14:49,492 ERROR [STDERR] at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121)
19:14:49,492 ERROR [STDERR] at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:51)
19:14:49,492 ERROR [STDERR] at service.impl.HotelServiceBean.createEntityManagerFactoryWithPersistenceAPI(HotelServiceBean.java:83)

if i set to the following to the properties:
configOverrides.put("javax.persistence.transactionType", "RESOURCE_LOCAL");

the factory is created, but when i try to use it i get an exception:
18:36:54,138 ERROR [JDBCTransaction] JDBC commit failed

java.sql.SQLException: You cannot commit during a managed transaction!

at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:543)

My DS:
<datasources>
<local-tx-datasource>
<jndi-name>TestDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>1234</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>




My persistence.xml file:
<persistence>
<persistence-unit name="Demo">
<jta-data-source>java:/InsiteDS</jta-data-source>
<properties>
<property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver" />
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
</properties>
</persistence-unit>
</persistence>

<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>

Thank you!!!!!

emmanuel · **Posted:** Thu Jun 07, 2007 9:42 am

you need to define

Code:

hibernate.transaction.manager_lookup_class =
    org.hibernate.transaction.JBossTransactionManagerLookup

avihaimar77 · **Joined:** Wed May 02, 2007 2:42 pm **Posts:** 101

Now i can create for each user new schema and new factory without the need to declare on it in the persistence.xml and without the need to create DS in run time for each schema that i created.

Thank you.

and again - Thank you.