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(PortabilityLayerImpl.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(Compiled
Code))
at
com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(Compiled
Code))
at
com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java(Compiled
Code))
at
com.ibm.ejs.ns.CosNaming.BindingBean.ejbFindByPrimaryKey(BindingBean.java:349)
at
com.ibm.ejs.ns.CosNaming.EJSBMPBindingHomeBean.findByPrimaryKey(EJSBMPBindingHomeBean.java:28)
at
com.ibm.ejs.ns.CosNaming.EJSRemoteBMPBindingHome.findByPrimaryKey(EJSRemoteBMPBindingHome.java:81)
at
com.ibm.ejs.ns.CosNaming._BindingHome_Stub.findByPrimaryKey(_BindingHome_Stub.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(EJSRemoteStatelessNsSession.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.getNextWsnOptimizedNamingContext(WsnOptimizedNamingImpl.java:1240)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.getTargetContext(WsnOptimizedNamingImplBase.java:1345)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase$LeafOperationData.<init>(WsnOptimizedNamingImplBase.java:1657)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.resolve_complete_info(WsnOptimizedNamingImplBase.java:796)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.executeBatchedOperations(WsnOptimizedNamingImplBase.java:1185)
at
com.ibm.WsnOptimizedNaming._NamingContextImplBase._invoke(_NamingContextImplBase.java:63)
at
com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.java(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(PortabilityLayerImpl.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(Compiled
Code))
at
com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(Compiled
Code))
at
com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java(Compiled
Code))
at
com.ibm.ejs.ns.CosNaming.BindingBean.ejbFindByPrimaryKey(BindingBean.java:349)
at
com.ibm.ejs.ns.CosNaming.EJSBMPBindingHomeBean.findByPrimaryKey(EJSBMPBindingHomeBean.java:28)
at
com.ibm.ejs.ns.CosNaming.EJSRemoteBMPBindingHome.findByPrimaryKey(EJSRemoteBMPBindingHome.java:81)
at
com.ibm.ejs.ns.CosNaming._BindingHome_Stub.findByPrimaryKey(_BindingHome_Stub.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(EJSRemoteStatelessNsSession.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.getNextWsnOptimizedNamingContext(WsnOptimizedNamingImpl.java:1240)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.getTargetContext(WsnOptimizedNamingImplBase.java:1345)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase$LeafOperationData.<init>(WsnOptimizedNamingImplBase.java:1657)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.resolve_complete_info(WsnOptimizedNamingImplBase.java:796)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.executeBatchedOperations(WsnOptimizedNamingImplBase.java:1185)
at
com.ibm.WsnOptimizedNaming._NamingContextImplBase._invoke(_NamingContextImplBase.java:63)
at
com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.java(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(Compiled
Code))
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled
Code))
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java(Compiled
Code))
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java(Compiled
Code))
at
com.ibm.ejs.cm.cache.CachedStatement.executeQuery(CachedStatement.java(Compiled
Code))
at
com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(Compiled
Code))
at
com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java(Compiled
Code))
at
com.ibm.ejs.ns.CosNaming.BindingBean.ejbFindByPrimaryKey(BindingBean.java:349)
at
com.ibm.ejs.ns.CosNaming.EJSBMPBindingHomeBean.findByPrimaryKey(EJSBMPBindingHomeBean.java:28)
at
com.ibm.ejs.ns.CosNaming.EJSRemoteBMPBindingHome.findByPrimaryKey(EJSRemoteBMPBindingHome.java:81)
at
com.ibm.ejs.ns.CosNaming._BindingHome_Stub.findByPrimaryKey(_BindingHome_Stub.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(EJSRemoteStatelessNsSession.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.getNextWsnOptimizedNamingContext(WsnOptimizedNamingImpl.java:1240)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.getTargetContext(WsnOptimizedNamingImplBase.java:1345)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase$LeafOperationData.<init>(WsnOptimizedNamingImplBase.java:1657)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.resolve_complete_info(WsnOptimizedNamingImplBase.java:796)
at
com.ibm.ws.naming.cosbase.WsnOptimizedNamingImplBase.executeBatchedOperations(WsnOptimizedNamingImplBase.java:1185)
at
com.ibm.WsnOptimizedNaming._NamingContextImplBase._invoke(_NamingContextImplBase.java:63)
at
com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.java(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".
