Data source configuration - application server - Examples for Confluence 5.7 and lower - 8.x
This content is archived.
These are configuration examples based on Tomcat 6 or 7 shipped with Confluence versions before 5.8.
Database | Information | JDBC driver example | Resource configuration |
|---|---|---|---|
PostgreSQL | postgresql-8.2-507.jdbc3.jar | <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-java-3.1.14-bin.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"
maxActive="25"
maxIdle="5"
maxWait="10000"
validationQuery="Select 1"
/>
SQL-146
-
Getting issue details...
STATUS
for information on how to configure multiple result sets. | |
Oracle | Thin Driver | ojdbc6.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"
maxActive="25"
maxIdle="5"
maxWait="10000"
validationQuery="Select 1 from DUAL"
/> |
Oracle Advanced | Thin Driver | ojdbc6.jar | |
Microsoft SQL Server | 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"
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 | 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"
/> |
Need support? Create a request with our support team.