PersistenceException: Unable to locate a java.sql.Connection

Solution Verified - Updated -

Issue

  • We have seen some strange performance/instability issues with our application within JBoss which has impacted our business severely. Would you be able to assist? We have seen the following errors are are trying to understand what they may mean?

  • Errors shown in the core application server process ( DataServer )


[LOG|ERROR|04 Jun 2015 03:54:38,013|DateRuleSQL$DateRuleLoader|EJB remoting -****/test] Error when executing SELECT a.b,c FROM date_rule WHERE test = ? [END] PersistenceException: Unable to locate a java.sql.Connection at ConnectionManager.getConnection(ConnectionManager.java:68) at Test.getTest1(CacheServer.java:2527)
  • Exception in the batch job ; looks like transaction resource issue within Jboss/TestDS
[LOG|ERROR|04 Jun 2015 03:54:54,747|
Could not process Cash Settlement for account '***@*** (***)' *** '***' *** '***' and valuation datetime ' EDT': Error invoking service 
[END] 
java.lang.RuntimeException: Error invoking service ejb:
at RemoteEjbInvocationHandler.invoke(RemoteEjbInvocationHandler.java:229) 
at com.sun.proxy.$Proxy48.saveTrades(Unknown Source) 
java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction

WARN  [com.arjuna.ats.arjuna] (Transaction Reaper) ARJUNA012117: TransactionReaper::check timeout for TX  in state  RUN

 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012095: Abort of action id  invoked while multiple threads active within it.
 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012108: CheckedAction::check - atomic action aborting with 1 threads active!
WARN  [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012121: TransactionReaper::doCancellations worker Thread[Transaction Reaper Worker 0,5,main] successfully canceled TX 
WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 9) SQL Error: 0, SQLState: null
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 9) javax.resource.ResourceException: IJ000460: Error checking for a transaction
ERROR (EJB default - 9) org.hibernate.exception.GenericJDBCException: Could not open connection
javax.resource.ResourceException: IJ000459: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff80a4659b:-135ae44c:556af8a2:2e67705 status: ActionStatus.ABORTED >
...
...
javax.transaction.RollbackException: ARJUNA016102: The transaction is not active! Uid is 0:ffff80a4659b:-135ae44c:556af8a2:2e67705
....
....
04:32:40,251 INFO  [org.jboss.jca.core.api.connectionmanager.ccm.CachedConnectionManager] (EJB remoting - 94) IJ000100: Closing a connection for you. Please close them yourself: org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@203e1ea2: java.lang.Throwable: STACKTRACE
....
....
 IJ000100: Closing a connection for you. Please close them yourself: org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@6f10dfe0: java.lang.Throwable: STACKTRACE
....
....

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 6.1.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content