It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Published in Confluence Cloud

Convert your old pages to the new editor

Hey Community 👋, Following the recent release of the new editor, we will be releasing the ability for users to convert existing pages from the legacy editor to the new editor. We’ve been resp...

4,224 views 27 20
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you