java.sql.SQLException: ORA-01002

Issue

• During execution of a high load test on a distributed application using 2 JBoss EAP 6.2 Servers with remote EJB calls and XA Transactions on Oracle 11g Enterprise Edition (11.2.0.4.0) database we often get ORA -01002 Errors as following :

Caused by: java.sql.SQLException: ORA-01002

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
....

Caused by: java.sql.SQLRecoverableException: 

at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:5416)
at oracle.jdbc.driver.T4CXAResource.doTransaction(T4CXAResource.java:744)
    at oracle.jdbc.driver.T4CXAResource.doRollback(T4CXAResource.java:624)
    at oracle.jdbc.xa.client.OracleXAResource.rollback(OracleXAResource.java:936)
    ... 17 more

2015-07-15 10:38:24,076 583566129 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (EJB default - 10:) IJ000607: ResourceException cleaning up managed connection: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@62e79a26[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@53396784 connection handles=0 lastUse=1436949504029 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@20a6dad pool internal context=SemaphoreArrayListManagedConnectionPool@4d97d34e[pool=TestDS] xaResource=XAResourceWrapperImpl@6d45e8c8[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@53396784 pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning option jndiName=java:jboss/datasources/TestDS] txSync=null]: javax.resource.ResourceException: Still active locks
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.cleanup(BaseWrapperManagedConnection.java:373)
    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.returnConnection(SemaphoreArrayListManagedConnectionPool.java:442)
....
....