javax.ejb.EJBException: org.hibernate.exception.GenericJDBCException: Unable to set JDBC Connection into auto-commit mode in preparation for DDL execution

Hibernate JIRA | Gail Badner | 4 months ago
  1. 0

    HHH-10896 fixed the issue, but then a later commit for the same issue broke it: https://github.com/hibernate/hibernate-orm/commit/076c7ea104f5bcd27a6958dd158a1742cf602cbf javax.ejb.EJBException: org.hibernate.exception.GenericJDBCException: Unable to set JDBC Connection into auto-commit mode in preparation for DDL execution at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1063) at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:834) at org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaImpl.java:51) at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.jdbcStatement(GenerationTargetToDatabase.java:72) at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:48) at org.hibernate.tool.schema.internal.SchemaDropperImpl$DelayedDropActionImpl.perform(SchemaDropperImpl.java:530) at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1074) at org.jboss.as.test.integration.hibernate.SFSBHibernate2LcacheStats.cleanup(SFSBHibernate2LcacheStats.java:73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93) at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.jpa.interceptor.SFSBInvocationInterceptor.processInvocation(SFSBInvocationInterceptor.java:57) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.stateful.StatefulSessionSynchronizationInterceptor.processInvocation(StatefulSessionSynchronizationInterceptor.java:135) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64) at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.stateful.StatefulComponentInstanceInterceptor.processInvocation(StatefulComponentInstanceInterceptor.java:59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:275) at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:327) at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356) at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:636) at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356) at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:198) at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73) at org.jboss.as.test.integration.hibernate.SFSBHibernate2LcacheStats$$$view1.cleanup(Unknown Source) at org.jboss.as.test.integration.hibernate.Hibernate2LCacheStatsTestCase.testHibernateStatistics(Hibernate2LCacheStatsTestCase.java:207)

    Hibernate JIRA | 4 months ago | Gail Badner
    javax.ejb.EJBException: org.hibernate.exception.GenericJDBCException: Unable to set JDBC Connection into auto-commit mode in preparation for DDL execution
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    JON 3.2.0 fails with database transaction or row lock exceptions after bundle deployment is attempted - Red Hat Customer Portal

    redhat.com | 3 months ago
    javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. javax.ejb.EJBException

      org.hibernate.exception.GenericJDBCException: Unable to set JDBC Connection into auto-commit mode in preparation for DDL execution

      at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit()
    2. IronJacamar
      WrappedConnection.commit
      1. org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1063)
      2. org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:834)
      2 frames
    3. org.hibernate.resource
      DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection
      1. org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaImpl.java:51)
      1 frame
    4. org.hibernate.tool
      SchemaDropperImpl$DelayedDropActionImpl.perform
      1. org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.jdbcStatement(GenerationTargetToDatabase.java:72)
      2. org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:48)
      3. org.hibernate.tool.schema.internal.SchemaDropperImpl$DelayedDropActionImpl.perform(SchemaDropperImpl.java:530)
      3 frames
    5. Hibernate
      SessionFactoryImpl.close
      1. org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1074)
      1 frame
    6. org.jboss.as
      SFSBHibernate2LcacheStats.cleanup
      1. org.jboss.as.test.integration.hibernate.SFSBHibernate2LcacheStats.cleanup(SFSBHibernate2LcacheStats.java:73)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:497)
      4 frames
    8. JBoss Application Server: EE
      ManagedReferenceMethodInterceptor.processInvocation
      1. org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
      1 frame
    9. JBoss Application Server Server
      InterceptorContext$Invocation.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      2. org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
      2 frames
    10. Weld
      Jsr299BindingsInterceptor.processInvocation
      1. org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
      2. org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
      2 frames
    11. JBoss Application Server: EE
      UserInterceptorFactory$1.processInvocation
      1. org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
      1 frame
    12. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    13. JBoss Application Server: EJB Subsystem
      ExecutionTimeInterceptor.processInvocation
      1. org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
      1 frame
    14. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    15. JPA
      SBInvocationInterceptor.processInvocation
      1. org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
      1 frame
    16. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    17. JPA
      SFSBInvocationInterceptor.processInvocation
      1. org.jboss.as.jpa.interceptor.SFSBInvocationInterceptor.processInvocation(SFSBInvocationInterceptor.java:57)
      1 frame
    18. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    19. JBoss Application Server: EJB Subsystem
      StatefulSessionSynchronizationInterceptor.processInvocation
      1. org.jboss.as.ejb3.component.stateful.StatefulSessionSynchronizationInterceptor.processInvocation(StatefulSessionSynchronizationInterceptor.java:135)
      1 frame
    20. JBoss Application Server Server
      InterceptorContext$Invocation.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      2. org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
      2 frames
    21. Weld Implementation
      AbstractEJBRequestScopeActivationInterceptor.aroundInvoke
      1. org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
      1 frame
    22. Weld
      EjbRequestScopeActivationInterceptor.processInvocation
      1. org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
      1 frame
    23. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    24. WildFly: EE
      ConcurrentContextInterceptor.processInvocation
      1. org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
      1 frame
    25. JBoss Application Server Server
      ChainedInterceptor.processInvocation
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      2. org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
      3. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      4. org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
      4 frames
    26. JBoss Application Server: EE
      ComponentDispatcherInterceptor.processInvocation
      1. org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
      1 frame
    27. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    28. JBoss Application Server: EJB Subsystem
      StatefulComponentInstanceInterceptor.processInvocation
      1. org.jboss.as.ejb3.component.stateful.StatefulComponentInstanceInterceptor.processInvocation(StatefulComponentInstanceInterceptor.java:59)
      1 frame
    29. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    30. JBoss Application Server: EJB Subsystem
      CMTTxInterceptor.processInvocation
      1. org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:275)
      2. org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:327)
      3. org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239)
      3 frames
    31. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    32. JBoss Application Server: EJB Subsystem
      CurrentInvocationContextInterceptor.processInvocation
      1. org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
      1 frame
    33. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    34. JBoss Application Server: EJB Subsystem
      WaitTimeInterceptor.processInvocation
      1. org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47)
      1 frame
    35. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    36. JBoss Application Server: EJB Subsystem
      SecurityContextInterceptor.processInvocation
      1. org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)
      1 frame
    37. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    38. JBoss Application Server: EJB Subsystem
      StartupAwaitInterceptor.processInvocation
      1. org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22)
      1 frame
    39. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    40. JBoss Application Server: EJB Subsystem
      ShutDownInterceptorFactory$1.processInvocation
      1. org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
      1 frame
    41. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    42. JBoss Application Server: EJB Subsystem
      LoggingInterceptor.processInvocation
      1. org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67)
      1 frame
    43. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    44. JBoss Application Server: EE
      NamespaceContextInterceptor.processInvocation
      1. org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
      1 frame
    45. JBoss Application Server Server
      InterceptorContext.proceed
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      1 frame
    46. JBoss Application Server: EJB Subsystem
      AdditionalSetupInterceptor.processInvocation
      1. org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)
      1 frame
    47. JBoss Application Server Server
      InterceptorContext.run
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      2. org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
      3. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      4. org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
      4 frames
    48. WildFly Security Manager
      WildFlySecurityManager.doChecked
      1. org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:636)
      1 frame
    49. JBoss Application Server Server
      ChainedInterceptor.processInvocation
      1. org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
      2. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      3. org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
      4. org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
      5. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      6. org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
      6 frames
    50. JBoss Application Server: EE
      ViewDescription$1.processInvocation
      1. org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:198)
      2. org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)
      2 frames
    51. JBoss Application Server Server
      ChainedInterceptor.processInvocation
      1. org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
      2. org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
      2 frames
    52. JBoss Application Server: EE
      ProxyInvocationHandler.invoke
      1. org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
      1 frame
    53. org.jboss.as
      Hibernate2LCacheStatsTestCase.testHibernateStatistics
      1. org.jboss.as.test.integration.hibernate.SFSBHibernate2LcacheStats$$$view1.cleanup(Unknown Source)
      2. org.jboss.as.test.integration.hibernate.Hibernate2LCacheStatsTestCase.testHibernateStatistics(Hibernate2LCacheStatsTestCase.java:207)
      2 frames