Versions Compared

Old Version 11

changes.mady.by.user Bob Swift

Saved on

compared with

New Version 12

changes.mady.by.user Automation User

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Convert

...

The sql macro markup would be: {sql:dataSource=myDS| ... }

...

Database

...

outputwiki

...

Information

JDBC driver example

Resource configuration

PostgreSQL

PostgreSQL JDBC

postgresql-8.2-507.jdbc3.jar

...

No Format

<Resource name="

...

jdbc/myDS"

...


    auth="

...

Container"

...


    type="

...

javax.sql.DataSource"

...


    username="

...

confluence"

...


    password=

...

"confluence

...

"
    maxActive=

...

"100

...

"
    maxIdle="

...

10"

...


    driverClassName="

...

org.postgresql.Driver

...

"
    url=

...

"jdbc:postgresql://localhost:5432/confluence"

...


    validationQuery="

...

Select 1"

...


/>

...

 MySQL 
 MySql connector 
 mysql-connector-java-3.1.14-bin.jar 
...
 No Format

 <Resource name="
...
jdbc/myDS"
...

    auth=
...
"Container
...
"
    type="
...
javax.sql.DataSource"
...

    driverClassName="
...
com.mysql.jdbc.Driver"
...

    url="
...
jdbc:mysql://localhost/mydatabase?autoReconnect=true
...
"
    username=
...
"username"
...

    password="
...
password"
...

    maxActive="
...
25"
...

    maxIdle="
...
5"
...

    maxWait="
...
10000"
...

    validationQuery="
...
Select 1
...
"
/> 
...

 See SQL-146 
...
 for 
...
 info 
...
 on 
...
 how 
...
 to 
...
 configure 
...
 multiple 
...
 result 
...
 sets. 
...
 Oracle 
...
 Thin 
...
 Driver
...

Oracle 
...
 11g 
...
JDBC
 Oracle 12c JDBC 
 ojdbc6.jar
 ojdbc7.jar 
 No Format

<Resource
    name="
...
jdbc/myDS"
...

    auth="
...
Container"
...

    type=
...
"javax.sql.DataSource
...
"
    driverClassName=
...
"oracle.jdbc.OracleDriver
...
"
    url="
...
jdbc:oracle:thin:@www.some_server.com:1521:mysid"
...

    username="
...
username
...
"
    password=
...
"password"
...

    connectionProperties="
...
SetBigStringTryClob=true"
...

    maxActive="
...
25"
...

    maxIdle="
...
5"
...

    maxWait="
...
10000"
...

    validationQuery="
...
Select 1 from DUAL
...
"
/> 
...
 Oracle 
...
 Advanced 
...
 Thin 
...
 Driver 
...

Oracle 
...
 11g 
...
JDBC
 Oracle 12c JDBC 
 ojdbc6.jar
 ojdbc7.jar 
 See Tomcat 6.0 using Oracle Universal Connection Pool 
 Microsoft SQL Server 
 jtds driver 
 jtds-1.2.2.jar 
...
 No Format

<Resource
    name=
...
"jdbc/myDS"
...

    auth="
...
Container"
...

    type="
...
javax.sql.DataSource"
...

    driverClassName="
...
net.sourceforge.jtds.jdbc.Driver"
...

    url="
...
jdbc:jtds:sqlserver://mysqlserver:1433/mydatabase"
...

    username="
...
username
...
"
    password=
...
"password
...
"
    maxActive=
...
"20"
...

    maxIdle="
...
10"
...

    maxWait=
...
"-1
...
"
    validationQuery="
...
Select 1"
...

/> 
...
 Microsoft 
...
 SQL 
...
 Server 
...
 Using 
...
 Microsoft's 
...
 jdbc 
...
 driver 
...
 sqljdbc4.jar 
...
 Similar 
...
 to 
...
 the 
...
 other 
...
 examples 
...
 here 
...
 with 
...
 parameters 
...
 like 
...
 the 
...
 MS 
...
 SQL 
...
 Server 
...
 example 
...
 on 
...
Data 
...
 Source 
...
 Profiles
...
 DB2 
...
 for 
...
 IBM 
...
 i 
...
 JTOpen 
 jt400.jar 
...
 No Format

<Resource
    name="
...
jdbc/myDS"
...

    auth=
...
"Container
...
"
    type="
...
javax.sql.DataSource"
...

    driverClassName="
...
com.ibm.as400.access.AS400JDBCDriver"
...

    url="
...
jdbc:as400://ibmi;prompt=false;translate binary=true; extended metadata=true
...
"
    username=
...
"username"
...

    password="
...
password"
...

    maxActive="
...
20"
...

    maxIdle="
...
10"
...

    maxWait="
...
-1"
...

    validationQuery="
...
Select 1
...
"
/>
...
 Derby 
 Derby 
 derbyclient.jar 
 No Format

<Resource
    name="
...
jdbc/myDS"
...

    auth="
...
Container
...
"
    type=
...
"javax.sql.DataSource
...
"
    driverClassName=
...
"org.apache.derby.jdbc.ClientDriver"
...

    url="
...
jdbc:derby://localhost:1527/dbname"
...

    username=
...
"username
...
"
    password="
...
password"
...

    maxActive="
...
20"
...

    maxIdle="
...
10"
...

    validationQuery="
...
Select 1"
...

/>
...
Other databases
Support for other databases depends on the capabilities provided by the JDBC driver. SQL expects certain JDBC features to be available. In some cases, parameter choices can affect which capabilities are needed. User testing and community support is about the only help that is available for less popular databases/JDBC drivers. If you have had success with other databases, please add information to this page.
...