how correct change confluence to new oracle database?

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 ?

6 answers

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?

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

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>

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)

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.

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

Try, but not worked.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

62 views 3 2
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you