Confluence Docs 3.0 : Known Issues For Oracle This page last changed on Aug 07, 2009 by jlargman. Use Oracle with thin Oracle 10g JDBC drivers Running Confluence on Websphere with Oracle database 24-hour time format with Oracle 8i ORA-01430: column being added already exists in table Configuring Database Character Encoding Knowledge Base Articles ### 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". ### ORA-01430: column being added already exists in table If any of confluence tables exist in other oracle schemas in the "same database", those tables will not be created, impairing bits of Confluence functionality that depend on those table(s). This issue has been filed in CONF-3613. There is a work around however as found by one of our customers:
        CREATE VIEW wiki_dev.all_objects
        AS
        SELECT *
        FROM sys.all_objects
        WHERE owner = 'WIKI_DEV'
        ;
### Configuring Database Character Encoding Refer to Configuring Database Character Encoding. ### Knowledge Base Articles
java.sql.SQLException ORA-00942 table or view does not exist (db permissions) (Confluence Knowledge Base) Labels: database, oracle, installation, confluence
Unable to Configure Oracle Data Source in Websphere (Confluence Knowledge Base) Labels: websphere, oracle, confluence
Unable to Install Oracle on Websphere due to Classloader Preferences (Confluence Knowledge Base) Labels: websphere, oracle
##### RELATED TOPICS Database Setup for Oracle

Document generated by Confluence on Nov 05, 2009 23:34