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

Oracle Community | 3004 | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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.)))

    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