java.sql.SQLException: Closed Connection


Solutions on the web11

Solution icon of googlegroups
via Google Groups by Akshay Garg, 9 months ago
Closed Connection

Solution icon of github
Closed Connection

Solution icon of googlegroups
Closed Connection

Solution icon of googlegroups
via Google Groups by Jose María Zaragoza, 1 year ago
Connection oracle.jdbc.driver.T4CConnection@6bb58366 is closed.

Solution icon of stackoverflow
I/O Error: Socket closed

Solution icon of github
HikariPool-4 - Interrupted during connection acquisition

Solution icon of googlegroups
via Google Groups by jdevelop, 9 months ago
Error accessing PooledConnection. Connection is invalid.

Solution icon of oraclecommunity
via Oracle Community by chris.joelly, 1 year ago
Error in allocating a connection. Cause: java.lang.RuntimeException: Got exception during XAResource.start:

Solution icon of web
Connection is read-only. Queries leading to data modification are not allowed

Solution icon of oraclecommunity
via Oracle Community by chris.joelly, 1 year ago
Error in allocating a connection. Cause: java.lang.RuntimeException: Got exception during XAResource.start:

Stack trace

java.sql.SQLException: Closed Connection
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:111)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)
	at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:86)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:164)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:156)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:152)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:141)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:165)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:55)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:38)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:97)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32)[camunda-engine-7.3.0.jar:7.3.0]
	at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.run(SequentialJobAcquisitionRunnable.java:64)[camunda-engine-7.3.0.jar:7.3.0]
	at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)[jboss-threads-2.1.0.Final-redhat-1.jar:2.1.0.Final-redhat-1]
	at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806)[jboss-threads-2.1.0.Final-redhat-1.jar:2.1.0.Final-redhat-1]
	at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)[jboss-threads-2.1.0.Final-redhat-1.jar:2.1.0.Final-redhat-1]
	at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826)[jboss-threads-2.1.0.Final-redhat-1.jar:2.1.0.Final-redhat-1]
	at java.lang.Thread.run(Thread.java:724)[rt.jar:1.7.0_25]
	at org.jboss.threads.JBossThread.run(JBossThread.java:122)[jboss-threads-2.1.0.Final-redhat-1.jar:2.1.0.Final-redhat-1]
Caused by: java.sql.SQLException: Closed Connection
	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
	at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3127)
	at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:738)
	at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:724)
	at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:405)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:75)
	at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:85)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:57)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:73)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:59)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)
	... 20 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 weeks ago
Samebug visitor profile picture
Unknown user
Once, 2 weeks ago
Samebug visitor profile picture
Unknown user
Once, 3 weeks ago
Samebug visitor profile picture
Unknown user
Once, 3 weeks ago
360 more bugmates