how correct change confluence to new oracle database?

[pavelmoscow]

Hello! I find this solution - https://confluence.atlassian.com/display/DOC/Database+Setup+for+Oracle But in file <install>/conf/server.xml not find any DataSource. How fix ?

[MatthewC]

the oracle drivers need to be in the Tomact lib directory, not the Confluence one. Since you are creating a data source in server.xml, it needs to be at that level

C:\Program Files (x86)\Atlassian\Confluence\lib

Searching for your error of

com.atlassian.util.concurrent.LazyReference$InitializationException: java.lang.NullPointerException

There may be some suggestions here:

https://answers.atlassian.com/questions/56733/confluence-suddenly-unusable-java-error

One was oracle account locked, server permissions.

There may be other problems in the logs which can give you a batter idea.

try moving the oracle jar file & try again.

if you have support, you can always contact Atlassian

[pavelmoscow]

Try, but not worked.

[pavelmoscow]

I see in System Information:

Database Information
Database name Oracle
Database version Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
Database Dialect net.sf.hibernate.dialect.Oracle9Dialect
Database Driver Name oracle.jdbc.OracleDriver
Database Driver Version 11.2.0.3.0
Database Connection URL jdbc:oracle:thin:@CURRENTLYHOST:1521:CURRENTLYSID
Database Connection Transaction Isolation Read committed
Database Latency 0

But, not find any xml, or config file in C:\Program Files (x86)\Atlassian\Confluence

C:\Program Files (x86)\Atlassian\Application Data\Confluence

where information can contain.

[pavelmoscow]

I copy ojdbc6.jar into C:\Program Files (x86)\Atlassian\Confluence\confluence\WEB-INF\lib

Lock currently account, restart, and i got some error:

Cause
com.atlassian.util.concurrent.LazyReference$InitializationException: java.lang.NullPointerException
at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:152)

caused by: java.lang.NullPointerException
at com.atlassian.spring.container.ContainerManager.getComponent(ContainerManager.java:33)

[pavelmoscow]

Hi!
Yes, i have running Confluence
Yes, use Oracle
I have use another database ( i create user, and import data from currently database)

I add in server.xml :

<Resource
name="jdbc/confluence"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP) (HOST = HOSTA) (PORT = 1521)) (ADDRESS =(PROTOCOL = TCP) (HOST = HOSTB) (PORT = 1521))(failover= TRUE))(CONNECT_DATA = (SERVICE_NAME = CONFLUENCE_TAF)))"
username="confluence_user"
password="confluence_user"
connectionProperties="SetBigStringTryClob=true"
maxActive="25"
maxIdle="5"
maxWait="10000"
/>

add in web.xml :

<resource-ref>
<description>Connection Pool</description>
<res-ref-name>jdbc/confluence</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

[pavelmoscow]

Lock currently confluence_user in currently database, and after restart, i get error:

Cause
com.atlassian.util.concurrent.LazyReference$InitializationException: java.lang.NullPointerException
at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:152)

caused by: java.lang.NullPointerException
at com.atlassian.spring.container.ContainerManager.getComponent(ContainerManager.java:33)

Stack Trace:[hide]
com.atlassian.util.concurrent.LazyReference$InitializationException: java.lang.NullPointerException
at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:152)
at com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:115)
at com.atlassian.confluence.setup.ConfluenceEncodingFilter.getGlobalSettings(ConfluenceEncodingFilter.java:45)
at com.atlassian.confluence.setup.ConfluenceEncodingFilter.getEncodingInternal(ConfluenceEncodingFilter.java:35)
at com.atlassian.confluence.setup.ConfluenceEncodingFilter.getEncoding(ConfluenceEncodingFilter.java:27)
at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.atlassian.confluence.servlet.FourOhFourErrorLoggingFilter.doFilter(FourOhFourErrorLoggingFilter.java:65)

No, no copied.

Version - Confluence 4.1.2

[MatthewC]

Can you add some more detail to your question "how fix?" isn't very helpful!

• Do you already have a running Confluence?
• Do you already use Oracle?
• Are you currently using another database?
• What errors are you having?
• Have you copied the database drivers in place?
• What version of Confluence?