com.ibm.websphere.ce.cm.StaleConnectionException: class com.ibm.ejs.cm.proxy.OracleConnectionProxy is closed

Spring JIRA | Victor | 1 decade ago
  1. 0

    I have set up 2 statless session beans - One has a clientPurchase() method demarcated as RequiresNew, the other bean has a serverSidePurchase() method that calls the clientPurchase() within a tx managed by TransactionTemplate. Inside clientPurchase(), a spring managed pojo is called with PROPAGATION_REQUIRED. Attached please find all source codes I'm using. Here is the situation: 1) if I use a ejb client to call clientPurchase() of the 1st bean, everything is fine, db record will be created as expectd. 2) if I use a ejb client to call serverSidePurchase() of the 2nd bean, I'll get the following errors. ====================== [8/30/04 13:40:39:000 EDT] 4dce51da SystemOut U DEBUG [ORB.thread.pool:1] (BatcherImpl.java:196) - about to open: 0 open PreparedStatements, 0 open ResultSets [8/30/04 13:40:39:000 EDT] 4dce51da SystemOut U DEBUG [ORB.thread.pool:1] (BatcherImpl.java:237) - insert into TestProduct (name, price, id) values (?, ?, ?) [8/30/04 13:40:39:000 EDT] 4dce51da SystemOut U DEBUG [ORB.thread.pool:1] (BatcherImpl.java:241) - preparing statement [8/30/04 13:40:39:016 EDT] 4dce51da SystemOut U DEBUG [ORB.thread.pool:1] (JDBCExceptionReporter.java:36) - SQL Exception com.ibm.websphere.ce.cm.StaleConnectionException: class com.ibm.ejs.cm.proxy.OracleConnectionProxy is closed at com.ibm.ejs.cm.proxy.OracleConnectionProxy.prepareStatement(OracleConnectionProxy.java:206) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:249) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56) at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2414) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2367) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236) at org.springframework.orm.hibernate.SessionFactoryUtils$SpringSessionSynchronization.beforeCommit(SessionFactoryUtils.java:633) at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:500) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:364) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:126) at com.cot.esd.Test2SpringSBBean.serverSidePurchase(Test2SpringSBBean.java:37) at com.cot.esd.EJSRemoteStatelessTest2SpringSB_27f3e5e8.serverSidePurchase(EJSRemoteStatelessTest2SpringSB_27f3e5e8.java:22) at com.cot.esd._EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie.serverSidePurchase(_EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie.java:152) at com.cot.esd._EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie._invoke(_EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie.java:96) at com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.java:532) at com.ibm.CORBA.iiop.ORB.process(ORB.java:2450) at com.ibm.CORBA.iiop.OrbWorker.run(OrbWorker.java:186) at com.ibm.ejs.oa.pool.ThreadPool$PooledWorker.run(ThreadPool.java:104) at com.ibm.ws.util.CachedThread.run(ThreadPool.java(Compiled Code))

    Spring JIRA | 1 decade ago | Victor
    com.ibm.websphere.ce.cm.StaleConnectionException: class com.ibm.ejs.cm.proxy.OracleConnectionProxy is closed
  2. 0

    I have set up 2 statless session beans - One has a clientPurchase() method demarcated as RequiresNew, the other bean has a serverSidePurchase() method that calls the clientPurchase() within a tx managed by TransactionTemplate. Inside clientPurchase(), a spring managed pojo is called with PROPAGATION_REQUIRED. Attached please find all source codes I'm using. Here is the situation: 1) if I use a ejb client to call clientPurchase() of the 1st bean, everything is fine, db record will be created as expectd. 2) if I use a ejb client to call serverSidePurchase() of the 2nd bean, I'll get the following errors. ====================== [8/30/04 13:40:39:000 EDT] 4dce51da SystemOut U DEBUG [ORB.thread.pool:1] (BatcherImpl.java:196) - about to open: 0 open PreparedStatements, 0 open ResultSets [8/30/04 13:40:39:000 EDT] 4dce51da SystemOut U DEBUG [ORB.thread.pool:1] (BatcherImpl.java:237) - insert into TestProduct (name, price, id) values (?, ?, ?) [8/30/04 13:40:39:000 EDT] 4dce51da SystemOut U DEBUG [ORB.thread.pool:1] (BatcherImpl.java:241) - preparing statement [8/30/04 13:40:39:016 EDT] 4dce51da SystemOut U DEBUG [ORB.thread.pool:1] (JDBCExceptionReporter.java:36) - SQL Exception com.ibm.websphere.ce.cm.StaleConnectionException: class com.ibm.ejs.cm.proxy.OracleConnectionProxy is closed at com.ibm.ejs.cm.proxy.OracleConnectionProxy.prepareStatement(OracleConnectionProxy.java:206) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:249) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56) at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2414) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2367) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236) at org.springframework.orm.hibernate.SessionFactoryUtils$SpringSessionSynchronization.beforeCommit(SessionFactoryUtils.java:633) at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:500) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:364) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:126) at com.cot.esd.Test2SpringSBBean.serverSidePurchase(Test2SpringSBBean.java:37) at com.cot.esd.EJSRemoteStatelessTest2SpringSB_27f3e5e8.serverSidePurchase(EJSRemoteStatelessTest2SpringSB_27f3e5e8.java:22) at com.cot.esd._EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie.serverSidePurchase(_EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie.java:152) at com.cot.esd._EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie._invoke(_EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie.java:96) at com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.java:532) at com.ibm.CORBA.iiop.ORB.process(ORB.java:2450) at com.ibm.CORBA.iiop.OrbWorker.run(OrbWorker.java:186) at com.ibm.ejs.oa.pool.ThreadPool$PooledWorker.run(ThreadPool.java:104) at com.ibm.ws.util.CachedThread.run(ThreadPool.java(Compiled Code))

    Spring JIRA | 1 decade ago | Victor
    com.ibm.websphere.ce.cm.StaleConnectionException: class com.ibm.ejs.cm.proxy.OracleConnectionProxy is closed
  3. 0

    Exception com .ibm. ejs. cm. proxy. OracleConnectionProxy is closed

    Coderanch | 1 decade ago | Akash Taneja
    com.ibm.websphere.ce.cm.StaleConnectionException: class com.ibm.ejs.cm.proxy.OracleConnectionProxy is closed
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    StaleConnectionException

    Coderanch | 1 decade ago | Carlos Solis
    com.ibm.websphere.ce.cm.StaleConnectionException: class com.ibm.ejs.cm.proxy.CallableStatementProxy is closed
  6. 0

    SQL Server Exception

    Stack Overflow | 1 year ago | MKP
    com.ibm.websphere.ce.cm.StaleConnectionException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: SQL Server did not return a response. The connection has been closed..CWWRA0010E: SQL State = 08S01, Error Code = 0

    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. com.ibm.websphere.ce.cm.StaleConnectionException

      class com.ibm.ejs.cm.proxy.OracleConnectionProxy is closed

      at com.ibm.ejs.cm.proxy.OracleConnectionProxy.prepareStatement()
    2. com.ibm.ejs
      OracleConnectionProxy.prepareStatement
      1. com.ibm.ejs.cm.proxy.OracleConnectionProxy.prepareStatement(OracleConnectionProxy.java:206)
      1 frame
    3. net.sf.hibernate
      SessionImpl.flush
      1. net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:249)
      2. net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
      3. net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
      4. net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
      5. net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
      6. net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
      7. net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
      8. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2414)
      9. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2367)
      10. net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236)
      10 frames
    4. Hibernate
      SessionFactoryUtils$SpringSessionSynchronization.beforeCommit
      1. org.springframework.orm.hibernate.SessionFactoryUtils$SpringSessionSynchronization.beforeCommit(SessionFactoryUtils.java:633)
      1 frame
    5. Spring Tx
      TransactionTemplate.execute
      1. org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:500)
      2. org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:364)
      3. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:126)
      3 frames
    6. com.cot.esd
      _EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie._invoke
      1. com.cot.esd.Test2SpringSBBean.serverSidePurchase(Test2SpringSBBean.java:37)
      2. com.cot.esd.EJSRemoteStatelessTest2SpringSB_27f3e5e8.serverSidePurchase(EJSRemoteStatelessTest2SpringSB_27f3e5e8.java:22)
      3. com.cot.esd._EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie.serverSidePurchase(_EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie.java:152)
      4. com.cot.esd._EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie._invoke(_EJSRemoteStatelessTest2SpringSB_27f3e5e8_Tie.java:96)
      4 frames
    7. com.ibm.CORBA
      OrbWorker.run
      1. com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.java:532)
      2. com.ibm.CORBA.iiop.ORB.process(ORB.java:2450)
      3. com.ibm.CORBA.iiop.OrbWorker.run(OrbWorker.java:186)
      3 frames
    8. com.ibm.ejs
      ThreadPool$PooledWorker.run
      1. com.ibm.ejs.oa.pool.ThreadPool$PooledWorker.run(ThreadPool.java:104)
      1 frame