/
Data source configuration - application server - Examples - 8.x

 



Data source configuration - application server - Examples - 8.x

Owned by Randall Ward
Last updated: Apr 21, 2023 by Taiwo Akindele (Unlicensed)Version comment

These are configuration examples based on Tomcat 8 or higher which is shipped with Confluence versions starting with Confluence 5.8. See also: Data source configuration differences starting with Confluence 5.8 - 8.x.

Database

Information

JDBC driver example

Resource configuration

PostgreSQL

PostgreSQL JDBC

postgresql-9.3-1103.jdbc41.jar

<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

 <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 SQL-146 - Getting issue details... STATUS for information on how to configure multiple result sets.

Oracle

Thin Driver
Oracle 11g JDBC
Oracle 12c JDBC

ojdbc6.jar
ojdbc7.jar

<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

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

Derby

Derby

derbyclient.jar

<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"
/>

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.