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.

Additional links

How to configure application server data sources (also contains information about JDBC driver links)
Data source profiles
How to do data source problem determination

Steps

Go to UPM and find SQL for Confluence.
Press Configure button.
Look for second section on Data Source Profiles.
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 Information	JDBC Driver	Profile Configuration	Application Server Resource Configuration

Database Information

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