Apache Jackrabbit : JackrabbitOnOracle

Created by ASF Infrabot on May 20, 2019

Jackrabbit on Oracle

The following information is available in the respective JavaDoc and other documentation but per Google (and our own experience) it is easily overlooked.

DbFileSystem vs. OracleFileSystem

Use an OracleFileSystem instead of an DbFileSystem when using an Oracle backend. You will get a stack trace looking something like this if it is overlooked:

 Caused by: java.sql.SQLException: ORA-00906: 
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
 at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
 at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)

DbPersistenceManager vs. OraclePersistenceManager or Oracle9PersistenceManager

Use an OraclePersistenceManager or Oracle9PersistenceManager instead of an DbPersistenceManager when using an Oracle backend.