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?

pavelmoscow Sep 26, 2012
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

0 votes
Matthew Cobby Sep 26, 2012

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?

0 votes
pavelmoscow Sep 26, 2012

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

0 votes
pavelmoscow Sep 26, 2012

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>

0 votes
pavelmoscow Sep 26, 2012

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)

0 votes
pavelmoscow Sep 26, 2012

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.

0 votes
Matthew Cobby Sep 26, 2012

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 Sep 26, 2012

Try, but not worked.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

2,040 views 11 27
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