org.springframework.dao.DataAccessResourceFailureException: Could not create Oracle LOB

[Celeste Plaisance]

We're trying to  upgrade to the latest Confluence version, and are getting the following error--

org.springframework.dao.DataAccessResourceFailureException: Could not create Oracle LOB; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: Couldn't initialize OracleLobHandler because Oracle driver classes are not available. Note that OracleLobHandler requires Oracle JDBC driver 9i or higher!; nested exception is java.lang.ClassNotFoundException: oracle.sql.BLOB

[Taha Khanzada]

Hi Celeste,

check Oracle JDBC Driver version you are currently using. Download the latest compatible database driver. Copy the driver JAR file to the <Confluence installation>/confluence/WEB-INF/lib folder in your Confluence installation directory

• For Oracle 11.1, use the 11.1.0.7.0 driver (ojdbc6.jar).
• For Oracle 11.2, use the 11.2.0.4.0 driver (ojdbc6.jar).
• For Oracle 12c use the 12.1.0.1 driver (ojdbc7.jar)

Refer this document for Oracle JDBC Driver info - https://confluence.atlassian.com/doc/database-jdbc-drivers-171742.html

Taha

[chucktalk]

Hi Celeste, 

If you are using a Data Source, you should check 

[CONF-37871|https://jira.atlassian.com/browse/CONF-37871]

as you are likely missing the parameter: {{accessToUnderlyingConnectionAllowed="true"}} within the data source configuration. Adding that should resolve your issue.

Sincerely,

Chuck