.png?version=1&modificationDate=1662627367996&cacheVersion=1&api=v2&width=226&height=72)
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 will give some examples.
Links
- Configure application server based datasources
- Data source profiles
- Datasource problem determination
- JDBC driver links - see: Configure application server based datasources
Steps
- Go to UPM and find SQL for Confluence
- Press Configure button
- Select the View and modify data source profiles tab.
- Click Add profile.
- 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 |
|---|---|---|---|
Type: PostgreSQL Database name: test Location: localhost Port: 5432 (default) Macro uses: dataSource=testDS | postgresql-42.2.2.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-42.2.2.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: My SQL Database name: test Location: localhost Port: 1433 (default) Macro uses: dataSource=testDS | mysql-connector-java-5.1.47.jar
In directory:
<install-dir>/lib
| Add a profile named: testDS with profile value: dbDriver=com.mysql.jdbc.Driver | dbUrl=jdbc:jtds:sqlserver://localhost:3306/test | dbUser=confluence|dbPassword=confluence | dbJar=lib/mysql-connector-java-5.1.47.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 | mssql-jdbc-7.0.0.jre8.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/mssql-jdbc-7.0.0.jre8.jar | Similarly. |
Type: Oracle Database name: test Location: localhost Port: 1521 (default) Macro uses: dataSource=testDS | ojdbc6-11.2.0.3.jar
In directory:
<install-dir>/lib
| Add a profile named: testDS with profile value: dbDriver=oracle.jdbc.OracleDriver | dbUrl=jdbc:oracle:thin:@206.189.142.13:1521/XE | dbUser=confluence|dbPassword=confluence | dbJar=.../oracle/ojdbc6/11.2.0.3.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.
