JBPM4.4使用jotm的JNDI连接池及JTA事务问题

0 0

JBPM4.4使用jotm的JNDI连接池及JTA事务问题40

公司现有的平台用JNDI连接池和jotm的JTA控制事务，在整合JBPM4.4的时候事务处理总是有问题。
公司平台没有用hibernate和Spring，现在主要是连接池必须用tomcate的连接池，事务控制可以用jbpm的。
jbpm.hibernate.cfg.xml的配置如下

<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.datasource">java:comp/env/oa</property>

tomcate配置如下

<Context path="/" docBase="D:\jbpm-4.4\workspace\OA\WebContent" debug="0" workDir="work\Catalina\localhost\oa">
  <Resource name="oa"  auth="Container"    
					type="javax.sql.DataSource"       
					  driverClassName="oracle.jdbc.OracleDriver" 
					  url="jdbc:oracle:thin:@192.168.0.37:1521:scm" 
						username="jbpm4" 
 					  password="1" 
					  max="200"
					  min="20" 
					  maxWait="10000"
					  factory="org.objectweb.jndi.DataSourceFactory" />
	<Transaction factory="org.objectweb.jotm.UserTransactionFactory" jotm.timeout="60"/>
</Context>

在创建实例的时候报错

2012-3-11 11:41:57 org.hibernate.transaction.JDBCTransaction rollback
良好: rolled back JDBC Connection
java.lang.NullPointerException
	at oracle.jdbc.dbaccess.DBData.clearItem(DBData.java:431)
	at oracle.jdbc.dbaccess.DBDataSetImpl.clearItem(DBDataSetImpl.java:3528)
	at oracle.jdbc.driver.OraclePreparedStatement.clearParameters(OraclePreparedStatement.java:3401)
	at org.enhydra.jdbc.standard.StandardXAConnectionHandle.checkPreparedCache(StandardXAConnectionHandle.java:161)
	at org.enhydra.jdbc.standard.StandardXAPreparedStatement.<init>(StandardXAPreparedStatement.java:62)
	at org.enhydra.jdbc.standard.StandardXAConnectionHandle.prepareStatement(StandardXAConnectionHandle.java:321)
	at org.enhydra.jdbc.standard.StandardXAConnectionHandle.prepareStatement(StandardXAConnectionHandle.java:255)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)
	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
	at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
	at org.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:56)
	at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:107)
	at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:64)
	at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:57)
	at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
	at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
	at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
	at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
	at org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:79)
	at et.jbpm.bc.wf.LeaveBO.onSubmit(LeaveBO.java:265)
	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 et.common.facade.CCommonFascadeImpl.invokeBusinessImpl(CCommonFascadeImpl.java:59)
	at et.common.facade.CCommonFascadeImpl.invokeBusinessImpl(CCommonFascadeImpl.java:67)
	at et.common.servlet.WebPageSubmitAction.performTask(WebPageSubmitAction.java:110)
	at et.common.servlet.BaseServlet.doPost(BaseServlet.java:280)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	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 et.common.servlet.ConfigKeyFilter.doFilter(ConfigKeyFilter.java:116)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	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:291)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
	at java.lang.Thread.run(Thread.java:619)

如果指定jbpm使用JTA控制事务在jbpm.cfg.xml中修改为
<import resource="jbpm.tx.jta.cfg.xml" />
在jbpm.hibernate.cfg.xml的配置如下

<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.datasource">java:comp/env/oa</property>
<property name="current_session_context_class">jta</property>
<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property><property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.TransactionManagerLookup</property>

创建实例时提示无法创建Transaction实例。修改TransacationManager为jotm的也不行。
下面使用jotm控制事务的描述可能不清晰，但目前只希望用jndi连接没问题，如果有大拿指点感激不尽。
没怎么用过hibernate，对jotm和JTA的了解也不是很清楚，有小白的地方请见谅。

--------------------------------华丽的分割线---------------------------------------
使用jndi连接池的问题解决了，换了一个10G的ojdbc14驱动
希望有高手能指点下用jotm控制hibernate的事务