AnsweredAssumed Answered

{error} exception when ending process

Question asked by schitale on Sep 24, 2013
Latest reply on Sep 30, 2013 by jbarrez
I keep getting this error all the time. What exactly is going wrong?

I'm using WL datasource with JTA transaction.

WARNING: Exception or error caught in resource
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: java.sql.SQLException: Connection has already been closed.
### SQL: insert into ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_)     values (       ?,       ?,       ?,       ?,       ?,       ?,       ?,       ?,       ?,       ?,       ?,       ?     )
### Cause: java.sql.SQLException: Connection has already been closed.
                at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:150)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:137)
                at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:538)
                at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:441)
                at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:169)
                at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:116)
                at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:70)
                at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
                at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
                at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
                at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
                at org.activiti.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:167)
                at org.activiti.rest.api.runtime.task.TaskResource.completeTask(TaskResource.java:131)
                at org.activiti.rest.api.runtime.task.TaskResource.executeTaskAction(TaskResource.java:80)

Caused by: java.sql.SQLException: Connection has already been closed.
                at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:55)
                at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:92)
                at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:482)
                at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:597)
                at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:239)
                at com.sun.proxy.$Proxy73.prepareStatement(Unknown Source)
                at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:72)
                at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:82)
                at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:54)
                at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:70)
                at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:44)
                at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)
                at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)

Outcomes