2 Replies Latest reply on May 13, 2002 2:22 PM by L.G.

    2.4.5 - Oracle/DB2 "Closed Statement"

    Klaus Thiele Newbie

      Hi,

      i'm just testing 2.4.5 and get following exception on the first call to the database:

      [INFO,Engine] combobox: loading Attribute 'cmb_titel'
      [INFO,XAPoolDataSource] Creating XA Pool
      [ERROR,Engine] combobox: Combobox load exception
      java.sql.SQLException: Geschlossene Anweisung (translated: 'closed statemnent')
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
      at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:4768)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:349)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
      at org.jboss.pool.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:71)
      at com.PIAG.ejb.session.LiteralEJB.getArray(LiteralEJB.java:637)

      source:
      prepStmt = con.prepareStatement(selectStatement);
      prepStmt.setString(1, lit_art);
      ResultSet rs = prepStmt.executeQuery(); <= EXCEPTION

      it works fine with 2.4.4 (and 2.4.5RC3!)

      any hints?
      tia
      klaus

        • 1. Re: 2.4.5 - Oracle/DB2 "Closed Statement"
          Keith Davey Newbie

          I am getting the same error when I run under 2.4.5. Worked fine under 2.4.4.

          [ERROR,MachineBean] TRANSACTION ROLLBACK EXCEPTION:
          javax.transaction.TransactionRolledbackException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement; nested exception is:
          java.rmi.ServerException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement
          java.rmi.ServerException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement
          java.sql.SQLException: Closed Statement
          at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
          at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
          at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
          at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:4768)
          at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:349)
          at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
          at org.jboss.pool.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:71)
          at org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
          at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:156)
          at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:144)
          at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersistenceManager.java:157)
          at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:372)
          at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:287)
          at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:197)
          at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:125)
          at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:138)
          at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:347)
          at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:100)
          at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:127)
          at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:170)
          at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:436)
          at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:506)
          at org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(GenericProxy.java:335)
          at org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.java:133)
          at $Proxy46.getProcessStatus(Unknown Source)
          at twt.genotypingEJB.machine.MachineManagerBean.findAll(MachineManagerBean.java:210)
          at java.lang.reflect.Method.invoke(Native Method)
          at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:542)
          at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:82)
          at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:138)
          at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:347)
          at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:100)
          at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:127)
          at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:170)
          at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:286)
          at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:506)
          at org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(GenericProxy.java:335)
          at org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:123)
          at $Proxy31.findAll(Unknown Source)
          at twt.genotyping.mbean.machine.RefreshMachineProcess.loadMachines(RefreshMachineProcess.java:87)
          at twt.genotyping.mbean.machine.RefreshMachineProcess.run(RefreshMachineProcess.java:44)
          at java.lang.Thread.run(Thread.java:484)
          [ERROR,MachineManagerBean] TRANSACTION ROLLBACK EXCEPTION:
          javax.transaction.TransactionRolledbackException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement; nested exception is:
          java.rmi.ServerException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement; nested exception is:
          javax.transaction.TransactionRolledbackException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement; nested exception is:
          java.rmi.ServerException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement
          javax.transaction.TransactionRolledbackException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement; nested exception is:
          java.rmi.ServerException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement
          java.rmi.ServerException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement
          java.sql.SQLException: Closed Statement
          at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
          at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
          at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
          at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:4768)
          at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:349)
          at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
          at org.jboss.pool.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:71)
          at org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
          at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:156)
          at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:144)
          at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersistenceManager.java:157)
          at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:372)
          at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:287)
          at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:197)
          at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:125)
          at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:138)
          at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:347)
          at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:100)
          at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:127)
          at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:170)
          at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:436)
          at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:506)
          at org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(GenericProxy.java:335)
          at org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.java:133)
          at $Proxy46.getProcessStatus(Unknown Source)
          at twt.genotypingEJB.machine.MachineManagerBean.findAll(MachineManagerBean.java:210)
          at java.lang.reflect.Method.invoke(Native Method)
          at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:542)
          at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:82)
          at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:138)
          at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:347)
          at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:100)
          at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:127)
          at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:170)
          at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:286)
          at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:506)
          at org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(GenericProxy.java:335)
          at org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:123)
          at $Proxy31.findAll(Unknown Source)
          at twt.genotyping.mbean.machine.RefreshMachineProcess.loadMachines(RefreshMachineProcess.java:87)
          at twt.genotyping.mbean.machine.RefreshMachineProcess.run(RefreshMachineProcess.java:44)
          at java.lang.Thread.run(Thread.java:484)
          [FATAL,RefreshMachineProcess] Load failed; nested exception is:
          java.sql.SQLException: Closed Statement; nested exception is:
          java.rmi.ServerException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement; nested exception is:
          javax.transaction.TransactionRolledbackException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement; nested exception is:
          java.rmi.ServerException: Load failed; nested exception is:
          java.sql.SQLException: Closed Statement


          • 2. Re: 2.4.5 - Oracle/DB2 "Closed Statement"
            L.G. Newbie

            <...it works fine with 2.4.4 (and 2.4.5RC3!)>
            I have exactly the same problem.