Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

PostgreSQL

Form of configuration:

Code Block
languagejava
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:


Panel
borderColorgrey
borderStyledashed

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:

Code Block
languagejava
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:

Panel
borderColorgrey
borderStyledashed

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:

Code Block
languagejava
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:

Panel
borderColorgrey
borderStyledashed

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:

Code Block
languagejava
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:

Panel
borderColorgrey
borderStyledashed

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:

Code Block
languagejava
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:

Panel
borderColorgrey
borderStyledashed

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