Hi,

We use oracle (8.1.7) as the session persistence database for our
websphere 3.5.4 application server. After 15 min of running a stress
test, we get the foll. exception. Any idea whats going wrong?

thanks,

Chinmay

java.sql.SQLException: Protocol
violation
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.<init>(Throwable.java:94)
at java.lang.Exception.<init>(Exception.java:42)
at java.sql.SQLException.<init>(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:156)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.j ava:803)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:549)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1311)
at oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Pro tocol.java:661)
at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.java:1320)
at oracle.jdbc.driver.OracleStatement.doExecuteOther( OracleStatement.java:1232)
at oracle.jdbc.driver.OracleStatement.doExecuteWithBa tch(OracleStatement.java:1353)
at oracle.jdbc.driver.OracleStatement.doExecute(Oracl eStatement.java:1760)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1805)
at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:320)
at com.ibm.ejs.cm.cache.CachedStatement.executeUpdate (CachedStatement.java:314)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execut eUpdate(PreparedStatementProxy.java:235)
at com.ibm.servlet.personalization.sessiontracking.Ba ckedHashtable.ejbStore(BackedHashtable.java:2564)
at com.ibm.servlet.personalization.sessiontracking.Ba ckedHashtable.storeSession(BackedHashtable.java:22 72)
at com.ibm.servlet.personalization.sessiontracking.Ba ckedHashtable.put(BackedHashtable.java:2958)
at com.ibm.servlet.personalization.sessiontracking.Da tabaseSessionContext.sync(DatabaseSessionContext.j ava:112)
at com.ibm.servlet.personalization.sessiontracking.Se ssionData.releaseSession(SessionData.java:260)
at com.ibm.servlet.engine.srt.SRTSessionAPISupport.fi nish(SRTSessionAPISupport.java:190)
at com.ibm.servlet.engine.srt.SRTConnectionContext.fi nishConnection(SRTConnectionContext.java:103)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInv ocationHook(WebAppInvoker.java:102)
at com.ibm.servlet.engine.invocation.CachedInvocation .handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocat ionContext.invoke(CacheableInvocationContext.java: 106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor .dispatchByURI(ServletRequestProcessor.java:160)
at com.ibm.servlet.engine.oselistener.OSEListenerDisp atcher.service(OSEListener.java:300)


We also get another exception below the above one in the trace log:

StatementProx E Exception closing statement

com.ibm.ejs.cm.exception.IllegalConnectionUseExcep tion: Error:
Connection is being used in a way that violates the architecture
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.<init>(Throwable.java:94)
at java.lang.Exception.<init>(Exception.java:42)
at java.sql.SQLException.<init>(SQLException.java:82)
at com.ibm.ejs.cm.portability.PortableSQLException.<i nit>(PortableSQLException.java:35)
at com.ibm.ejs.cm.exception.IllegalConnectionUseExcep tion.<init>(IllegalConnectionUseException.java:26)
at com.ibm.ejs.cm.proxy.Proxy.close(Proxy.java:154)
at com.ibm.ejs.cm.proxy.StatementProxy.__close(Statem entProxy.java:61)
at com.ibm.ejs.cm.proxy.StatementProxy.close(Statemen tProxy.java:216)
at com.ibm.ejs.cm.proxy.Proxy.close(Proxy.java:76)
at com.ibm.ejs.cm.proxy.ConnectionProxy.close(Connect ionProxy.java:645)
at com.ibm.ejs.cm.proxy.ConnectionProxy.connectionDes troyed(ConnectionProxy.java:97)
at com.ibm.ejs.cm.pool.ConnectO.fireConnectionDestroy ed(ConnectO.java:1500)
at com.ibm.ejs.cm.pool.ConnectO.destroy(ConnectO.java :741)
at com.ibm.ejs.cm.pool.ConnectO.translateException(Co nnectO.java:1134)
at com.ibm.ejs.cm.proxy.ConnectionProxy.translateExce ption(ConnectionProxy.java:177)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.transl ateException(PreparedStatementProxy.java:484)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execut eUpdate(PreparedStatementProxy.java:238)
at com.ibm.servlet.personalization.sessiontracking.Ba ckedHashtable.ejbStore(BackedHashtable.java:2564)
at com.ibm.servlet.personalization.sessiontracking.Ba ckedHashtable.storeSession(BackedHashtable.java:22 72)
at com.ibm.servlet.personalization.sessiontracking.Ba ckedHashtable.put(BackedHashtable.java:2958)
at com.ibm.servlet.personalization.sessiontracking.Da tabaseSessionContext.sync(DatabaseSessionContext.j ava:112)
at com.ibm.servlet.personalization.sessiontracking.Se ssionData.releaseSession(SessionData.java:260)
at com.ibm.servlet.engine.srt.SRTSessionAPISupport.fi nish(SRTSessionAPISupport.java:190)
at com.ibm.servlet.engine.srt.SRTConnectionContext.fi nishConnection(SRTConnectionContext.java:103)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInv ocationHook(WebAppInvoker.java:102)
at com.ibm.servlet.engine.invocation.CachedInvocation .handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocat ionContext.invoke(CacheableInvocationContext.java: 106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor .dispatchByURI(ServletRequestProcessor.java:160)
at com.ibm.servlet.engine.oselistener.OSEListenerDisp atcher.service(OSEListener.java:300)