org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Cause: org.postgresql.util.PSQLException: This connection has been closed.

alfresco.com | 6 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    [MNT-12127] Activiti workflows cannot be started anymore after DB connection was closed - Alfresco JIRA

    alfresco.com | 6 months ago
    org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Cause: org.postgresql.util.PSQLException: This connection has been closed.
  2. 0

    mybatis-user - 3.0.5

    nabble.com | 6 months ago
    org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Cause: java.sql.SQLException: Closed Connection

    Root Cause Analysis

    1. org.apache.ibatis.transaction.TransactionException

      Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Cause: org.postgresql.util.PSQLException: This connection has been closed.

      at org.apache.ibatis.exceptions.ExceptionFactory.wrapException()
    2. MyBatis
      DefaultSqlSession.close
      1. org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
      2. org.apache.ibatis.session.defaults.DefaultSqlSession.close(DefaultSqlSession.java:169)
      2 frames
    3. Activiti - Engine
      CommandContextInterceptor.execute
      1. org.activiti.engine.impl.db.DbSqlSession.close(DbSqlSession.java:669)
      2. org.activiti.engine.impl.interceptor.CommandContext.closeSessions(CommandContext.java:176)
      3. org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:148)
      4. org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:70)
      5. org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
      6. org.activiti.engine.impl.db.DbIdGenerator.getNewBlock(DbIdGenerator.java:41)
      7. org.activiti.engine.impl.db.DbIdGenerator.getNextId(DbIdGenerator.java:34)
      8. org.activiti.engine.impl.db.DbSqlSession.insert(DbSqlSession.java:111)
      9. org.activiti.engine.impl.persistence.entity.ExecutionEntity.insert(ExecutionEntity.java:1040)
      10. org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.newProcessInstance(ProcessDefinitionEntity.java:113)
      11. org.activiti.engine.impl.pvm.process.ProcessDefinitionImpl.createProcessInstanceForInitial(ProcessDefinitionImpl.java:63)
      12. org.activiti.engine.impl.pvm.process.ProcessDefinitionImpl.createProcessInstance(ProcessDefinitionImpl.java:53)
      13. org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.createProcessInstance(ProcessDefinitionEntity.java:71)
      14. org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.createProcessInstance(ProcessDefinitionEntity.java:102)
      15. org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:79)
      16. org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:36)
      17. org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
      18. org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:61)
      18 frames
    4. Activiti - Spring
      SpringTransactionInterceptor$1.doInTransaction
      1. org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
      1 frame
    5. Spring Tx
      TransactionTemplate.execute
      1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
      1 frame
    6. Activiti - Spring
      SpringTransactionInterceptor.execute
      1. org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
      1 frame
    7. Activiti - Engine
      RuntimeServiceImpl.startProcessInstanceById
      1. org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
      2. org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceById(RuntimeServiceImpl.java:79)
      2 frames
    8. org.alfresco.repo
      WorkflowServiceImpl.startWorkflow
      1. org.alfresco.repo.workflow.activiti.ActivitiWorkflowEngine.startWorkflow(ActivitiWorkflowEngine.java:988)
      2. org.alfresco.repo.workflow.WorkflowServiceImpl.startWorkflow(WorkflowServiceImpl.java:438)
      2 frames
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    10. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      3 frames
    11. org.alfresco.service
      WorkflowPermissionInterceptor.invoke
      1. org.alfresco.service.cmr.workflow.WorkflowPermissionInterceptor.invoke(WorkflowPermissionInterceptor.java:54)
      1 frame
    12. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      1 frame
    13. org.alfresco.repo
      ExceptionTranslatorMethodInterceptor.invoke
      1. org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
      1 frame
    14. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      1 frame
    15. org.alfresco.repo
      AuditMethodInterceptor.invoke
      1. org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:161)
      1 frame
    16. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      1 frame
    17. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      1 frame
    18. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      2 frames
    19. com.sun.proxy
      $Proxy60.startWorkflow
      1. com.sun.proxy.$Proxy60.startWorkflow(Unknown Source)
      1 frame
    20. org.alfresco.repo
      FormServiceImpl.saveForm
      1. org.alfresco.repo.workflow.WorkflowBuilder.build(WorkflowBuilder.java:95)
      2. org.alfresco.repo.forms.processor.workflow.WorkflowFormPersister.persist(WorkflowFormPersister.java:76)
      3. org.alfresco.repo.forms.processor.workflow.WorkflowFormPersister.persist(WorkflowFormPersister.java:44)
      4. org.alfresco.repo.forms.processor.workflow.AbstractWorkflowFormProcessor.internalPersist(AbstractWorkflowFormProcessor.java:80)
      5. org.alfresco.repo.forms.processor.FilteredFormProcessor.persist(FilteredFormProcessor.java:131)
      6. org.alfresco.repo.forms.FormServiceImpl.saveForm(FormServiceImpl.java:138)
      6 frames
    21. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    22. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      3 frames
    23. org.alfresco.repo
      AlwaysProceedMethodInterceptor.invoke
      1. org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)
      1 frame
    24. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      1 frame
    25. org.alfresco.repo
      ExceptionTranslatorMethodInterceptor.invoke
      1. org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
      1 frame
    26. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      1 frame
    27. org.alfresco.repo
      AuditMethodInterceptor.invoke
      1. org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:161)
      1 frame
    28. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      1 frame
    29. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      1 frame
    30. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      2 frames
    31. com.sun.proxy
      $Proxy143.saveForm
      1. com.sun.proxy.$Proxy143.saveForm(Unknown Source)
      1 frame
    32. org.alfresco.repo
      ScriptFormService.saveForm
      1. org.alfresco.repo.forms.script.ScriptFormService.saveForm(ScriptFormService.java:152)
      1 frame
    33. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    34. Rhino
      OptRuntime.callN
      1. org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
      2. org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
      3. org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:86)
      3 frames