Sample persistence.xml
For a unit called "movie-unit" using two datasources called "movieDatabase" and "movieDatabaseUnmanaged" the following persistence.xml would work.
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"> <persistence-unit name="movie-unit"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <jta-data-source>movieDatabase</jta-data-source> <non-jta-data-source>movieDatabaseUnmanaged</non-jta-data-source> <properties> <property name="hibernate.hbm2ddl.auto" value="create-drop"/> <property name="hibernate.transaction.manager_lookup_class" value="org.apache.openejb.hibernate.TransactionManagerLookup"/> </properties> </persistence-unit> </persistence>
Note that as of OpenEJB 3.1 you do not need to set the hibernate.transaction.manager_lookup_class as it will be set for you automatically and will overwrite any "org.hibernate.transaction." strategy class already set while leaving any custom strategy class you may have implemented untouched. The result is that you can leave your hibernate.transaction.manager_lookup_class property configured to your production environment and OpenEJB will update it just for the scope testing. On the other hand if you have implemented a custom org.hibernate.transaction.TransactionManagerLookup strategy it will always be used and never replaced by OpenEJB.
Note that if you need more functionality in this area we are always happy to add it.
Not using OpenEJB in production?
If you're using OpenEJB 3.0 which does not support the dynamic switching of the hibernate.transaction.manager_lookup_class this is one way to achieve it.
A custom implementation of Hibernate's TransactionManagerLookup strategy like the following will do the trick. This "DynamicTransactionManagerLookup" class can be packed in your jar and deployed with your app.
import org.hibernate.HibernateException; import org.hibernate.transaction.TransactionManagerLookup; import javax.transaction.TransactionManager; import java.util.Properties; public class DynamicTransactionManagerLookup implements TransactionManagerLookup { private TransactionManagerLookup impl; public DynamicTransactionManagerLookup() { String[] strategies = { "org.apache.openejb.hibernate.TransactionManagerLookup", "org.hibernate.transaction.JBossTransactionManagerLookup" }; for (String className : strategies) { try { Class<?> clazz = this.getClass().getClassLoader().loadClass(className); impl = (TransactionManagerLookup) clazz.newInstance(); break; } catch (Exception e) { } } if (impl == null) throw new IllegalStateException("No TransactionManagerLookup available"); } public TransactionManager getTransactionManager(Properties properties) throws HibernateException { return impl.getTransactionManager(properties); } public String getUserTransactionName() { return impl.getUserTransactionName(); } }
Then set the Hibernate specific configuration property hibernate.transaction.manager_lookup_class to the name of the factory that you just created.
Some useful FYI from a user
I tried to use openejb 3.0 together with hibernate 3.2.6ga in a maven project. The transitive dependencies of openejb and hibernate collide on asm.jar. A similar problem is described here:
http://blog.springsource.com/main/2007/06/11/asm-version-incompatibilities-using-spring-autowired-with-hibernate/
or here:
http://forum.springframework.org/showthread.php?t=26713&highlight=cglib-nodep+hibernate
http://jira.springframework.org/browse/SPR-3856
The solution is to exclude the dependency on asm and cglib on hibernate and to add a dependency on cglib-nodep.