Example profile configurations - 11.x

PostgreSQL

Form of configuration:

dbUrl=jdbc:postgresql://[Host IP or DNS]:[PORT]/[Database Name]
dbUser=[Username]
dbPassword=[Password]
dbJar=[Path]/postgresql-[Version].jar 
dbDriver=org.postgresql.Driver
dbConnectionProperties=[property=value[,property=value]]

Working example:

dbUrl=jdbc:postgresql://10.10.0.101:5432/conf621
dbUser=admin
dbPassword=admin
dbJar=/Applications/atlassian/confluence/dbLib/postgresql-9.4.1212.jre7.jar
dbDriver=org.postgresql.Driver
dbConnectionProperties=loglevel=2

MySQL

Form of configuration:

dbUrl=jdbc:mysql://[Host IP or DNS]:[PORT]/[Database Name]
dbUser=[Username]
dbPassword=[Password]
dbJar=[Path]/mysql-[Version].jar 
dbDriver=org.mysql.jdbc.Driver
dbConnectionProperties=[property=value[,property=value]]

Working example:

dbUrl=jdbc:mysql://10.10.0.101:3306/confluence610
dbUser=admin
dbPassword=admin
dbJar=http://central.maven.org/maven2/mysql/mysql-connector-java/5.1.34/mysql-connector-java-5.1.34.jar
dbDriver=org.mysql.jdbc.Driver
dbConnectionProperties=loglevel=2

Microsoft SQL Server

Form of configuration:

dbUrl=jdbc:sqlserver://[Host IP or DNS]:[PORT]/[;database=Database Name][;integratedSecurity=[True/False]]
dbUser=[Username]
dbPassword=[Password]
dbJar=[Path]/sqljdbc-[Version].jar 
dbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
dbConnectionProperties=[property=value[,property=value]]

Working example:

dbUrl=jdbc:sqlserver://199.193.195.111:1433;database=testing;integratedSecurity=false
dbUser=admin
dbPassword=admin
dbJar=C:\Application Data\atlassian\confluence\sqljdbc-4-4.jar
dbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
dbConnectionProperties=loglevel=2

Microsoft SQL Server with jtds

Form of configuration:

dbUrl=jdbc:jtds:sqlserver://[Host IP or DNS]:[PORT]/[Database Name]
dbUser=[Username]
dbPassword=[Password]
dbJar=[Path]/jtds-[Version].jar 
dbDriver=net.sourceforge.jtds.jdbc.Driver
dbConnectionProperties=[property=value[,property=value]]

Working example:

dbUrl=jdbc:jtds:sqlserver://10.10.0.101:1433/testing
dbUser=admin
dbPassword=admin
dbJar=C:\Application Data\atlassian\confluence\jtds-1.3.1.jar
dbDriver=net.sourceforge.jtds.jdbc.Driver
dbConnectionProperties=loglevel=2

Oracle

Form of configuration:

dbUrl=jdbc:oracle:thin://[Host IP or DNS]:[PORT]:[Database Name]
dbUser=[Username]
dbPassword=[Password]
dbJar=[Path]/jtds-ojdbc6.jar 
dbDriver=oracle.jdbc.OracleDriver
dbConnectionProperties=[property=value[,property=value]]

Working example:

dbUrl=jdbc:oracle:thin:@10.10.0.101:1433:testing
dbUser=admin
dbPassword=admin
dbJar=/var/opt/atlassian/confluence/lib/ojdbc6.jar
dbDriver=oracle.jdbc.OracleDriver
dbConnectionProperties=loglevel=2