<!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="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss 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;">
Intermittent JCA adapter issues with JBOSS7.1.1 using ojdbc6 driver for Oracle10g
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/ion_mayank">Mayank Gupta</a> in <i>IronJacamar</i> - <a href="https://community.jboss.org/message/755279#755279">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hello,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I have ported my application from JBOSS6 to JBOSS7.1.1 (code base is same).</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>My application is extensively using EJB and JMS messaging. HornetQ is the Messaging provider on both JBOSS6 and JBOSS7. Oracle 10g R2 is my database.</p><p>Till JBOSS6 I was using ojdbc14 driver (my java version was Java6). On JBOSS7 I am forced to upgrade my driver to ojdbc6 as JBOSS server does not configure 1.4 driver when JAVA version is 6.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Listing 2 of the issues for which I am unable to find any solution:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>1. Intermittently I keep on getting ORA:01002 Fetch Out of sequence error. I am using apache common-dbutils.jar for queries from UI and hibernate for backend queries. On both scenarios I am getting this exception. (same code is working on JBOSS6).</p><p>     --> Is JBOSS7 tested with ojdbc6 driver, could this be a driver issue? As JBOSS7 does not allow ojdbc14 driver I am unable to verfiy it.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>2. When a transaction is started from EJB session and it sends a message to a HornetQ, it sometimes fails (again this failure also does not occur always).</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>StackTrace for Problem2:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>2012-08-22 12:38:24,397 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] IJ000607: ResourceException cleaning up managed connection: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@6765403b[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3daf4754 connection handles=0 lastUse=1345619303912 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@3e73fb6f pool internal context=SemaphoreArrayListManagedConnectionPool@30805471[pool=Tx_Pool] xaResource=XAResourceWrapperImpl@285c1685[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3daf4754 pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 10g Release 10.2.0.5.0 - 64bit Production jndiName=java:/com/datasources/XADataSource] txSync=null]: javax.resource.ResourceException: Still active locks</p><p>  at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.cleanup(BaseWrapperManagedConnection.java:352)</p><p>  at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.returnConnection(SemaphoreArrayListManagedConnectionPool.java:429)</p><p>  at org.jboss.jca.core.connectionmanager.pool.AbstractPool.returnConnection(AbstractPool.java:561)</p><p>  at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.returnManagedConnection(AbstractConnectionManager.java:425)</p><p>  at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.connectionClosed(TxConnectionListener.java:367)</p><p>  at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:517)</p><p>  at org.jboss.jca.adapters.jdbc.WrappedConnection.close(WrappedConnection.java:264)</p><p>  at com.utility.preparedstatementhelper.PreparedStatementHelper.closeConnectionAndPreparedStatements(PreparedStatementHelper.java:208)</p><p>  at com.component.result.Result.persist(Result.java:629)</p><p>  at com.ejb.resultmanager.ResultManagerEJB.persistResult(ResultManagerEJB.java:97)</p><p>  at sun.reflect.GeneratedMethodAccessor276.invoke(Unknown Source)</p><p>  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</p><p>  at java.lang.reflect.Method.invoke(Method.java:597)</p><p>  at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)</p><p>  at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)</p><p>  at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:201)</p><p>  at org.jboss.as.ejb3.tx.CMTTxInterceptor.mandatory(CMTTxInterceptor.java:256)</p><p>  at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:183)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:42)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.interceptors.EjbExceptionTransformingInterceptorFactories$2.processInvocation(EjbExceptionTransformingInterceptorFactories.java:89)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)</p><p>  at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)</p><p>  at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:181)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)</p><p>  at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)</p><p>  at com.ejb.resultmanager.ResultManagerLocal$$$view114.persistResult(Unknown Source)</p><p>  at com.ejb.eventprocessor.PersistenceAction.processEvent(PersistenceAction.java:130)</p><p>  at com.ejb.eventprocessor.EventProcessor.performActionsOn(EventProcessor.java:158)</p><p>  at com.ejb.eventprocessor.EventProcessor.processMessage(EventProcessor.java:99)</p><p>  at com.ejb.eventprocessor.EventProcessorMDB.onMessage(EventProcessorMDB.java:90)</p><p>  at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)</p><p>  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</p><p>  at java.lang.reflect.Method.invoke(Method.java:597)</p><p>  at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)</p><p>  at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)</p><p>  at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:201)</p><p>  at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:305)</p><p>  at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:189)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:42)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:43)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ejb3.component.messagedriven.MessageDrivenComponentDescription$5$1.processInvocation(MessageDrivenComponentDescription.java:184)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)</p><p>  at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)</p><p>  at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:181)</p><p>  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)</p><p>  at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)</p><p>  at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)</p><p>  at javax.jms.MessageListener$$$view25.onMessage(Unknown Source)</p><p>  at sun.reflect.GeneratedMethodAccessor272.invoke(Unknown Source)</p><p>  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</p><p>  at java.lang.reflect.Method.invoke(Method.java:597)</p><p>  at org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.doInvoke(MessageEndpointInvocationHandler.java:142)</p><p>  at org.jboss.as.ejb3.inflow.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:73)</p><p>  at $Proxy28.onMessage(Unknown Source)</p><p>  at org.hornetq.ra.inflow.HornetQMessageHandler.onMessage(HornetQMessageHandler.java:311)</p><p>  at org.hornetq.core.client.impl.ClientConsumerImpl.callOnMessage(ClientConsumerImpl.java:1028)</p><p>  at org.hornetq.core.client.impl.ClientConsumerImpl.access$400(ClientConsumerImpl.java:50)</p><p>  at org.hornetq.core.client.impl.ClientConsumerImpl$Runner.run(ClientConsumerImpl.java:1173)</p><p>  at org.hornetq.utils.OrderedExecutorFactory$OrderedExecutor$1.run(OrderedExecutorFactory.java:100)</p><p>  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)</p><p>  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)</p><p>  at java.lang.Thread.run(Thread.java:662)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>2012-08-22 12:38:24,652 WARN  [com.arjuna.ats.jta] ARJUNA016041: prepare on < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a82dca:6a3d0e3d:503482e2:2ccf, node_name=1, branch_uid=0:ffffc0a82dca:6a3d0e3d:503482e2:2cd4, subordinatenodename=null, eis_name=java:/com/datasources/XADataSource > (XAResourceWrapperImpl@285c1685[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3daf4754 pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 10g Release 10.2.0.5.0 - 64bit Production jndiName=java:/com/datasources/XADataSource]) failed with exception XAException.XAER_RMFAIL: oracle.jdbc.xa.OracleXAException</p><p>  at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1033)</p><p>  at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)</p><p>  at oracle.jdbc.xa.OracleXAResource.resumeStacked(OracleXAResource.java:452)</p><p>  at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:399)</p><p>  at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:295)</p><p>  at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.end(XAResourceWrapperImpl.java:99)</p><p>  at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelPrepare(XAResourceRecord.java:208)</p><p>  at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2537)</p><p>  at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2504)</p><p>  at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2081)</p><p>  at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1474)</p><p>  at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:98)</p><p>  at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:164)</p><p>  at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1165)</p><p>  at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:117)</p><p>  at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)</p><p>  at org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.afterDelivery(MessageEndpointInvocationHandler.java:74)</p><p>  at sun.reflect.GeneratedMethodAccessor277.invoke(Unknown Source)</p><p>  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</p><p>  at java.lang.reflect.Method.invoke(Method.java:597)</p><p>  at org.jboss.as.ejb3.inflow.AbstractInvocationHandler.handle(AbstractInvocationHandler.java:60)</p><p>  at org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.doInvoke(MessageEndpointInvocationHandler.java:138)</p><p>  at org.jboss.as.ejb3.inflow.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:73)</p><p>at $Proxy28.afterDelivery(Unknown Source)</p><p>  at org.hornetq.ra.inflow.HornetQMessageHandler.onMessage(HornetQMessageHandler.java:320)</p><p>  at org.hornetq.core.client.impl.ClientConsumerImpl.callOnMessage(ClientConsumerImpl.java:1028)</p><p>  at org.hornetq.core.client.impl.ClientConsumerImpl.access$400(ClientConsumerImpl.java:50)</p><p>  at org.hornetq.core.client.impl.ClientConsumerImpl$Runner.run(ClientConsumerImpl.java:1173)</p><p>  at org.hornetq.utils.OrderedExecutorFactory$OrderedExecutor$1.run(OrderedExecutorFactory.java:100)</p><p>  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)</p><p>  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)</p><p>  at java.lang.Thread.run(Thread.java:662)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Progress is completely struck because of these intemittent issues.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/755279#755279">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in IronJacamar at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2098">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>