Stale Connection issue with WAS 4.0.2

[Praneeta Rao]

I get the following exception with WebSphere 4.0.2 running on AIX,
and Oracle 8.1.7 running on OS/390:
( This exception is raised by the Session Manager while using multi row
session persistence. However, if I use single row sessions, this problem
does
not occur)

Any suggestions?

[16/09/02 17:37:02:870 BST] 45744316 StaleConnecti A CONM7007I: Mapping the
following SQLException, with ErrorCode 17,002 and SQLState <null>, to a
StaleConnectionException: java.sql.SQLException: Io exception: A connection
with a remote socket was reset by that socket.: A connection with a remote
socket was reset by that socket.
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled
Code))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1624
)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1535)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2053)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:398)
at
com.ibm.ejs.cm.cache.CachedStatement.executeUpdate(CachedStatement.java:297)
at
com.ibm.ejs.cm.proxy.StatementProxy.executeUpdateCommon(StatementProxy.java:
294)
at
com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementP
roxy.java:49)
at
com.ibm.servlet.personalization.sessiontracking.BackedHashtableMR.handleProp
ertyHits(BackedHashtableMR.java(Compiled Code))
at
com.ibm.servlet.personalization.sessiontracking.BackedHashtable.ejbStore(Bac
kedHashtable.java:2883)
at
com.ibm.servlet.personalization.sessiontracking.BackedHashtable.storeSession
(BackedHashtable.java:2659)
at
com.ibm.servlet.personalization.sessiontracking.BackedHashtable.put(BackedHa
shtable.java:3434)
at
com.ibm.servlet.personalization.sessiontracking.DatabaseSessionContext.sync(
DatabaseSessionContext.java:162)
at
com.ibm.servlet.personalization.sessiontracking.SessionData.releaseSession(S
essionData.java:328)
at
com.ibm.servlet.engine.srt.SRTSessionAPISupport.finish(SRTSessionAPISupport.
java:246)
at
com.ibm.servlet.engine.srt.SRTConnectionContext.finishConnection(SRTConnecti
onContext.java:91)
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:151)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java:184)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java:67)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java:122)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
.java:315)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.ja
va:60)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Comp
iled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)

[16/09/02 17:37:03:155 BST] 45744316 SessionContex X SESN0057E:
BackedHashtableMR: a problem storing application data changes to the
database. If a SQLException has occurred then refer to the appropriate
database documentation for your environment. Also, assure that you have
properly configured a datasource for Session Manager.

Regards,
Praneeta

[Cameron Purdy]

> I get the following exception with WebSphere 4.0.2 running on AIX,
> and Oracle 8.1.7 running on OS/390:
> ( This exception is raised by the Session Manager while using multi row
> session persistence. However, if I use single row sessions, this problem
> does not occur)
> Any suggestions?

Use in-memory HTTP session replication?

http://www.tangosol.com/coherence.jsp
(Coherence is the only product for clustering WebSphere 4, and it supports
clustered replication of WebSphere HTTP sessions "out of the box". Now
better than ever with a new "Powered by WebSphere" logo!)

Peace,

Cameron Purdy
Tangosol, Inc.
http://www.tangosol.com/coherence.jsp
Coherence: Now supports WebSphere HTTP Session clustering

"Praneeta Rao" <pranee...@thbs.com> wrote in message
news:am9u1n$lb8$1...@dns1.blr.thbs.com...
>