Uploaded image for project: 'Confluence Server'
  1. Confluence Server
  2. CONFSERVER-44226

Oracle Security Patched DB Driver Not Working

    Details

    • Symptom Severity:
      Major
    • Support reference count:
      1
    • Testing Notes:
      Hide

      First follow the description to reproduce the issue within an instance running with Oracle and the JDBC driver having the patch, then re-launch confluence from the fix branch, and confirm the issue is resolved at the branch.

      Show
      First follow the description to reproduce the issue within an instance running with Oracle and the JDBC driver having the patch, then re-launch confluence from the fix branch, and confirm the issue is resolved at the branch.

      Description

      Issue Summary

      Following a recent security patch by Oracle for the ojdbc6.jar driver as fix for CVE-2016-3506. (p23727132_112040_Generic.zip, available in Oracle Support download area), applying the patch to Confluence breaks Confluence with Confluence throwing:

      Caused by: java.sql.SQLException: Invalid argument(s) in call
          at oracle.jdbc.OracleDatabaseMetaData.getTables(OracleDatabaseMetaData.java:2991)
          at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
          at net.java.ao.db.OracleDatabaseProvider.getSequences(OracleDatabaseProvider.java:93)
          at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getSequenceNames(DatabaseMetaDataReaderImpl.java:222)
          ... 60 more
      

      Step to Reproduce

      1. Install the new driver by replacing the bundled driver which is located in: Confluence installation/lib folder.
      2. Restart Confluence.
      3. Attempt to login into Confluence once it is up and running.

      Expected Behavior

      The user would be able to login with no problems.

      Actual Behavior

      The user gets a 500 page error with the logs mentioned above.

      Note

      When user reverts back to using the bundled driver, things work fine again.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:
                  Last commented:
                  21 weeks, 2 days ago