PostgreSQL
Form of configuration:
Code Block | ||
---|---|---|
| ||
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 | ||||
---|---|---|---|---|
| ||||
dbUrl=jdbc:postgresql://10.10.0.101:5432/conf621 |
MySQL
Form of configuration:
Code Block | ||
---|---|---|
| ||
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 | ||||
---|---|---|---|---|
| ||||
dbUrl=jdbc:mysql://10.10.0.101:3306/confluence610 |
Microsoft SQL Server
Form of configuration:
Code Block | ||
---|---|---|
| ||
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 | ||||
---|---|---|---|---|
| ||||
dbUrl=jdbc:sqlserver://199.193.195.111:1433;database=testing;integratedSecurity=false |
Microsoft SQL Server with jtds
Form of configuration:
Code Block | ||
---|---|---|
| ||
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 | ||||
---|---|---|---|---|
| ||||
dbUrl=jdbc:jtds:sqlserver://10.10.0.101:1433/testing |
Oracle
Form of configuration:
Code Block | ||
---|---|---|
| ||
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 | ||||
---|---|---|---|---|
| ||||
dbUrl=jdbc:oracle:thin:@10.10.0.101:1433:testing |