Page Comparison

Type: PostgreSQL
Database name: test
Location: localhost
Port: 5432 (default)
 
Macro uses:
  dataSource=testDS

postgresql-9.2-1000.jdbc4.jar

In directory: 
    <install-dir>/lib 

Add a profile named: testDS 
with profile value:
 
dbDriver=org.postgresql.Driver |
dbUrl=jdbc:postgresql://localhost:5432/test |
dbUser=confluence|dbPassword=confluence |
dbJar=lib/postgresql-9.2-1000.jdbc4.jar

<Resource name="jdbc/testDS" 
  auth="Container" 
  type="javax.sql.DataSource"
  driverClassName="org.postgresql.Driver"
  url="jdbc:postgresql://localhost:5432/test"
  username="confluence"
  password="confluence"
  maxActive="10"
  maxIdle="10"
  validationQuery="Select 1"
/>

Type: MSMy SQL Server
Database name: test
Location: localhost
Port: 1433 (default)
 
Macro uses:
  dataSource=testDS

jtds-1.2.2.jar

In directory: 
    <install-dir>/lib 

Add a profile named: testDS 
with profile value:
 
dbDriver=net.sourceforge.jtds.jdbc.Driver |
dbUrl=jdbc:jtds:sqlserver://localhost:1433/test |
dbUser=confluence|dbPassword=confluence |
dbJar=lib/jtds-1.2.2.jar

<Resource name="jdbc/testDS" 
  auth="Container" 
  type="javax.sql.DataSource"
  driverClassName="net.sourceforge.jtds.jdbc.Driver"
  url="jdbc:jtds:sqlserver://localhost:1433/test"
  username="confluence"
  password="confluence"
  maxActive="10"
  maxIdle="10"
  validationQuery="Select 1"
/>

Type: MS SQL Server
Database name: test
Location: localhost
Port: 2433
 
Macro uses:
  dataSource=testDS

sqljdbc4.jar

In directory: 
    <install-dir>/lib 

Add a profile named: testDS 
with profile value:
dbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver |
dbUrl=jdbc:sqlserver://localhost:2433;database=test;integratedSecurity=false |
dbUser=confluence | dbPassword=confluence | 
dbJar=../lib/sqljdbc4.jar

Type: Oracle
Database name: test
Location: localhost
Port: 1521 (default)
 
Macro uses:
  dataSource=testDS

ojdbc5.jar or ojdbc6.jar

In directory: 
    <install-dir>/lib 

Add a profile named: testDS 
with profile value:
 
dbDriver=oracle.jdbc.OracleDriver |
dbUrl=jdbc:oracle:thin:@localhost:1521:test |
dbUser=confluence|dbPassword=confluence |
dbJar=lib/ojdbc6.jar

<Resource name="jdbc/testDS" 
  auth="Container" 
  type="javax.sql.DataSource"
  driverClassName="oracle.jdbc.OracleDriver"
  url="jdbc:oracle:thin:@localhost:1521:test"
  username="confluence"
  password="confluence"
  maxActive="10"
  maxIdle="10"
  maxWait="10000"
  validationQuery="Select 1"
/>