java.sql.SQLException: No operations allowed after connection closed)

Oracle Community | 3004 | 1 decade ago
  1. 0

    connection close problem with JBoss + MySQL

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: No operations allowed after connection closed)
  2. 0

    What versions of softs are tested?

    ejbca | 1 decade ago | *anonymous
    org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not map transaction isolation '    l          to a valid JDBC level.); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not map transaction isolation '    l          to a valid JDBC level.)))
  3. 0

    JBoss transaction rollback with jdbc (EJB and other Java EE Technologies forum at JavaRanch)

    coderanch.com | 1 year ago
    org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=serverip/13308, BranchQual=, localId=13308] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.resource.connectionmanager.JBossLocalXAException: could not commit local tx; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: No operations allowed after connection closed.))); - nested throwable: (org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=serverip/13308, BranchQual=, localId=13308] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.resource.connectionmanager.JBossLocalXAException: could not commit local tx; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: No operations allowed after connection closed.))))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [JRA-7972] Workflow migrations hang - Atlassian JIRA

    atlassian.com | 12 months ago
    java.sql.SQLException: No operations allowed after connection closed.

    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. java.sql.SQLException

      No operations allowed after connection closed

      at com.mysql.jdbc.Connection.checkClosed()
    2. MySQL jdbc
      Connection.getTransactionIsolation
      1. com.mysql.jdbc.Connection.checkClosed(Connection.java:2497)
      2. com.mysql.jdbc.Connection.createStatement(Connection.java:1112)
      3. com.mysql.jdbc.Connection.createStatement(Connection.java:1130)
      4. com.mysql.jdbc.Connection.getTransactionIsolation(Connection.java:875)
      4 frames
    3. JBoss Application Server Connector
      WrappedConnection.close
      1. org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cleanup(BaseWrapperManagedConnection.java:187)
      2. org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:222)
      3. org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:389)
      4. org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:265)
      5. org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.returnConnection(JBossManagedConnectionPool.java:648)
      6. org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:452)
      7. org.jboss.resource.connectionmanager.NoTxConnectionManager$NoTxConnectionEventListener.connectionClosed(NoTxConnectionManager.java:111)
      8. org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:280)
      9. org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:127)
      9 frames
    4. com.solarmetric.kodo
      EEPersistenceManager.afterCompletion
      1. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.close(SQLExecutionManagerImpl.java:814)
      2. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.end(JDBCStoreManager..java:232)
      3. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.rollback(JDBCStoreManager.java:213)
      4. com.solarmetric.kodo.runtime.PersistenceManagerImpl.endTransaction(PersistenceManagerImpl.java:827)
      5. com.solarmetric.kodo.ee.EEPersistenceManager.afterCompletion(EEPersistenceManager.java:227)
      5 frames
    5. JBoss Transaction 7.1.0 SPI
      ServerVMClientUserTransaction.commit
      1. org.jboss.tm.TransactionImpl.doAfterCompletion(TransactionImpl.java:1331)
      2. org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:395)
      3. org.jboss.tm.TxManager.commit(TxManager.java:141)
      4. org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:126)
      4 frames
    6. simplexml.ejb
      CheckInEJBBean.startCheckIn
      1. simplexml.ejb.CheckInEJBBean.startCheckIn(CheckInEJBBean.java:81)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl..java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    8. JBoss Application Server Server
      StatelessSessionContainer$ContainerInterceptor.invoke
      1. org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:646)
      1 frame
    9. JBoss Application Server Connector
      CachedConnectionInterceptor.invoke
      1. org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
      1 frame
    10. JBoss Application Server Server
      Container.invoke
      1. org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor..java:84)
      2. org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:144)
      3. org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)
      4. org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
      5. org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
      6. org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      7. org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      8. org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:323)
      9. org.jboss.ejb.Container.invoke(Container.java:673)
      9 frames
    11. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl..java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    12. org.jboss.mx
      ReflectedMBeanDispatcher.invoke
      1. org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      1 frame
    13. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      1 frame
    14. JBoss Application Server Server
      JRMPInvoker.invoke
      1. org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:359)
      1 frame
    15. Java RT
      Thread.run
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl..java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      5. sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
      6. sun.rmi.transport.Transport$1.run(Transport.java:148)
      7. java.security.AccessController.doPrivileged(Native Method)
      8. sun.rmi.transport.Transport.serviceCall(Transport.java:144)
      9. sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
      10. sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
      11. java.lang.Thread.run(Thread.java:534)
      11 frames