Connecting many Databases

[Daniel Richli]

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

[Jonas Andersson · Accepted solution]

Hi,

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

<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"
/>

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.