how correct change confluence to new oracle database?

pavelmoscow September 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
MatthewC
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 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 September 26, 2012

Try, but not worked.

0 votes
pavelmoscow September 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
pavelmoscow September 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 September 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 September 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
MatthewC
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 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?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events