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.
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.
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
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 ?
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.
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.
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...
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!
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