ORA-01555 / ORA-22924 "snapshot too old" error in JBoss EAP
Issue
... java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.BlobAccessor.getBytes(BlobAccessor.java:256)
at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:708)
at oracle.jdbc.driver.OracleResultSet.getBytes(OracleResultSet.java:1625)
at org.jboss.jca.adapters.jdbc.WrappedResultSet.getBytes(WrappedResultSet.java:699)
...
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- Oracle
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.