Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Add non-standard JDBC workarounds

...

  1. Double check all the configuration values and that JDBC driver is installed - use the information above
  2. Make sure you restarted Confluence after making configuration changes
  3. Make sure your database is configurated configured from remote access from the Confluence server with the user and password provided. If you have problems, connect using an independent SQL client from the server to verify access. Consult your database documentation for how to configure remote access and database permissions

...

  • After upgrading Confluence or your application server, this error can occur if your datasource configuration is out of date. Look for something like factory="org.apache.commons.dbcp.BasicDataSourceFactory" in your server.xml. Either remove it or rename it to factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory". Reference is SQL-68.
    No Format
    java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSourceFactory
    

Non-standard JDBC drivers

If you are using a non-standard JDBC driver for accessing less common databases, there are potential problems with unsupported or non-standard behavior. Experiment on a test instance to ensure it works as expected. Here are some workarounds for problems you might encounter. If you continue to have problems, you will need to debug the code on your installation.

  1. Hangs - SQL-86 is an example. Use multipleResults=false to disable multiple results sets.
  2. Avoid using horizontal rowOrientation

Other errors

For other errors replated to connectivity, google your symptoms and application server combination

...