Connecting many Databases

In Confluence administration I can setup the settings for one Reporting Connector for SQL Databases. How can I connect to several databases?

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote

Answer accepted

Hi,

You can append an infinite amount of SQL datasources in your server.xml using this format:

&lt;Resource name="jdbc/DB-DATASOURCE-NAME"
    auth="Container"
    type="javax.sql.DataSource"
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://SERVER-NAME:3306/DB-NAME?autoReconnect=true"
    username="DB-USERNAME"
    password="DB-PASSWORD"
    maxActive="25"
    maxIdle="5"
    maxWait="10000"
/&gt;

This requires a confluence restart however. Bob swift made a plugin called SQL pro that allows to do this without restarts, but it will cost extra.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Was this helpful?

Thanks!

Confluence

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Connecting many Databases

1 answer

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Atlassian Community Events