Do you really need a JTA transaction? Can you not re-configure your persistence unit to use a RESOURCE_LOCAL transaction?
Googling shows you're not alone with wanting (but not necessarily needing) JTA in Tomcat... 2010/9/3 liang <[email protected]> > i found that tomcat 6 have not JTA,which server is able to persistence? > > 在 2010年9月3日 下午12:02，liang <[email protected]>写道： > >> THS,Esteban,I found it which is resin's problem, so i replaced it to >> tomcat6, i got other questions: >> >> in my webapp webroot/meta-inf/content.xml: >> <?xml version="1.0" encoding="UTF-8"?> >> <Context> >> <Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource" >> maxActive="10" maxIdle="2" maxWait="10000" >> logAbandoned="true" >> username="root" password="111111" >> driverClassName="com.mysql.jdbc.Driver" >> url="jdbc:mysql://localhost:3306/test"/> >> </Context> >> >> webroot/web-inf/web.xml: >> >> <resource-ref> >> <description>DB Connection</description> >> <res-ref-name>jdbc/mysql</res-ref-name> >> <res-type>javax.sql.DataSource</res-type> >> <res-auth>Container</res-auth> >> </resource-ref> >> >> webroot/meta-inf/persistence.xml: >> >> <?xml version="1.0" encoding="UTF-8" standalone="yes"?> >> <persistence >> version="1.0" >> 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"; >> xmlns:orm="http://java.sun.com/xml/ns/persistence/orm"; >> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; >> xmlns="http://java.sun.com/xml/ns/persistence";> >> >> <!--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>java:comp/env/jdbc/mysql</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> >> >> >> <properties> >> <property name="hibernate.dialect" >> value="org.hibernate.dialect.MySQLDialect"/> >> <property name="hibernate.max_fetch_depth" value="3"/> >> <property name="hibernate.hbm2ddl.auto" value="create" /> >> <property name="hibernate.show_sql" value="true" /> >> <property name="hibernate.transaction.manager_lookup_class" >> value="org.hibernate.transaction.BTMTransactionManagerLookup" /> >> </properties> >> </persistence-unit> >> >> </persistence> >> >> webroot/testJNDI.jsp: >> >> <%@ page import='java.sql.*, javax.sql.*, javax.naming.*' %> >> <% >> Context ic = new InitialContext(); >> DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/mysql"); >> >> Connection conn = ds.getConnection(); >> >> try { >> Statement stmt = conn.createStatement(); >> ResultSet rs = stmt.executeQuery("select * from test"); >> while (rs.next()) { %> >> <%= rs.getString(1) %> <%= rs.getString(2) %><br><% >> } >> } finally { >> conn.close(); >> } >> %> >> >> webroot/testDroolsFlow.jsp: >> >> <%@ page import='java.sql.*, javax.sql.*, javax.naming.*,com.abc.*' %> >> <% >> VdcService.exec(); >> %> >> >> run the testJNDI.jsp,its OK.when i run testDroolsFlow.jsp, appears this >> exception: >> >> java.lang.RuntimeException: Could not commit session >> at >> org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:119) >> at >> org.drools.persistence.jpa.impl.JPAKnowledgeServiceProviderImpl.newStatefulKnowledgeSession(JPAKnowledgeServiceProviderImpl.java:44) >> at >> org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:93) >> at com.abc.VdcService.exec(VdcService.java:39) >> at >> org.apache.jsp._testDroolsFlow_jsp._jspService(_testDroolsFlow_jsp.java:60) >> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> at >> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) >> at >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) >> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) >> at >> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) >> at >> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) >> at >> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) >> >> at java.lang.Thread.run(Thread.java:619) >> 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:152) >> at javax.naming.InitialContext.lookup(InitialContext.java:392) >> at >> org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:102) >> ... 22 more >> >> JNDI is OK,so i guess the question is in drools side,is right of my >> guess? the exception is here: >> 38 StatefulKnowledgeSession ksession = >> 39 JPAKnowledgeService.newStatefulKnowledgeSession( >> kbase, null, env ); >> >> >> >> PS: >> >> i write the webapp is want to know: >> >> 1. How to save drools into database >> >> 2. What data is saved in the tables; are all the instances of a >> process stored? >> >> 3. Are all nodes in a ruleflow saved? >> >> 4. Are there any nodes which are not running saved in the tables? >> >> 5. What status are running and non-running nodes in the tables? >> >> >> 2010/9/1 Esteban Aliverti <[email protected]> >> >> As far as I can see, this has nothing to do with drools. You can't even >>> create the EntityManagerFactory. Try to set a finest log level >>> for com.caucho.amber.* and org.hibernate.* to see why it is throwing a >>> NPE. >>> >>> Best, >>> >>> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX >>> >>> Esteban Aliverti >>> - Developer @ http://www.plugtree.com >>> - Blog @ http://ilesteban.wordpress.com >>> >>> >>> 2010/9/1 亮亮 <[email protected]> >>> >>>> hi: >>>> >>>> in my webapp, I use JPA to store the runtime state,i use this code in >>>> VdcService.java which is a sample java class: >>>> >>>> EntityManagerFactory emf =Persistence.createEntityManagerFactory( >>>> "org.drools.persistence.jpa" ); >>>> Environment env = KnowledgeBaseFactory.newEnvironment(); >>>> env.set( EnvironmentName.ENTITY_MANAGER_FACTORY, emf ); >>>> >>>> // create a new knowledge session that uses JPA to store the runtime >>>> state >>>> StatefulKnowledgeSession ksession = >>>> JPAKnowledgeService.newStatefulKnowledgeSession( kbase, null, env ); >>>> >>>> I put persistence.xml to webRoot/META-INF/ , persistence.xml: >>>> >>>> <?xml version="1.0" encoding="UTF-8" standalone="yes"?> >>>> <persistence >>>> version="1.0" >>>> 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"; >>>> xmlns:orm="http://java.sun.com/xml/ns/persistence/orm"; >>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; >>>> xmlns="http://java.sun.com/xml/ns/persistence";> >>>> >>>> <persistence-unit name="org.drools.persistence.jpa" >>>> transaction-type="JTA"> >>>> <provider>org.hibernate.ejb.HibernatePersistence</provider> >>>> >>>> <jta-data-source>java:comp/env/jdbc/mysql</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> >>>> >>>> >>>> <properties> >>>> <property name="hibernate.dialect" >>>> value="org.hibernate.dialect.MySQLDialect"/> >>>> <property name="hibernate.max_fetch_depth" value="3"/> >>>> <property name="hibernate.hbm2ddl.auto" value="create" /> >>>> <property name="hibernate.show_sql" value="true" /> >>>> <property name="hibernate.transaction.manager_lookup_class" >>>> value="org.hibernate.transaction.BTMTransactionManagerLookup" /> >>>> </properties> >>>> </persistence-unit> >>>> >>>> </persistence> >>>> >>>> I use resin 3.1.10, $resin-home/conf/resin.conf: >>>> >>>> <database> >>>> <jndi-name>jdbc/mysql</jndi-name> >>>> <driver type="org.gjt.mm.mysql.Driver"> >>>> <url>jdbc:mysql://127.0.0.1:3306/test</url> >>>> <user>root</user> >>>> <password></password> >>>> </driver> >>>> >>>> <prepared-statement-cache-size>8</prepared-statement-cache-size> >>>> <max-connections>20</max-connections> >>>> <max-idle-time>30s</max-idle-time> >>>> </database> >>>> >>>> when i run this webapp , i got this exception: >>>> >>>> java.lang.NullPointerException >>>> at >>>> com.caucho.amber.manager.AmberPersistenceProvider.createEntityManagerFactory(AmberPersistenceProvider.java:65) >>>> at >>>> javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:69) >>>> at com.abc.abc.service.VdcService.exec(VdcService.java:32) >>>> at com.abc.abc.resources.Apply.apply(Apply.java:55) >>>> 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 >>>> com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:156) >>>> at >>>> com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:67) >>>> at >>>> com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:208) >>>> at >>>> com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:75) >>>> at >>>> com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:115) >>>> at >>>> com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:67) >>>> at >>>> com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:724) >>>> at >>>> com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:689) >>>> at >>>> com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:680) >>>> at >>>> com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:324) >>>> at >>>> com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:425) >>>> at >>>> com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:604) >>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:91) >>>> at >>>> com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103) >>>> at >>>> org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:416) >>>> at >>>> com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87) >>>> at >>>> org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:99) >>>> at >>>> com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87) >>>> at >>>> com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187) >>>> at >>>> com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265) >>>> at >>>> com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:273) >>>> at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682) >>>> at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743) >>>> at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662) >>>> at java.lang.Thread.run(Thread.java:619) >>>> >>>> i can't solve it.How to solve it?help me ,THS >>>> >>>> _______________________________________________ >>>> rules-users mailing list >>>> [email protected] >>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>> >>>> >>> >>> _______________________________________________ >>> rules-users mailing list >>> [email protected] >>> https://lists.jboss.org/mailman/listinfo/rules-users >>> >>> >> > > _______________________________________________ > rules-users mailing list > [email protected] > https://lists.jboss.org/mailman/listinfo/rules-users > >
_______________________________________________ rules-users mailing list [email protected] https://lists.jboss.org/mailman/listinfo/rules-users
