3:37 a.m.
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
7:26 a.m.
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 亮亮 <zhuyx808(a)gmail.com>
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
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
11:02 p.m.
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 <esteban.aliverti(a)gmail.com>
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 亮亮 <zhuyx808(a)gmail.com>
> 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
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
6:53 a.m.
i found that tomcat 6 have not JTA,which server is able to persistence?
在 2010年9月3日 下午12:02，liang <zhuyx808(a)gmail.xn--com>:-0s6m5392c
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 <esteban.aliverti(a)gmail.com>
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 亮亮 <zhuyx808(a)gmail.com>
>
>> 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
>> rules-users(a)lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>>
>
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
7:14 a.m.
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 <zhuyx808(a)gmail.com>
i found that tomcat 6 have not JTA,which server is able to
persistence?
在 2010年9月3日 下午12:02，liang <zhuyx808(a)gmail.xn--com>:-0s6m5392c
> 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 <esteban.aliverti(a)gmail.com>
>
> 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 亮亮 <zhuyx808(a)gmail.com>
>>
>>> 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
>>> rules-users(a)lists.jboss.org
>>> https://lists.jboss.org/mailman/listinfo/rules-users
>>>
>>>
>>
>> _______________________________________________
>> rules-users mailing list
>> rules-users(a)lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>>
>
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
9:48 a.m.
New subject: Persistence.createEntityManagerFactory NullPointerException
You need to configure bitronix[0] to provide JTA. Or use drools-spring
that allows you to use drools-persisntece-jpa without JTA.
[0] http://docs.codehaus.org/display/BTM/Tomcat13
On 09/03/2010 08:53 AM, liang wrote:
i found that tomcat 6 have not JTA,which server is able to
persistence?
在 2010年9月3日 下午12:02，liang <zhuyx808(a)gmail.com
<mailto:zhuyx808@gmail.com>>写道：
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 <esteban.aliverti(a)gmail.com
<mailto:esteban.aliverti@gmail.com>>
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 <http://www.plugtree.com>
- Blog @ http://ilesteban.wordpress.com
2010/9/1 亮亮 <zhuyx808(a)gmail.com <mailto:zhuyx808@gmail.com>>
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
<http://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
rules-users(a)lists.jboss.org
<mailto:rules-users@lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/rules-users
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org <mailto:rules-users@lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/rules-users
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
10:49 a.m.
If it helps at all; I spent almost a full week trying to get JPA to
work with Tomcat 5.5 + Hibernate + Bitronix and this is what I found.
The instructions for Bitronix in
http://docs.codehaus.org/display/BTM/Tomcat13 did not help me much.
The datasource that gets created via the resource.properties could
never be found.
- So to get it to work, do deploy the Bitronix jar files into your
server / context
- In the Tomcat conf/context.xml I do have "<Transaction
factory="bitronix.tm.BitronixUserTransactionObjectFactory" />" but I
am not sure if it is required ( haven't tested removing it ).
- In the web.xml I do have:
<resource-env-ref>
<resource-env-ref-name>java:comp/env/jdbc/processInstanceDS</resource-env-ref-name>
<resource-env-ref-type>javax.sql.DataSource</resource-env-ref-type>
</resource-env-ref>
where jdbc/processInstanceDS is your jdbc/mysql
- In the Hibernate persistence.xml I do have:
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.BTMTransactionManagerLookup" />
<property name="hibernate.jndi.class"
value="bitronix.tm.jndi.BitronixInitialContextFactory" />
although I don't think it is using the jndi.class specified there, so
the second line might be redundant.
Then in my code I create the datasource by hand ( in a ServletContextListener ):
PoolingDataSource ds = new PoolingDataSource();
ds.setUniqueName( "jdbc/processInstanceDS" );
ds.setClassName( "bitronix.tm.resource.jdbc.lrc.LrcXADataSource");
ds.setMaxPoolSize( 3 );
ds.setAllowLocalTransactions( true );
ds.getDriverProperties().put("driverClassName","com.microsoft.sqlserver.jdbc.SQLServerDriver");
ds.getDriverProperties().put( "user", "xxxxxxx" );
ds.getDriverProperties().put( "password", "xxxxxxxx" );
ds.getDriverProperties().put( "url", "mySqlServerUrl..." );
replace the driverClassName, user, password, and url for your setup. I
am using SQLServer, but I guess you are on MySql.
After that the JPA stuff works, and persistence works as advertised.
This is the only setup that worked for me. I tried creating the
datasource from Spring but that didn't work either.
Please let me know what you find out.
Thanks
2010/9/3 Pablo Nussembaum <baunax(a)gmail.com>:
You need to configure bitronix[0] to provide JTA. Or use
drools-spring that
allows you to use drools-persisntece-jpa without JTA.
[0] http://docs.codehaus.org/display/BTM/Tomcat13
On 09/03/2010 08:53 AM, liang wrote:
i found that tomcat 6 have not JTA,which server is able to persistence?
在 2010年9月3日 下午12:02，liang <zhuyx808(a)gmail.xn--com>:-0s6m5392c
>
> 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 <esteban.aliverti(a)gmail.com>
>>
>> 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 亮亮 <zhuyx808(a)gmail.com>
>>>
>>> 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
>>> rules-users(a)lists.jboss.org
>>> https://lists.jboss.org/mailman/listinfo/rules-users
>>>
>>
>>
>> _______________________________________________
>> rules-users mailing list
>> rules-users(a)lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
9:40 p.m.
hi gustavo,
has a big different between tomcat5.5 and tomcat6? According to your guide,i
cannot bind JNDI,maybe i must set resource in tomcat conf/context.xml, i am
confusing……can you send a example to me?THS
在 2010年9月3日 下午11:49，Gustavo Tenrreiro <gustavo(a)tenrreiro.xn--com>:-0s6m5392c
If it helps at all; I spent almost a full week trying to get JPA to
work with Tomcat 5.5 + Hibernate + Bitronix and this is what I found.
The instructions for Bitronix in
http://docs.codehaus.org/display/BTM/Tomcat13 did not help me much.
The datasource that gets created via the resource.properties could
never be found.
- So to get it to work, do deploy the Bitronix jar files into your
server / context
- In the Tomcat conf/context.xml I do have "<Transaction
factory="bitronix.tm.BitronixUserTransactionObjectFactory" />" but I
am not sure if it is required ( haven't tested removing it ).
- In the web.xml I do have:
<resource-env-ref>
<resource-env-ref-name>java:comp/env/jdbc/processInstanceDS</resource-env-ref-name>
<resource-env-ref-type>javax.sql.DataSource</resource-env-ref-type>
</resource-env-ref>
where jdbc/processInstanceDS is your jdbc/mysql
- In the Hibernate persistence.xml I do have:
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.BTMTransactionManagerLookup" />
<property name="hibernate.jndi.class"
value="bitronix.tm.jndi.BitronixInitialContextFactory" />
although I don't think it is using the jndi.class specified there, so
the second line might be redundant.
Then in my code I create the datasource by hand ( in a
ServletContextListener ):
PoolingDataSource ds = new PoolingDataSource();
ds.setUniqueName( "jdbc/processInstanceDS" );
ds.setClassName(
"bitronix.tm.resource.jdbc.lrc.LrcXADataSource");
ds.setMaxPoolSize( 3 );
ds.setAllowLocalTransactions( true );
ds.getDriverProperties().put("driverClassName","com.microsoft.sqlserver.jdbc.SQLServerDriver");
ds.getDriverProperties().put( "user",
"xxxxxxx" );
ds.getDriverProperties().put( "password",
"xxxxxxxx"
);
ds.getDriverProperties().put( "url",
"mySqlServerUrl..." );
replace the driverClassName, user, password, and url for your setup. I
am using SQLServer, but I guess you are on MySql.
After that the JPA stuff works, and persistence works as advertised.
This is the only setup that worked for me. I tried creating the
datasource from Spring but that didn't work either.
Please let me know what you find out.
Thanks
2010/9/3 Pablo Nussembaum <baunax(a)gmail.com>:
> You need to configure bitronix[0] to provide JTA. Or use drools-spring
that
> allows you to use drools-persisntece-jpa without JTA.
>
> [0] http://docs.codehaus.org/display/BTM/Tomcat13
> On 09/03/2010 08:53 AM, liang wrote:
>
> i found that tomcat 6 have not JTA,which server is able to persistence?
>
> 在 2010年9月3日 下午12:02，liang <zhuyx808(a)gmail.xn--com>:-0s6m5392c
>>
>> 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 <esteban.aliverti(a)gmail.com>
>>>
>>> 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 亮亮 <zhuyx808(a)gmail.com>
>>>>
>>>> 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
>>>> rules-users(a)lists.jboss.org
>>>> https://lists.jboss.org/mailman/listinfo/rules-users
>>>>
>>>
>>>
>>> _______________________________________________
>>> rules-users mailing list
>>> rules-users(a)lists.jboss.org
>>> https://lists.jboss.org/mailman/listinfo/rules-users
>>>
>>
>
>
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
2:26 a.m.
i had solve it.
In the Tomcat conf/context.xml or webapp/meta-inf/content.xml "<Transaction
factory="bitronix.tm.BitronixUserTransactionObjectFactory" />" its
required
:
<Context>
<Transaction factory="bitronix.tm.BitronixUserTransactionObjectFactory"
/>
<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>
webapp/web-inf/web.xml:
<resource-env-ref>
<resource-env-ref-name>jdbc/mysql</resource-env-ref-name>
<resource-env-ref-type>javax.sql.DataSource</resource-env-ref-type>
</resource-env-ref>
thanks,everyone
在 2010年9月6日 上午10:40，liang <zhuyx808(a)gmail.xn--com>:-0s6m5392c
hi gustavo,
has a big different between tomcat5.5 and tomcat6? According to your
guide,i cannot bind JNDI,maybe i must set resource in tomcat
conf/context.xml, i am confusing……can you send a example to me?THS
在 2010年9月3日 下午11:49，Gustavo Tenrreiro <gustavo(a)tenrreiro.xn--com>:-0s6m5392c
If it helps at all; I spent almost a full week trying to get JPA to
> work with Tomcat 5.5 + Hibernate + Bitronix and this is what I found.
>
> The instructions for Bitronix in
> http://docs.codehaus.org/display/BTM/Tomcat13 did not help me much.
> The datasource that gets created via the resource.properties could
> never be found.
>
> - So to get it to work, do deploy the Bitronix jar files into your
> server / context
>
> - In the Tomcat conf/context.xml I do have "<Transaction
> factory="bitronix.tm.BitronixUserTransactionObjectFactory" />" but
I
> am not sure if it is required ( haven't tested removing it ).
>
> - In the web.xml I do have:
>
> <resource-env-ref>
>
>
<resource-env-ref-name>java:comp/env/jdbc/processInstanceDS</resource-env-ref-name>
> <resource-env-ref-type>javax.sql.DataSource</resource-env-ref-type>
> </resource-env-ref>
>
> where jdbc/processInstanceDS is your jdbc/mysql
>
> - In the Hibernate persistence.xml I do have:
>
> <property name="hibernate.transaction.manager_lookup_class"
> value="org.hibernate.transaction.BTMTransactionManagerLookup" />
> <property name="hibernate.jndi.class"
> value="bitronix.tm.jndi.BitronixInitialContextFactory" />
>
> although I don't think it is using the jndi.class specified there, so
> the second line might be redundant.
>
> Then in my code I create the datasource by hand ( in a
> ServletContextListener ):
>
> PoolingDataSource ds = new PoolingDataSource();
> ds.setUniqueName( "jdbc/processInstanceDS" );
> ds.setClassName(
> "bitronix.tm.resource.jdbc.lrc.LrcXADataSource");
> ds.setMaxPoolSize( 3 );
> ds.setAllowLocalTransactions( true );
>
>
ds.getDriverProperties().put("driverClassName","com.microsoft.sqlserver.jdbc.SQLServerDriver");
> ds.getDriverProperties().put( "user",
"xxxxxxx" );
> ds.getDriverProperties().put( "password",
> "xxxxxxxx" );
> ds.getDriverProperties().put( "url",
> "mySqlServerUrl..." );
>
> replace the driverClassName, user, password, and url for your setup. I
> am using SQLServer, but I guess you are on MySql.
>
> After that the JPA stuff works, and persistence works as advertised.
> This is the only setup that worked for me. I tried creating the
> datasource from Spring but that didn't work either.
>
> Please let me know what you find out.
>
> Thanks
>
>
> 2010/9/3 Pablo Nussembaum <baunax(a)gmail.com>:
> > You need to configure bitronix[0] to provide JTA. Or use drools-spring
> that
> > allows you to use drools-persisntece-jpa without JTA.
> >
> > [0] http://docs.codehaus.org/display/BTM/Tomcat13
> > On 09/03/2010 08:53 AM, liang wrote:
> >
> > i found that tomcat 6 have not JTA,which server is able to persistence?
> >
> > 在 2010年9月3日 下午12:02，liang <zhuyx808(a)gmail.xn--com>:-0s6m5392c
> >>
> >> 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 <esteban.aliverti(a)gmail.com>
> >>>
> >>> 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 亮亮 <zhuyx808(a)gmail.com>
> >>>>
> >>>> 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
> >>>> rules-users(a)lists.jboss.org
> >>>> https://lists.jboss.org/mailman/listinfo/rules-users
> >>>>
> >>>
> >>>
> >>> _______________________________________________
> >>> rules-users mailing list
> >>> rules-users(a)lists.jboss.org
> >>> https://lists.jboss.org/mailman/listinfo/rules-users
> >>>
> >>
> >
> >
> > _______________________________________________
> > rules-users mailing list
> > rules-users(a)lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/rules-users
> >
> >
> > _______________________________________________
> > rules-users mailing list
> > rules-users(a)lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/rules-users
> >
> >
>
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
5002
days inactive
5009
days old
8 comments
6 participants
participants (6)
-
Esteban Aliverti -
Gustavo Tenrreiro -
liang -
Michael Anstis -
Pablo Nussembaum -
亮亮