Confluence Docs 3.3 : Known Issues for PostgreSQL
This page last changed on Apr 10, 2008 by ktran.
Database Performance Issue on PostgreSQL 7There is an issue in versions of PostgreSQL prior to 8.0 that causes the database to do a full table scan rather than an index lookup for many of the database queries performed by Confluence. This will cause Confluence to slow significantly the more data it has stored. While we fully support Confluence on PostgreSQL 7, we highly recommend upgrading to version 8.0 or higher for this reason. Configuring Database Character EncodingRefer to Configuring Database Character Encoding. Incorrect JDBC Driver UsedIf you have downloaded and used an incorrect JDBC Driver version, you will see this error when you attempt to setup the Database connection in the Setup Wizard: 2008-04-01 01:45:55,371 ERROR [http-8090-Processor4] [[Standalone].[localhost].[/].[action]] invoke Servlet.service() for servlet action threw exception java.lang.UnsupportedClassVersionError: Bad version number in .class file at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(Unknown Source) at java.security.SecureClassLoader.defineClass(Unknown Source) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1847) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:873) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1326) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1205) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at com.atlassian.confluence.setup.actions.AbstractSetupStandardDatabaseAction.checkDriver(AbstractSetupStandardDatabaseAction.java:20) at com.atlassian.confluence.setup.actions.SetupStandardDatabaseAction.execute(SetupStandardDatabaseAction.java:22) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) You will need to download the correct JDBC Driver based on your PostgreSQL Database Version and also the JDK you are using. Below is a guide to selecting the correct JDBC version from PostgreSQL's website:
There is also a matrix on the page which lists all supported versions for the respective PostgreSQL database versions. |
![]() |
Document generated by Confluence on Jul 09, 2010 01:09 |