Confluence Docs 3.3 : Known Issues For Oracle
This page last changed on Jul 05, 2010 by alui.
Use Oracle with thin Oracle 10g JDBC driversWe recommend you to use the following configuration to run Confluence with Oracle:
Also see: 24-hour time format with Oracle 8iWe 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 tableIf 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). 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 EncodingRefer to Configuring Database Character Encoding. Knowledge Base Articles
RELATED TOPICS |
![]() |
Document generated by Confluence on Jul 09, 2010 01:09 |