...
This page provides examples for configuring application server-based data sources across different versions of Confluence with varying configurations.
Confluence 8.0 and higher
| Include Page |
|---|
| _SQL for Confluence 11.x announcement |
|---|
| _SQL for Confluence 11.x announcement |
|---|
|
Confluence 5.8
...
to Confluence 7.20
These are configuration examples based on Tomcat 8 or higher which is shipped with Confluence versions starting with Confluence 5.8.
Database | Information | JDBC Driver Example | Resource Configuration |
|---|
PostgreSQL | PostgreSQL JDBC | postgresql-9.3-1103.postgresql-42.2.2.jar |
| No Format |
|---|
<Resource name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
username="confluence"
password="confluence"
maxTotal="25"
maxWaitMillis="10000"
maxIdle="10"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/confluence"
validationQuery="Select 1"
/> |
|
MySQL | MySql connector | mysql-connector-java-5.1.34.jar |
| No Format |
|---|
<Resource name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/mydatabase?autoReconnect=true"
username="username"
password="password"
maxTotal="25"
maxWaitMillis="10000"
maxIdle="5"
validationQuery="Select 1"
/> |
See
for info on how to configure multiple result sets. |
Oracle | Thin Driver
Oracle 11g JDBC
Oracle 12c JDBC | ojdbc6.jar
ojdbc7.jar |
| No Format |
|---|
<Resource
name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@www.some_server.com:1521:mysid"
username="username"
password="password"
connectionProperties="SetBigStringTryClob=true"
maxTotal="25"
maxWaitMillis="10000"
maxIdle="5"
validationQuery="Select 1 from DUAL"
/> |
|
Oracle Advanced | Thin Driver
Oracle 11g JDBC
Oracle 12c JDBC | ojdbc6.jar
ojdbc7.jar | See Tomcat 6.0 using Oracle Universal Connection Pool. |
Microsoft SQL Server | Using Microsoft's JDBC driver | sqljdbc4.jar | Similar to the other examples here with parameters like the MS SQL Server example on data source profiles. | No Format |
|---|
<Resource
name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="dbc:sqlserver://localhost:1433;database=testing;"
username="username"
password="password"
maxTotal="25"
maxWaitMillis="10000"
maxIdle="10"
validationQuery="Select 1"
/> |
|
Derby | Derby | derbyclient.jar |
| No Format |
|---|
<Resource
name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.apache.derby.jdbc.ClientDriver"
url="jdbc:derby://localhost:1527/dbname"
username="username"
password="password"
maxActive="20"
maxIdle="10"
validationQuery="Select 1"
/> |
|
...
Database | Information | JDBC Driver Example | Resource Configuration |
|---|
PostgreSQL | PostgreSQL JDBC | postgresql-8.2-507.jdbc3.jar |
| No Format |
|---|
<Resource name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
username="confluence"
password="confluence"
maxActive="100"
maxIdle="10"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/confluence"
validationQuery="Select 1"
/> |
|
MySQL | MySql connector | mysql-connector-java-3.1.14-bin.jar |
| No Format |
|---|
<Resource name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/mydatabase?autoReconnect=true"
username="username"
password="password"
maxActive="25"
maxIdle="5"
maxWait="10000"
validationQuery="Select 1"
/> |
See
for info on how to configure multiple result sets. |
Oracle | Thin Driver
Oracle 11g JDBC
Oracle 12c JDBC | ojdbc6.jar
ojdbc7.jar |
| No Format |
|---|
<Resource
name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@www.some_server.com:1521:mysid"
username="username"
password="password"
connectionProperties="SetBigStringTryClob=true"
maxActive="25"
maxIdle="5"
maxWait="10000"
validationQuery="Select 1 from DUAL"
/> |
|
Oracle Advanced | Thin Driver
Oracle 11g JDBC
Oracle 12c JDBC | ojdbc6.jar
ojdbc7.jar | See Tomcat 6.0 using Oracle Universal Connection Pool. |
Microsoft SQL Server | jtds driver | jtds-1.2.2.jar |
| No Format |
|---|
<Resource
name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://mysqlserver:1433/mydatabase"
username="username"
password="password"
maxActive="20"
maxIdle="10"
maxWait="-1"
validationQuery="Select 1"
/> |
|
Microsoft SQL Server | Using Microsoft's JDBC driver | sqljdbc4.jar | Similar to the other examples here with parameters like the MS SQL Server example on data source profiles. |
Derby | Derby | derbyclient.jar |
| No Format |
|---|
<Resource
name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.apache.derby.jdbc.ClientDriver"
url="jdbc:derby://localhost:1527/dbname"
username="username"
password="password"
maxActive="20"
maxIdle="10"
validationQuery="Select 1"
/> |
|
...
Some of our customers have reported slow pages and related problems after upgrading their Confluence versions. This is a likely consequence of running out of connections and having to wait for a connection to become available. The new default of 8 connections are very low for high-volume use cases. This is exacerbated by a no limit wait time, which provides no feedback to page viewer that there is a contention. By reviewing your previous configuration and updating with the new parameters, you should be able to restore the past behavior.
Additional information
Image Modified