4 Replies Latest reply: Nov 11, 2010 2:18 PM by 813100 RSS

    Exception: protocol violation/OALL8 is in an inconsistent state/Bigger type

    804902

      Intermitently we get the error below for simble db selects. The query is executed from a simple Spring JDBC call. Because of this error we eventually run out of connections.
      Most of the occurances of this error I have read about corrected it through upgrading the JDBC driver.

      Here are my versions. Is there a known problem with this configuration?

      Database:
      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

      JDBC Driver:
      Implementation-Version: "Oracle JDBC Driver version - 10.1.0.5.0"
      Specification-Title: "Oracle JDBC driver classes for use with JDK1. 4"
      Specification-Version: "Oracle JDBC Driver version - 10.1.0.5.0"

      JDK:
      java version "1.5.0_20"
      Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_20-b02)
      Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_20-b02, mixed mode)



      ERROR ody.comp.dao.JDBCTemplateHandler - PreparedStatementCallback; uncategorized SQLException for SQL [ SELECT FLG1, FLG2 FROM db1.STNS WHERE ID1 = ? ]; SQL state [null]; error code [17412]; Bigger type length than Maximum; nested exception is java.sql.SQLException: Bigger type length than Maximum
      ERROR org.springframework.transaction.interceptor.TransactionInterceptor - Application exception overridden by rollback exception
      ody.comp.exception.ApplicationException: Unknown DB Error. Underlying message is:Bigger type length than Maximum
      ...


      ERROR ody.comp.dao.JDBCTemplateHandler - PreparedStatementCallback; uncategorized SQLException for SQL [ SELECT 'Y' FROM db1.STNS WHERE ID1 = 'ET' AND ID2 = ? ]; SQL state []; error code [0]; OALL8 is in an inconsistent state.; nested exception is java.sql.SQLException: OALL8 is in an inconsistent state.
      2010