1. Is the application doing connecton cleanup itself or is it letting websphere do the same for it? If it is not, have you checked set auto connection cleanup to true?
2. What's the orphan timeout setting in your case? Websphere default is half an hour. If there is no activity for half an hour , websphere marks this for orphaning...then waits and checks for another half an hour...if it still doesnt see any activity , then it returns the connection to the pool. Try setting this value to 0 if it isnt already. 3. Where are you obtaining the connection? Is it a servlet or some data access object? If it is a servlet , have you declared the Connection object as an instance variable? - Rahul -----Original Message----- From: Ramesh Kesavanarayanan [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 5:37 PM To: [EMAIL PROTECTED] Subject: Non-application exception occured while processing method findByPrimaryKey Hi all, I have installed WSAS4.0.3 with oracle as my DB during the installation. I ran my application once or twice and then i went to DB table v$session and killed the sessions. When I re-start my application, i am getting the following error. Also i am getting min of 5 connection objects in the V$Session table. I have removed the sample app and sample dbprovider from WSAS. my question is that why WSAS should create so many connections in the DB by default. FYI, i have set the min and max in my DataSource as 1 and 5 only. would appreciate your interest in solving this.. Here is the error message i am getting -------------------------------------- CNTR0019E: Non-application exception occurred while processing method findByPrimaryKey: java.rmi.RemoteException: ; nested exception is: com.ibm.websphere.ce.cm.StaleConnectionException: ORA-00028: your session has been killed com.ibm.websphere.ce.cm.StaleConnectionException: ORA-00028: your session has been killed at java.lang.reflect.Constructor.newInstance(Native Method) at com.ibm.ejs.cm.portability.PortabilityLayerImpl.translateException(Portabili tyLayerImpl.java:249) at com.ibm.ejs.cm.portability.ErrorMap.translateException(ErrorMap.java:182) at com.ibm.ejs.cm.pool.ConnectO.translateException(ConnectO.java:1901) at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(C ompiled Code)) at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(C ompiled Code)) at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementPr oxy.java(Compiled Code)) at com.ibm.ejs.ns.CosNaming.BindingBean.ejbFindByPrimaryKey(BindingBean.java:34 9) at com.ibm.ejs.ns.CosNaming.EJSBMPBindingHomeBean.findByPrimaryKey(EJSBMPBindin gHomeBean.java:28) at com.ibm.ejs.ns.CosNaming.EJSRemoteBMPBindingHome.findByPrimaryKey(EJSRemoteB MPBindingHome.java:81) at com.ibm.ejs.ns.CosNaming._BindingHome_Stub.findByPrimaryKey(_BindingHome_Stu b.java:333) at com.ibm.ejs.ns.CosNaming.EJBDataStore.resolve(EJBDataStore.java:338) at com.ibm.ejs.ns.CosNaming.NsSessionBean.getBindingBean(NsSessionBean.java:101 ) at com.ibm.ejs.ns.CosNaming.EJSRemoteStatelessNsSession.getBindingBean(EJSRemot eStatelessNsSession.java:53) at com.ibm.ejs.ns.CosNaming._NsSession_Stub.getBindingBean(_NsSession_Stub.java :500) at com.ibm.ejs.ns.CosNaming.NsSessionDataStore.resolve(NsSessionDataStore.java: 137) at com.ibm.ws.naming.rdbcos.WsnOptimizedNamingImpl.getNextWsnOptimizedNamingCon text(WsnOptimizedNamingImpl.java:1240) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.getTargetContext(WsnOpt imizedNamingImplBase.java:1345) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase$LeafOperationData.<init >(WsnOptimizedNamingImplBase.java:1657) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.resolve_complete_info(W snOptimizedNamingImplBase.java:796) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.executeBatchedOperation s(WsnOptimizedNamingImplBase.java:1185) at com.ibm.WsnOptimizedNaming._NamingContextImplBase._invoke(_NamingContextImpl Base.java:63) at com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.ja va(Compiled Code)) at com.ibm.CORBA.iiop.ORB.process(ORB.java(Compiled Code)) at com.ibm.CORBA.iiop.OrbWorker.run(OrbWorker.java(Compiled Code)) at com.ibm.ejs.oa.pool.ThreadPool$PooledWorker.run(ThreadPool.java(Compiled Code)) at com.ibm.ws.util.CachedThread.run(ThreadPool.java(Compiled Code)) ---- Begin backtrace for detail com.ibm.websphere.ce.cm.StaleConnectionException: ORA-00028: your session has been killed at java.lang.reflect.Constructor.newInstance(Native Method) at com.ibm.ejs.cm.portability.PortabilityLayerImpl.translateException(Portabili tyLayerImpl.java:249) at com.ibm.ejs.cm.portability.ErrorMap.translateException(ErrorMap.java:182) at com.ibm.ejs.cm.pool.ConnectO.translateException(ConnectO.java:1901) at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(C ompiled Code)) at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(C ompiled Code)) at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementPr oxy.java(Compiled Code)) at com.ibm.ejs.ns.CosNaming.BindingBean.ejbFindByPrimaryKey(BindingBean.java:34 9) at com.ibm.ejs.ns.CosNaming.EJSBMPBindingHomeBean.findByPrimaryKey(EJSBMPBindin gHomeBean.java:28) at com.ibm.ejs.ns.CosNaming.EJSRemoteBMPBindingHome.findByPrimaryKey(EJSRemoteB MPBindingHome.java:81) at com.ibm.ejs.ns.CosNaming._BindingHome_Stub.findByPrimaryKey(_BindingHome_Stu b.java:333) at com.ibm.ejs.ns.CosNaming.EJBDataStore.resolve(EJBDataStore.java:338) at com.ibm.ejs.ns.CosNaming.NsSessionBean.getBindingBean(NsSessionBean.java:101 ) at com.ibm.ejs.ns.CosNaming.EJSRemoteStatelessNsSession.getBindingBean(EJSRemot eStatelessNsSession.java:53) at com.ibm.ejs.ns.CosNaming._NsSession_Stub.getBindingBean(_NsSession_Stub.java :500) at com.ibm.ejs.ns.CosNaming.NsSessionDataStore.resolve(NsSessionDataStore.java: 137) at com.ibm.ws.naming.rdbcos.WsnOptimizedNamingImpl.getNextWsnOptimizedNamingCon text(WsnOptimizedNamingImpl.java:1240) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.getTargetContext(WsnOpt imizedNamingImplBase.java:1345) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase$LeafOperationData.<init >(WsnOptimizedNamingImplBase.java:1657) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.resolve_complete_info(W snOptimizedNamingImplBase.java:796) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.executeBatchedOperation s(WsnOptimizedNamingImplBase.java:1185) at com.ibm.WsnOptimizedNaming._NamingContextImplBase._invoke(_NamingContextImpl Base.java:63) at com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.ja va(Compiled Code)) at com.ibm.CORBA.iiop.ORB.process(ORB.java(Compiled Code)) at com.ibm.CORBA.iiop.OrbWorker.run(OrbWorker.java(Compiled Code)) at com.ibm.ejs.oa.pool.ThreadPool$PooledWorker.run(ThreadPool.java(Compiled Code)) at com.ibm.ws.util.CachedThread.run(ThreadPool.java(Compiled Code)) ---- Begin backtrace for next java.sql.SQLException: ORA-00028: your session has been killed at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code)) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java(Compi led Code)) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java (Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState ment.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem ent.java(Compiled Code)) at com.ibm.ejs.cm.cache.CachedStatement.executeQuery(CachedStatement.java(Compi led Code)) at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(C ompiled Code)) at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementPr oxy.java(Compiled Code)) at com.ibm.ejs.ns.CosNaming.BindingBean.ejbFindByPrimaryKey(BindingBean.java:34 9) at com.ibm.ejs.ns.CosNaming.EJSBMPBindingHomeBean.findByPrimaryKey(EJSBMPBindin gHomeBean.java:28) at com.ibm.ejs.ns.CosNaming.EJSRemoteBMPBindingHome.findByPrimaryKey(EJSRemoteB MPBindingHome.java:81) at com.ibm.ejs.ns.CosNaming._BindingHome_Stub.findByPrimaryKey(_BindingHome_Stu b.java:333) at com.ibm.ejs.ns.CosNaming.EJBDataStore.resolve(EJBDataStore.java:338) at com.ibm.ejs.ns.CosNaming.NsSessionBean.getBindingBean(NsSessionBean.java:101 ) at com.ibm.ejs.ns.CosNaming.EJSRemoteStatelessNsSession.getBindingBean(EJSRemot eStatelessNsSession.java:53) at com.ibm.ejs.ns.CosNaming._NsSession_Stub.getBindingBean(_NsSession_Stub.java :500) at com.ibm.ejs.ns.CosNaming.NsSessionDataStore.resolve(NsSessionDataStore.java: 137) at com.ibm.ws.naming.rdbcos.WsnOptimizedNamingImpl.getNextWsnOptimizedNamingCon text(WsnOptimizedNamingImpl.java:1240) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.getTargetContext(WsnOpt imizedNamingImplBase.java:1345) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase$LeafOperationData.<init >(WsnOptimizedNamingImplBase.java:1657) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.resolve_complete_info(W snOptimizedNamingImplBase.java:796) at com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.executeBatchedOperation s(WsnOptimizedNamingImplBase.java:1185) at com.ibm.WsnOptimizedNaming._NamingContextImplBase._invoke(_NamingContextImpl Base.java:63) at com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.ja va(Compiled Code)) at com.ibm.CORBA.iiop.ORB.process(ORB.java(Compiled Code)) at com.ibm.CORBA.iiop.OrbWorker.run(OrbWorker.java(Compiled Code)) at com.ibm.ejs.oa.pool.ThreadPool$PooledWorker.run(ThreadPool.java(Compiled Code)) at com.ibm.ws.util.CachedThread.run(ThreadPool.java(Compiled Code)) ________________________________________________________________________ Missed your favourite TV serial last night? Try the new, Yahoo! TV. visit http://in.tv.yahoo.com =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help". =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
