Confluence upgrade to version 5.5

Hello All,

I am setting up linux test environment for Confluence upgrade, I downloaded atlassian-confluence-5.5.tar.gz, unpacked it, did setting properly and start it, then choose trial version and enter the license , after that set Jira as user management. How can I switch to use test Oracle db, instead of emb HSQL ( which is deafult ). Is there GUI settings or I need to modify confluence.cfg.xml and server.xml , with restarting Confluence itself ? Please, advise on this. Thank you in advance.

Regards,

Milan

3 answers

1 accepted

0 votes
Accepted answer

Finally, it's working. I choose 'Production installation' and set external database. I checked Oracle DB tables, and indeed there is BANDANA. Thank you Rodigo for your hint.

Regards,

Milan

Hi Milan.

Great to hear that my suggestion worked for you :)

Have a great day!

Cheers,

Rodrigo

Hi Milan, you'll need to edit the confluence.cfg.xml file (no need to edite the server.xml). You can see more details about connection Confluence with Oracle in this doc. Also, if you want to migrate the information from your HSQL to your new Oracle database, check the steps here.

I hope it helps.

Cheers

Hello All

I changed confluence.cfg.xml, also I have JDBC driver ( ojdbc6.jar in <Conf install>/confluence/WEB_INF/lib directory ).

Content of confluence.cfg.xml

<property name="hibernate.c3p0.acquire_increment">1</property>

<property name="hibernate.c3p0.idle_test_period">100</property>

<property name="hibernate.c3p0.max_size">30</property>

<property name="hibernate.c3p0.max_statements">0</property>

<property name="hibernate.c3p0.min_size">0</property>

<property name="hibernate.c3p0.timeout">30</property>

<property name="hibernate.connection.SetBigStringTryClob">true</property>

<property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>

<property name="hibernate.connection.password">*************</property>

<property name="hibernate.connection.url">jdbc:oracle:thin:@****:10080:******</property>

<property name="hibernate.connection.username">********</property>

<property name="hibernate.dialect">com.atlassian.hibernate.dialect.Oracle10gDialect</property>

<property name="hibernate.setup">true</property>

This is an error from <Conf HOME dir/logs/

2014-05-26 11:50:50,182 DEBUG [localhost-startStop-1] [sf.hibernate.hql.QueryTranslator] logQuery SQL: select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )and(confluence0_.BANDANAKEY=? )

2014-05-26 11:50:50,196 DEBUG [localhost-startStop-1] [sf.hibernate.util.JDBCExceptionReporter] logExceptions SQL Exception

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Should I create table BANDANA ? Or something else is still not correct ?

Regards,

Milan

0 votes

Hi Milan,

From the error above, it seems the table doesn't exist in Oracle database. Do you have a backup of confluence in Oracle or is this the first time you are using confluence?

If this is the first time that you are using and you don't have a backup in Oracle, then you'll have to install confluence from scratch by deleting the home folder and starting confluence again.

Then you'll see the same initial setup window and you must choose production installation -> external database -> Oracle. By doing this, confluence will install in the database and create the necessary tables and other configurations to run.

Edit. Also remember to place the Oracle JDBC driver in the correct folder before starting confluence as stated here.

cheers!

Rodrigo

Hello Rodrigo

Thank you for your feedback. JUst to doble check :

Is this valid approch , even if I have evaluation license and I setting test environment ( as suggested ) before upgrade. Yes, it was first and now I wanted to switch to Oracle DB. For me it's not the problem to start from scratch.

Regards,

Milan

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,059 views 16 14
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