Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Websphere session persistence gets "protocol violation" using oracle jdbc driver
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(DBError.java:114) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java: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(TTC7Protocol.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.doExecuteWithBatch(OracleStatement.java:1353) at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:320) at com.ibm.ejs.cm.cache.CachedStatement.executeUpdate(CachedStatement.java:314) at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:235) at com.ibm.servlet.personalization.sessiontracking.BackedHashtable.ejbStore(BackedHashtable.java:2564) at com.ibm.servlet.personalization.sessiontracking.BackedHashtable.storeSession(BackedHashtable.java:2272) at com.ibm.servlet.personalization.sessiontracking.BackedHashtable.put(BackedHashtable.java:2958) at com.ibm.servlet.personalization.sessiontracking.DatabaseSessionContext.sync(DatabaseSessionContext.java:112) at com.ibm.servlet.personalization.sessiontracking.SessionData.releaseSession(SessionData.java:260) at com.ibm.servlet.engine.srt.SRTSessionAPISupport.finish(SRTSessionAPISupport.java:190) at com.ibm.servlet.engine.srt.SRTConnectionContext.finishConnection(SRTConnectionContext.java:103) at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:102) at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67) at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106) at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:160) at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.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.IllegalConnectionUseException: 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.<init>(PortableSQLException.java:35) at com.ibm.ejs.cm.exception.IllegalConnectionUseException.<init>(IllegalConnectionUseException.java:26) at com.ibm.ejs.cm.proxy.Proxy.close(Proxy.java:154) at com.ibm.ejs.cm.proxy.StatementProxy.__close(StatementProxy.java:61) at com.ibm.ejs.cm.proxy.StatementProxy.close(StatementProxy.java:216) at com.ibm.ejs.cm.proxy.Proxy.close(Proxy.java:76) at com.ibm.ejs.cm.proxy.ConnectionProxy.close(ConnectionProxy.java:645) at com.ibm.ejs.cm.proxy.ConnectionProxy.connectionDestroyed(ConnectionProxy.java:97) at com.ibm.ejs.cm.pool.ConnectO.fireConnectionDestroyed(ConnectO.java:1500) at com.ibm.ejs.cm.pool.ConnectO.destroy(ConnectO.java:741) at com.ibm.ejs.cm.pool.ConnectO.translateException(ConnectO.java:1134) at com.ibm.ejs.cm.proxy.ConnectionProxy.translateException(ConnectionProxy.java:177) at com.ibm.ejs.cm.proxy.PreparedStatementProxy.translateException(PreparedStatementProxy.java:484) at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:238) at com.ibm.servlet.personalization.sessiontracking.BackedHashtable.ejbStore(BackedHashtable.java:2564) at com.ibm.servlet.personalization.sessiontracking.BackedHashtable.storeSession(BackedHashtable.java:2272) at com.ibm.servlet.personalization.sessiontracking.BackedHashtable.put(BackedHashtable.java:2958) at com.ibm.servlet.personalization.sessiontracking.DatabaseSessionContext.sync(DatabaseSessionContext.java:112) at com.ibm.servlet.personalization.sessiontracking.SessionData.releaseSession(SessionData.java:260) at com.ibm.servlet.engine.srt.SRTSessionAPISupport.finish(SRTSessionAPISupport.java:190) at com.ibm.servlet.engine.srt.SRTConnectionContext.finishConnection(SRTConnectionContext.java:103) at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:102) at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67) at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106) at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:160) at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:300)Received on Wed May 28 2003 - 12:25:30 CDT