...
This page provides example configurations for Application application server-based Data Source data source for different Confluence versions and configuration differences with Confluence versions.
...
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.jdbc41.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 | 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"
maxTotal="25"
maxWaitMillis="10000"
maxIdle="10"
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 | DB2 for IBM i | JTOpen | jt400.jar | | No Format |
|---|
<Resource
name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.ibm.as400.access.AS400JDBCDriver"
url="jdbc:as400://ibmi;prompt=false;translate binary=true; extended metadata=true"
username="username"
password="password"
maxActive="20"
maxIdle="10"
maxWait="-1"
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 | DB2 for IBM i | JTOpen | jt400.jar | | No Format |
|---|
<Resource
name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.ibm.as400.access.AS400JDBCDriver"
url="jdbc:as400://ibmi;prompt=false;translate binary=true; extended metadata=true"
username="username"
password="password"
maxActive="20"
maxIdle="10"
maxWait="-1"
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"
/> |
|
...
There was a significant change in configuration values between Tomcat 7 (before Confluence 5.8) and Tomcat 8 (after Confluence 5.8). Confluence administrators should review their server.xml configuration and make adjustments.
...