"Protocol Violation & OALL8 is in inconsistent state" org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17401]

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    "Protocol Violation & OALL8 is in inconsistent state"

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17401]

Symptoms:

You are using desupported version Oracle application server 10.1.3.0.0 and customer is getting 'PROTOCOL EXCEPTION' FOLLOWED BY 'OALL8 IS IN AN INCONSISTENT STATE' . This can be occurred when JDBC 10.1.0.3/10.1.0.4 versioin.

Log files:

RROR com.pcfc.ports.common.util.CustomExceptionHandler 2009-07-26 10:23:03,366 PORTS SYSTEM EXCEPTION 
com.pcfc.services.exception.SystemException: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17401]; 
--- The error occurred in invoice.xml. 
--- The error occurred while applying a parameter map. 
--- Check the getisdownloaded-InlineParameterMap. 
--- Check the statement (query failed). 
--- Cause: java.sql.SQLException: Protocol violation; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: 
--- The error occurred in invoice.xml. 
--- The error occurred while applying a parameter map. 
--- Check the getisdownloaded-InlineParameterMap. 
--- Check the statement (query failed). 
--- Cause: java.sql.SQLException: Protocol violation
Caused by: java.sql.SQLException: Protocol violation
at com.pcfc.ports.invoice.dao.InvoiceDownloadDAOImpl.getInvoiceDownloadInfo(InvoiceDownloadDAOImpl.java:63)
at com.pcfc.ports.invoice.service.InvoiceDownloadServiceImpl.getInvoiceDownloadInfo(InvoiceDownloadServiceImpl.java:44)
at sun.reflect.GeneratedMethodAccessor4647.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)

Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17401]; 
--- The error occurred in invoice.xml. 
--- The error occurred while applying a parameter map. 
--- Check the getisdownloaded-InlineParameterMap. 
--- Check the statement (query failed). 
--- Cause: java.sql.SQLException: Protocol violation; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: 
--- The error occurred in invoice.xml. 
--- The error occurred while applying a parameter map. 
--- Check the getisdownloaded-InlineParameterMap. 
--- Check the statement (query failed). 
--- Cause: java.sql.SQLException: Protocol violation
Caused by: java.sql.SQLException: Protocol violation
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:196)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:241)
at com.pcfc.ports.invoice.dao.InvoiceDownloadDAOImpl.getInvoiceDownloadInfo(InvoiceDownloadDAOImpl.java:56)
... 60 more
.....................................

com.pcfc.services.exception.SystemException: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state []; error code [0]; 
--- The error occurred in invoice.xml. 
--- The error occurred while applying a parameter map. 
--- Check the getisdownloaded-InlineParameterMap. 
--- Check the statement (query failed). 
--- Cause: java.sql.SQLException: OALL8 is in an inconsistent state.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: 
--- The error occurred in invoice.xml. 
--- The error occurred while applying a parameter map. 
--- Check the getisdownloaded-InlineParameterMap. 
--- Check the statement (query failed). 
--- Cause: java.sql.SQLException: OALL8 is in an inconsistent state.
Caused by: java.sql.SQLException: OALL8 is in an inconsistent state.
at com.pcfc.ports.invoice.dao.InvoiceDownloadDAOImpl.getInvoiceDownloadInfo(InvoiceDownloadDAOImpl.java:63)
at com.pcfc.ports.invoice.service.InvoiceDownloadServiceImpl.getInvoiceDownloadInfo(InvoiceDownloadServiceImpl.java:44)
at sun.reflect.GeneratedMethodAccessor4647.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
at $Proxy10.getInvoiceDownloadInfo(Unknown Source)
at com.pcfc.ports.invoice.web.action.InvoiceAction.getInvoiceDownloadDetails(InvoiceAction.java:65)
at sun.reflect.GeneratedMethodAccessor4646.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at com.pcfc.services.web.BaseRequestProcessor.processActionPerform(BaseRequestProcessor.java:109)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062)
at org.apache.struts.action.RequestProcessor.internalModuleRelativeForward(RequestProcessor.java:1000)
at org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:560)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:209)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at com.pcfc.ports.common.util.PortsFilter.doFilter(PortsFilter.java:124)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:629)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)

Solution: OALL8 inconsistent issues comes because of compatability issues and Protocol Exception comes when there is a firewall between client and database.

As for Application Server 10.1.3.0.0 which was desupported as per the Note 397022.1. You need to install Oracle application server 10.1.3.1.0 and then Patchset 10.1.3.3.0. When you have Oracle Application Server 10.1.3.3.0 then it will use the JDBC 10.1.0.5.0 version. It will resolve your issue. That is the solution for this issue as per the Note 371815.1. 

References:

Article-ID: Note 467808.1
Title: How To Determine The Exact JDBC Driver Version (9.x - 11.x) For J2EE Programs

Note 371815.1
Title: 'PROTOCOL EXCEPTION' FOLLOWED BY 'OALL8 IS IN AN INCONSISTENT STATE' WHEN USING JDBC 10.1.0.3/10.1.0.4

Get Oracle Certifications for all Exams
Free Online Exams.com