title: Intermittent SQLException: OALL8 is in an inconsistent state
body: <p>Am getting the below error intermittently. </p>
  
  <pre><code>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
  </code></pre>
  
  <p><strong>Database: Oracle9i</strong></p>
  
  <p><strong>JDBC Driver: 10.2.0.4.0</strong></p>
  
  <p>Developement environment: Mule 3.0, Spring 3.0 and Hibernate 3</p>