PersistenceException: Unable to locate a java.sql.Connection
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.