How to configure data source profiles for various databases with examples

Owned by Former user (Deleted)
Last updated: Feb 26, 2020 by Smita Nair

Description

With release 5.2, data source profiles allows administrators to configure data sources independent of application data sources. This can be helpful in some situations especially where it is important to bring a data source online without restarting Confluence. Later, the data source can be converted to an application server based data source for better performance and reduced server load. The data source profile needs pretty much all the same database configuration information that normally would be used in an application server data source. This page contains some examples.

Steps

  1. Go to UPM and find SQL for Confluence.
  2. Press Configure button.
  3. Look for second section on Data Source Profiles.
  4. Add an entry based on your specific configuration values and the examples give - column 3 specifically.

Use absolute paths

When you are just starting, use an absolute file path to configure your dbJar parameter. After you have that working, you can experiment with using a relative path instead, if that is important for your environment. Check the server log for errors if there are problems locating your jar file.

Examples

Database InformationJDBC Driver

Profile Configuration

Application Server Resource Configuration

Type: PostgreSQL
Database name: test
Location: localhost
Port: 5432 (default)
 
Macro uses:
  dataSource=testDS
postgresql-9.2-1000.jdbc4.jar

In directory: 
    <install-dir>/lib 




Add a profile named: testDS 
with profile value:
 
dbDriver=org.postgresql.Driver |
dbUrl=jdbc:postgresql://localhost:5432/test |
dbUser=confluence|dbPassword=confluence |
dbJar=lib/postgresql-9.2-1000.jdbc4.jar
<Resource name="jdbc/testDS" 
  auth="Container" 
  type="javax.sql.DataSource"
  driverClassName="org.postgresql.Driver"
  url="jdbc:postgresql://localhost:5432/test"
  username="confluence"
  password="confluence"
  maxActive="10"
  maxIdle="10"
  validationQuery="Select 1"
/>
Type: MS SQL Server
Database name: test
Location: localhost
Port: 1433 (default)
 
Macro uses:
  dataSource=testDS
jtds-1.2.2.jar

In directory: 
    <install-dir>/lib 
Add a profile named: testDS 
with profile value:
 
dbDriver=net.sourceforge.jtds.jdbc.Driver |
dbUrl=jdbc:jtds:sqlserver://localhost:1433/test |
dbUser=confluence|dbPassword=confluence |
dbJar=lib/jtds-1.2.2.jar
<Resource name="jdbc/testDS" 
  auth="Container" 
  type="javax.sql.DataSource"
  driverClassName="net.sourceforge.jtds.jdbc.Driver"
  url="jdbc:jtds:sqlserver://localhost:1433/test"
  username="confluence"
  password="confluence"
  maxActive="10"
  maxIdle="10"
  validationQuery="Select 1"
/>
Type: MS SQL Server
Database name: test
Location: localhost
Port: 2433
 
Macro uses:
  dataSource=testDS
sqljdbc4.jar

In directory: 
    <install-dir>/lib 
Add a profile named: testDS 
with profile value:
dbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver |
dbUrl=jdbc:sqlserver://localhost:2433;database=test;integratedSecurity=false |
dbUser=confluence | dbPassword=confluence | 
dbJar=../lib/sqljdbc4.jar

Similarly.


Type: Oracle
Database name: test
Location: localhost
Port: 1521 (default)
 
Macro uses:
  dataSource=testDS
ojdbc5.jar or ojdbc6.jar

In directory: 
    <install-dir>/lib 
Add a profile named: testDS 
with profile value:
 
dbDriver=oracle.jdbc.OracleDriver |
dbUrl=jdbc:oracle:thin:@localhost:1521:test |
dbUser=confluence|dbPassword=confluence |
dbJar=lib/ojdbc6.jar
<Resource name="jdbc/testDS" 
  auth="Container" 
  type="javax.sql.DataSource"
  driverClassName="oracle.jdbc.OracleDriver"
  url="jdbc:oracle:thin:@localhost:1521:test"
  username="confluence"
  password="confluence"
  maxActive="10"
  maxIdle="10"
  maxWait="10000"
  validationQuery="Select 1"
/>

MS SQL named instances

You may need to add ;instance=<instance_name> to the URL string.