<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
JBPM4 connection problem
</h3>
<span style="margin-bottom: 10px;">
reply from <a href="http://community.jboss.org/people/egycator">Khaled Talaat</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/533520#533520">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I have been trying to configure the JBPM to work with my application but I still getting this exception</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><div id="_mcePaste">16:51:30,552 INFO  [CachedConnectionManager] Closing a connection for you.  Please close them yourself: org.jboss.resour</div><div id="_mcePaste">ce.adapter.jdbc.jdk5.WrappedConnectionJDK5@c8ea27</div><div id="_mcePaste">java.lang.Throwable: STACKTRACE</div><div id="_mcePaste">        at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:</div><div id="_mcePaste">278)</div><div id="_mcePaste">        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:52</div><div id="_mcePaste">4)</div><div id="_mcePaste">        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseCon</div><div id="_mcePaste">nectionManager2.java:941)</div><div id="_mcePaste">        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)</div><div id="_mcePaste">        at com.asset.jupiter.jbpm.handlers.MainTaskHandler.excuteQuery(MainTaskHandler.java:169)</div><div id="_mcePaste">        at com.asset.jupiter.jbpm.handlers.MainTaskHandler.notify(MainTaskHandler.java:59)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.wire.usercode.UserCodeEventListener.notify(UserCodeEventListener.java:39)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.model.op.ExecuteEventListener.perform(ExecuteEventListener.java:81)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(ExecutionImpl.java:656)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperation(ExecutionImpl.java:616)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.model.ExecutionImpl.start(ExecutionImpl.java:217)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:61)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:37)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.tx.JtaTransactionInterceptor.executeInExistingTx(JtaTransactionInterceptor.java:70)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.tx.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:55)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.tx.JtaRetryInterceptor.executeWithoutRetry(JtaRetryInterceptor.java:56)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.tx.JtaRetryInterceptor.execute(JtaRetryInterceptor.java:48)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)</div><div id="_mcePaste">        at org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceById(ExecutionServiceImpl.java:50)</div><div id="_mcePaste">        at com.asset.jupiter.client.workflow.jbpm.jbpm4.WorkflowV4.startProcessInstanceEx(WorkflowV4.java:93)</div><div id="_mcePaste">        at com.asset.jupiter.client.workflow.jbpm.jbpm4.JBPMv4WFHandler.createProcessInstance(JBPMv4WFHandler.java:712)</div><div id="_mcePaste">        at com.asset.jupiter.client.workflow.core.WorkflowService.wfCreateProcessInstance(WorkflowService.java:549)</div><div id="_mcePaste">        at com.asset.jupiter.client.workflow.ejb.WorkflowEJBBean.createProcessInstance(WorkflowEJBBean.java:357)</div><div id="_mcePaste">        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div><div id="_mcePaste">        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</div><div id="_mcePaste">        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div><div id="_mcePaste">        at java.lang.reflect.Method.invoke(Method.java:597)</div><div id="_mcePaste">        at org.jboss.invocation.Invocation.performCall(Invocation.java:386)</div><div id="_mcePaste">        at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:606)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.StatefulSessionSecurityInterceptor.invoke(StatefulSessionSecurityInterceptor.java:84)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)</div><div id="_mcePaste">        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156)</div><div id="_mcePaste"> </div><div id="_mcePaste">        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:173)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:77)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:348)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java:97)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java:81)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)</div><div id="_mcePaste">        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)</div><div id="_mcePaste">        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)</div><div id="_mcePaste">        at org.jboss.ejb.Container.invoke(Container.java:1029)</div><div id="_mcePaste">        at sun.reflect.GeneratedMethodAccessor300.invoke(Unknown Source)</div><div id="_mcePaste">        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div><div id="_mcePaste">        at java.lang.reflect.Method.invoke(Method.java:597)</div><div id="_mcePaste">        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)</div><div id="_mcePaste">        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)</div><div id="_mcePaste">        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)</div><div id="_mcePaste">        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)</div><div id="_mcePaste">        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)</div><div id="_mcePaste">        at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)</div><div id="_mcePaste">        at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)</div><div id="_mcePaste">        at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)</div><div id="_mcePaste">        at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)</div><div id="_mcePaste">        at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)</div><div id="_mcePaste">        at org.jboss.proxy.ejb.SecurityContextInterceptor.invoke(SecurityContextInterceptor.java:64)</div><div id="_mcePaste">        at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:68)</div><div id="_mcePaste">        at org.jboss.proxy.ejb.StatefulSessionInterceptor.invoke(StatefulSessionInterceptor.java:118)</div><div id="_mcePaste">        at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:101)</div><div id="_mcePaste">        at $Proxy348.createProcessInstance(Unknown Source)</div><div id="_mcePaste">        at com.asset.jupiter.client.wrapper.JCSynchronizedEJB.createProcessInstance(JCSynchronizedEJB.java:696)</div><div id="_mcePaste">        at com.asset.jupiter.client.web.handler.WorkFlowEJBHandler.createAndStartProcessInstance(WorkFlowEJBHandler.java</div><div id="_mcePaste">:1960)</div><div id="_mcePaste">        at com.asset.jupiter.client.web.handler.WorkFlowEJBHandler.processEvent(WorkFlowEJBHandler.java:141)</div><div id="_mcePaste">        at com.asset.jupiter.client.web.control.RequestProcessor.handleAction(RequestProcessor.java:152)</div><div id="_mcePaste">        at com.asset.jupiter.client.web.control.RequestProcessor.processRequest(RequestProcessor.java:87)</div><div id="_mcePaste">        at com.asset.jupiter.client.web.control.MainServlet.processRequest(MainServlet.java:333)</div><div id="_mcePaste">        at com.asset.jupiter.client.web.control.MainServlet.performTask(MainServlet.java:123)</div><div id="_mcePaste">        at com.asset.jupiter.client.web.control.MainServlet.doGet(MainServlet.java:50)</div><div id="_mcePaste">        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)</div><div id="_mcePaste">        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</div><div id="_mcePaste">        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)</div><div id="_mcePaste">        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</div><div id="_mcePaste">        at com.asset.jupiter.client.web.filter.GZIPFilter.doFilter(GZIPFilter.java:50)</div><div id="_mcePaste">        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)</div><div id="_mcePaste">        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</div><div id="_mcePaste">        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)</div><div id="_mcePaste">        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)</div><div id="_mcePaste">        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</div><div id="_mcePaste">        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)</div><div id="_mcePaste">        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)</div><div id="_mcePaste">        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)</div><div id="_mcePaste">        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)</div><div id="_mcePaste">        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.jav</div><div id="_mcePaste">a:126)</div><div id="_mcePaste">        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java</div><div id="_mcePaste">:70)</div><div id="_mcePaste">        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</div><div id="_mcePaste">        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)</div><div id="_mcePaste">        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)</div><div id="_mcePaste">        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)</div><div id="_mcePaste">        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)</div><div id="_mcePaste">        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)</div><div id="_mcePaste">        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)</div><div id="_mcePaste">        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)</div><div id="_mcePaste">        at java.lang.Thread.run(Thread.java:619)</div><div> </div><div>My jbpm.hibernate.cfg.xml</div><div><div><hibernate-configuration></div><div><span> </span><session-factory></div><div> </div><div><span> </span><property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property></div><div><span> </span><property name="hibernate.connection.datasource">java:JbpmDS</property></div><div><span> </span><property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property></div><div><span> </span><property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property></div><div><span> </span><property name="jta.UserTransaction">UserTransaction</property></div><div> </div><div><span> </span><mapping resource="jbpm.repository.hbm.xml" /></div><div><span> </span><mapping resource="jbpm.execution.hbm.xml" /></div><div><span> </span><mapping resource="jbpm.history.hbm.xml" /></div><div><span> </span><mapping resource="jbpm.task.hbm.xml" /></div><div><span> </span><mapping resource="jbpm.identity.hbm.xml" /></div><div> </div><div><span> </span></session-factory></div><div></hibernate-configuration></div></div><div> </div><div>The JBPM datasource </div><div><div>  <xa-datasource></div><div>    <jndi-name>JbpmDS</jndi-name></div><div> </div><div>    <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class></div><div>    <xa-datasource-property name="URL">jdbc:mysql://localhost:3306/jbpmdb</xa-datasource-property></div><div>    <user-name>root</user-name></div><div>    <password>a</password></div><div> </div><div>    <!-- reduce isolation from the default level (repeatable read) --></div><div>    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation></div><div>    <!-- separate connections used with and without JTA transaction --></div><div>    <no-tx-separate-pools /></div><div>    <!-- disable transaction interleaving --></div><div>    <track-connection-by-tx /></div><div> </div><div>    <!-- leverage mysql integration features --></div><div>    <exception-sorter-class-name></div><div>      com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</div><div>    </exception-sorter-class-name></div><div>    <valid-connection-checker-class-name></div><div>      com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</div><div>    </valid-connection-checker-class-name></div><div> </div><div>    <!-- corresponding type-mapping in conf/standardjbosscmp-jdbc.xml --></div><div>    <metadata></div><div>      <type-mapping>mySQL</type-mapping></div><div>    </metadata></div><div>  </xa-datasource></div></div><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>My application datasources are all no-tx-datasource</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/533520#533520">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>