This documentation relates to an early version of Confluence.
View this page in the current documentation or visit the current documentation home.

Known Issues For Oracle

Added by Nick Faiz, last edited by Gurleen Anand on May 22, 2007
All Versions
Click for all versions
Confluence 2.6 Documentation

Index

Use Oracle with thin Oracle 10g JDBC drivers

We recommend you to use the following configuration to run Confluence with Oracle:

  • Regardless of what version of the Oracle database you are using, you should use the Oracle 10g JDBC drivers. (Note: Oracle 10g JDBC drivers will not work with Oracle 8.1.6
    see Oracle FAQ)
  • We highly recommend to use the thin drivers.

Also see:

Running Confluence on Websphere with Oracle database

If you are planning to run Confluence on a Websphere application server and Oracle database, you should read the information on Known Issues for Websphere.

24-hour time format with Oracle 8i

We have received a report from a user that when an Oracle 8i database is configured to use 24-hour time as the default format, an exception like this may occur:

005-12-06 13:23:20 Loading root WebApplicationContext


2005-12-06 13:24:34 StandardContext[]: Exception sending context initialized event to listener instance
of class com.atlassian.confluence.util.ConfluenceContextLoaderListener

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userAccessor' defined in class path resource [applicationContext.xml]:
Can't resolve reference to bean 'userAccessorTarget' while setting property 'target';
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userAccessorTarget' defined in class path
resource [applicationContext.xml]: Can't resolve reference to bean 'spacePermissionManager' while setting property 'spacePermissionManager';
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'spacePermissionManager' defined in class path resource [securityContext.xml]:
Can't resolve reference to bean 'spacePermissionManagerTarget' while setting property 'target';
nested exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'spacePermissionManagerTarget' defined in class path resource [securityContext.xml]: Initialization of bean failed;
nested exception is org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [Cannot create PoolableConnectionFactory];
nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory

...

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause:


java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1


ORA-12705: invalid or unknown NLS parameter value specified

One symptom of this problem is that Confluence may refuse to start after midday.

The workaround is to go to 'General Configuration' and set the default time format to "HH:mm".

Configuring Database Character Encoding

Refer to Configuring Database Character Encoding.

Labels

known-issues-db known-issues-db Delete
oracle-setup oracle-setup Delete
oracle oracle Delete
known-issues known-issues Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.