StaleConnectionException occurs when persistence is enabled for SessionManager
 Technote (troubleshooting)
 
Problem(Abstract)
StaleConnectionException occurs during invalidation when database persistence is enabled for SessionManager.
 
Cause
The below exception could occur during invalidation, because session manager will try to reuse a connection that was already closed:
Exception is: com.ibm.websphere.ce.cm.StaleConnectionException: class com.ibm.ejs.cm.proxy.OracleConnectionProxy is closed
at com.ibm.ejs.cm.proxy.OracleConnectionProxy.prepareStatement(OracleConnectionProxy
at com.ibm.ws.webcontainer.httpsession.BackedHashtable.processInvalidList(BackedHasht
at com.ibm.ws.webcontainer.httpsession.BackedHashtable.performInvalidation(BackedHasht
at com.ibm.ws.webcontainer.httpsession.DatabaseSessionContext.performInvalidation(Datab
at com.ibm.ws.webcontainer.httpsession.SessionContext.pollInvalidations(SessionContext.j
at com.ibm.ws.webcontainer.httpsession.SessionAlarmListener.alarm(SessionAlarmListener
at com.ibm.ejs.util.am._Alarm.run(_Alarm.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
 
Resolving the problem
The above problem should be solved, by disabling the automatic connection cleanup for the datasource.


To disable this from administrative console:

1. Open Administrative console.

2. Go to Resources > JDBC Providers > Oracle JDBC Driver (XA) > Data Sources

3. Select Session data Source.

4. Enable "Disable auto connection cleanup".

5. Save all changes and restart the application server.

 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Sessions and Session Management
Operating system(s): AIX
Software version: 5.1
Software edition:
Reference #: 1210873
IBM Group: Software Group
Modified date: Jun 30, 2005