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 to setup a second datasource in confluence?

John Constantinou Sep 18, 2012

Hello,

I would like to configure a second datasource in confluence. From the manual "Database Setup for Oracle" it gives an example for setting up only one datasource: https://confluence.atlassian.com/display/CONF35/Database+Setup+for+Oracle. Does anyone know how i can do that?

Thank you very much for your help!

Best Regards,

John

1 answer

0 votes
Nic Brough [Adaptavist] Community Leader Sep 18, 2012

On the Confluence side, you just add another "resource" section.

However, I'm really not sure that's of any help to you because I don't know why you want to set up a new datasource (although I can think of a few possibilities, I'm not going to guess and wander off in the wrong direction) That will make it available for use inside Confluence, but you'll then need to write stuff to actually use it...

John Constantinou Sep 18, 2012

Hi Nic,

Thanks a lot for your reply! I have already added that in server.xml and web.xml of tomcat but somehow i have to link that with confluence (smth. like java:comp/env/jdbc/confluence) as i did for the first one. I need this as i am connecting with two databases.

Thank you once again!

Best Regards,

John

Nic Brough [Adaptavist] Community Leader Sep 18, 2012

I don't know what you mean by "link that with confluence", or what you want to do with the second connection?

Nic Brough [Adaptavist] Community Leader Sep 18, 2012

You're missing the point, sorry, I'm not being clear.

Why do you want to connect to two databases? What is the goal?

John Constantinou Sep 18, 2012

I mean when you set up confluence with an external database you have to provide the name of the datasource. In the setup there is no other choice of providing a second name. I am doing this because I want to connect at these two databases at the same time.

Nic Brough [Adaptavist] Community Leader Sep 18, 2012

I'm afraid I still don't understand. What are you actually trying to do? I understand that you want to access data in another database, but what do you want to do with it?

John Constantinou Sep 18, 2012

Ou sorry...because the data that i am retrieving from these two databases are different and the thing is that i can not change that in order to put everything in one.

John Constantinou Sep 18, 2012

Hi Nic, the documentation is for the confluence as a whole and not for a plugin. I think for a plugin you can add as many datasources as you want.

Greetings,

Nic Brough [Adaptavist] Community Leader Sep 18, 2012

I'm well aware of that. It only covers a single datasource because Confluence only uses one, but the theory applies if you want to make more available. What matters is what you actually want to do with another datasource, which you aren't saying.

Normally you define additional datasources for use by the SQL Plugin for Confluence

John Constantinou Sep 18, 2012

Hi Bob,

Yes i actually found that example, and it works :)!

Thank you all for your help!

Greetings,

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

1,505 views 8 19
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