Intermittent SQLException: OALL8 is in an inconsistent state

Question

I get the following error with an error.

ERROR Exception occured while fetching the available subscriptions from the database - Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed Caused by: org.hibernate.TransactionException: JDBC rollback failed at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:204) at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676) ... 80 more Caused by: java.sql.SQLException: No more data to read from socket java.sql.SQLException: Closed Connection ERROR org.hibernate.transaction.JDBCTransaction 17/11/2010 20:49:41 - JDBC rollback failed java.sql.SQLException: Io exception: Broken pipe ERROR org.springframework.transaction.interceptor.TransactionInterceptor 17/11/2010 20:49:41 - Application exception overridden by rollback exception org.hibernate.exception.GenericJDBCException: could not execute query java.sql.SQLException: OALL8 is in an inconsistent state 

Database: Oracle9i

JDBC Driver: 10.2.0.4.0

Development Environment: Mule 3.0, Spring 3.0, and Hibernate 3

Answer 1

“OALL8 is in an inconsistent state” is a common exception that occurs in JDBC 10.1, 10.2, and 11.1. This indicates that internal inconsistency was detected in the JDBC connection, but it does not provide information about what caused the inconsistency. An exception no longer occurs in JDBC 11.2. The error is usually caused by an error in the JDBC code. They are very difficult to analyze. The easiest solution is to update the JDBC driver.