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