...
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 a 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 a application server data source. This will give some examples.
Links
- 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
| Tip |
|---|
|
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 |
|---|
| No Format |
|---|
Type: PostgreSQL
Database name: test
Location: localhost
Port: 5432 (default)
Macro uses:
dataSource=testDS |
|
| No Format |
|---|
postgresql-9.2-1000.jdbc4.jar
In directory:
<install-dir>/lib |
|
| No Format |
|---|
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 |
|
| No Format |
|---|
<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"
/> |
|
| No Format |
|---|
Type: MS SQL Server
Database name: test
Location: localhost
Port: 1433 (default)
Macro uses:
dataSource=testDS |
|
| No Format |
|---|
jtds-1.2.2.jar
In directory:
<install-dir>/lib |
|
| No Format |
|---|
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 |
|
| No Format |
|---|
<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"
/> |
|
| No Format |
|---|
Type: MS SQL Server
Database name: test
Location: localhost
Port: 2433
Macro uses:
dataSource=testDS |
|
| No Format |
|---|
sqljdbc4.jar
In directory:
<install-dir>/lib |
|
| No Format |
|---|
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.
|
| No Format |
|---|
Type: Oracle
Database name: test
Location: localhost
Port: 1521 (default)
Macro uses:
dataSource=testDS |
|
| No Format |
|---|
ojdbc5.jar or ojdbc6.jar
In directory:
<install-dir>/lib |
|
| No Format |
|---|
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 |
|
| No Format |
|---|
<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"
/> |
|
| Tip |
|---|
| title | MS SQL named instances |
|---|
|
You may need to add ;instance=<instance_name> to the url string. |
...