Re: [rules-users] Drools Persistence Problem

After trying suggestion below -- I am now getting the following stack. I've tried deleting the database-generated files figuring a lock existed, but I still get this (even though the files get re-created): org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'droolsEngineFactory' defined in ServletContext resource [/WEB-INF/spring/summit/summit-specific.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: org.drools.persistence.jpa] Unable to build EntityManagerFactory at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) Caused by: javax.persistence.PersistenceException: [PersistenceUnit: org.drools.persistence.jpa] Unable to build EntityManagerFactory at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:677) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:83) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:60) at com.versatile.mte.drools.engine.DroolsEngineFactory.init(DroolsEngineFactory.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) ... 39 more Caused by: org.hibernate.HibernateException: Could not obtain BTM transaction manager instance at org.hibernate.transaction.BTMTransactionManagerLookup.getTransactionManager(BTMTransactionManagerLookup.java:50) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:357) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327) at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669) ... 50 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.hibernate.transaction.BTMTransactionManagerLookup.getTransactionManager(BTMTransactionManagerLookup.java:47) ... 54 more Caused by: bitronix.tm.utils.InitializationException: recovery failed, cannot safely start the transaction manager at bitronix.tm.BitronixTransactionManager.<init>(BitronixTransactionManager.java:65) at bitronix.tm.TransactionManagerServices.getTransactionManager(TransactionManagerServices.java:41) ... 59 more Caused by: java.nio.channels.OverlappingFileLockException at sun.nio.ch.FileChannelImpl$SharedFileLockTable.checkList(FileChannelImpl.java:1170) at sun.nio.ch.FileChannelImpl$SharedFileLockTable.add(FileChannelImpl.java:1072) at sun.nio.ch.FileChannelImpl.tryLock(FileChannelImpl.java:878) at bitronix.tm.journal.TransactionLogAppender.<init>(TransactionLogAppender.java:51) at bitronix.tm.journal.DiskJournal.open(DiskJournal.java:131) at bitronix.tm.BitronixTransactionManager.<init>(BitronixTransactionManager.java:47) ... 60 more nfox241 wrote: > > Do you have the correct Bitronix configuration setup in your server's > configuration file? > > > > > dmiller44 wrote: >> >> I'm having a lot of trouble getting the default Drools persistence stuff >> working as it's documented in the Drools Flow manual. Below I've >> included the stack trace, my dependencies (only those related to drools >> persistence), my code snipped (which gets compiled into a jar and used >> by a war) and the persistence.xml file (which is also compiled into the >> jar under META-INF/persistence.xml). Any help would be appreciated. >> >> *Note: I tried posting this yesterday, but it doesnt seem to have made >> it to the mailing list, so sorry for a double post if it did * >> >> Stack trace: >> >> 2010-01-07 >> 15:36:26,599|org.springframework.web.context.ContextLoader|main|ERROR|| >> Context initialization failed >> org.springframework.beans.factory.BeanCreationException: Error creating >> bean with name 'droolsEngineFactory' defined in ServletContext resource >> [/WEB-INF/spring/summit/summit-specific.xml]: Invocation of init method >> failed; nested exception is java.lang.RuntimeException: Could not commit >> session >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) >> at java.security.AccessController.doPrivileged(Native Method) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) >> at >> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) >> at >> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) >> at >> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) >> at >> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) >> at >> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) >> at >> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429) >> at >> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) >> at >> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) >> at >> org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255) >> at >> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199) >> at >> org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45) >> at >> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) >> at >> org.apache.catalina.core.StandardContext.start(StandardContext.java:4216) >> at >> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) >> at >> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) >> at >> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) >> at >> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626) >> at >> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553) >> at >> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488) >> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150) >> at >> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) >> at >> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) >> at >> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) >> at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) >> at >> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) >> at >> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) >> at >> org.apache.catalina.core.StandardService.start(StandardService.java:448) >> at >> org.apache.catalina.core.StandardServer.start(StandardServer.java:700) >> at org.apache.catalina.startup.Catalina.start(Catalina.java:552) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) >> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) >> Caused by: java.lang.RuntimeException: Could not commit session >> at >> org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:133) >> at >> org.drools.persistence.jpa.impl.JPAKnowledgeServiceProviderImpl.newStatefulKnowledgeSession(JPAKnowledgeServiceProviderImpl.java:44) >> at >> org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:93) >> at >> com.versatile.mte.drools.engine.DroolsEngineFactory.init(DroolsEngineFactory.java:189) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) >> ... 39 more >> Caused by: javax.naming.NamingException: Cannot create resource instance >> at >> org.apache.naming.factory.TransactionFactory.getObjectInstance(TransactionFactory.java:113) >> at >> javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304) >> at org.apache.naming.NamingContext.lookup(NamingContext.java:793) >> at org.apache.naming.NamingContext.lookup(NamingContext.java:140) >> at org.apache.naming.NamingContext.lookup(NamingContext.java:781) >> at org.apache.naming.NamingContext.lookup(NamingContext.java:153) >> at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137) >> at javax.naming.InitialContext.lookup(InitialContext.java:392) >> at >> org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:109) >> ... 49 more >> 2010-01-07 >> 15:36:26,607|org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/mte-web-portal]|main|ERROR|| >> Exception sending context initialized event to listener instance of >> class org.springframework.web.context.ContextLoaderListener >> org.springframework.beans.factory.BeanCreationException: Error creating >> bean with name 'droolsEngineFactory' defined in ServletContext resource >> [/WEB-INF/spring/summit/summit-specific.xml]: Invocation of init method >> failed; nested exception is java.lang.RuntimeException: Could not commit >> session >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) >> at java.security.AccessController.doPrivileged(Native Method) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) >> at >> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) >> at >> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) >> at >> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) >> at >> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) >> at >> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) >> at >> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429) >> at >> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) >> at >> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) >> at >> org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255) >> at >> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199) >> at >> org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45) >> at >> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) >> at >> org.apache.catalina.core.StandardContext.start(StandardContext.java:4216) >> at >> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) >> at >> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) >> at >> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) >> at >> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626) >> at >> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553) >> at >> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488) >> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150) >> at >> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) >> at >> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) >> at >> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) >> at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) >> at >> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) >> at >> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) >> at >> org.apache.catalina.core.StandardService.start(StandardService.java:448) >> at >> org.apache.catalina.core.StandardServer.start(StandardServer.java:700) >> at org.apache.catalina.startup.Catalina.start(Catalina.java:552) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) >> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) >> Caused by: java.lang.RuntimeException: Could not commit session >> at >> org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:133) >> at >> org.drools.persistence.jpa.impl.JPAKnowledgeServiceProviderImpl.newStatefulKnowledgeSession(JPAKnowledgeServiceProviderImpl.java:44) >> at >> org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:93) >> at >> com.versatile.mte.drools.engine.DroolsEngineFactory.init(DroolsEngineFactory.java:189) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375) >> at >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) >> ... 39 more >> Caused by: javax.naming.NamingException: Cannot create resource instance >> at >> org.apache.naming.factory.TransactionFactory.getObjectInstance(TransactionFactory.java:113) >> at >> javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304) >> at org.apache.naming.NamingContext.lookup(NamingContext.java:793) >> at org.apache.naming.NamingContext.lookup(NamingContext.java:140) >> at org.apache.naming.NamingContext.lookup(NamingContext.java:781) >> at org.apache.naming.NamingContext.lookup(NamingContext.java:153) >> at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137) >> at javax.naming.InitialContext.lookup(InitialContext.java:392) >> at >> org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:109) >> ... 49 more >> >> >> Dependencies: >> >> <file name="hibernate-3.3.1.ga.jar"/> >> <file name="hibernate-annotations-3.4.0.ga.jar"/> >> <file name="hibernate-commons-annotations-3.4.0.ga.jar"/> >> <file name="hibernate-entitymanager-3.4.0.ga.jar"/> >> <file name="javassist-3.4.ga.jar"/> >> <file name="jta-1.1.jar"/> >> <file name="dom4j-1.6.1.jar"/> >> <file name="slf4j-jdk14-1.5.2.jar" /> >> <file name="btm-1.3.2.jar" /> >> <file name="h2-1.0.77.jar" /> >> <file name="postgresql-8.1-407.jdbc3.jar"/> >> <file name="drools-persistence-jpa-5.1.0.M1.jar" /> >> <file name="commons-dbcp-1.2.2.jar" /> >> <file name="commons-logging-1.1.1.jar"/> >> <file name="commons-pool-1.5.1.jar"/> >> >> >> Code Snippet (part that should be loading via JPA): >> >> //ADDED FOR DROOLS PERSISTENCE >> PoolingDataSource ds = new PoolingDataSource(); >> ds.setUniqueName("jdbc/testDS1"); >> ds.setClassName("org.h2.jdbcx.JdbcDataSource"); >> ds.setMaxPoolSize(3); >> ds.setAllowLocalTransactions(true); >> ds.getDriverProperties().put("user","sa"); >> ds.getDriverProperties().put("password", "sasa"); >> ds.getDriverProperties().put("URL", >> "jdbc:h2:file:/var/tmp/process-instance-db"); >> ds.init(); >> >> try { >> Context ctx = new InitialContext(); >> ctx.createSubcontext("jdbc"); >> ctx.rebind("jdbc/testDS1",ds); >> ctx.close(); >> } catch (NamingException e) { >> e.printStackTrace(); //To change body of catch statement >> use File | Settings | File Templates. >> } >> >> Environment env = KnowledgeBaseFactory.newEnvironment(); >> EntityManagerFactory emf = >> Persistence.createEntityManagerFactory("org.drools.persistence.jpa"); >> env.set(EnvironmentName.ENTITY_MANAGER_FACTORY,emf); >> >> //grab a session >> LOG.debug("Initializing a new StatefulKnowledgeSession..."); >> //this.ksession = this.kbase.newStatefulKnowledgeSession(); >> this.ksession = >> JPAKnowledgeService.newStatefulKnowledgeSession(kbase,null,env); >> >> >> And finally the persistence.xml file: >> >> <?xml version="1.0" encoding="UTF-8"?> >> <persistence version="1.0" >> xmlns="http://java.sun.com/xml/ns/persistence" >> xmlns:orm="http://java.sun.com/xml/ns/persistence/orm" >> 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 >> http://java.sun.com/xml/ns/persistence/orm >> http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"> >> <!--persistence-unit name="ProcessService"> >> <jta-data-source>java:/DefaultDS</jta-data-source> >> <properties> >> <property name="hibernate.hbm2ddl.auto" value="create-drop"/> >> </properties> >> </persistence-unit--> >> <persistence-unit name="org.drools.persistence.jpa" >> transaction-type="JTA"> >> <provider>org.hibernate.ejb.HibernatePersistence</provider> >> <jta-data-source>jdbc/testDS1</jta-data-source> >> <class>org.drools.persistence.session.SessionInfo</class> >> >> <class>org.drools.persistence.processinstance.ProcessInstanceInfo</class> >> >> <class>org.drools.persistence.processinstance.ProcessInstanceEventInfo</class> >> <class>org.drools.persistence.processinstance.WorkItemInfo</class> >> >> <class>org.drools.persistence.processinstance.variabletypes.JPAPersistedVariable</class> >> >> <class>org.drools.persistence.processinstance.variabletypes.VariableInstanceInfo</class> >> >> <class>org.drools.persistence.processinstance.variabletypes.SerializablePersistedVariable</class> >> <properties> >> <property name="hibernate.dialect" >> value="org.hibernate.dialect.H2Dialect"/> >> <property name="hibernate.max_fetch_depth" value="3"/> >> <property name="hibernate.hbm2ddl.auto" value="update" /> >> <property name="hibernate.show_sql" value="false" /> >> <property name="hibernate.transaction.manager_lookup_class" >> value="org.hibernate.transaction.BTMTransactionManagerLookup" /> >> </properties> >> </persistence-unit> >> </persistence> >> >> >> Any help would be appreciated. This is getting rather frustrating. >> >> > >