...
Code Block | ||||
---|---|---|---|---|
| ||||
<Resource name="jdbc/myDS" auth="Container" type="javax.sql.DataSource" username="confluence" password="confluence" maxActivemaxTotal="25" maxWaitMillis="10010000" maxIdle="10" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/mydatabase" validationQuery="Select 1" /> |
...
The sql macro markup would be: {sql:dataSource=myDS| ... }
...
Database
...
Information
...
JDBC driver example
...
Resource configuration
...
PostgreSQL
...
...
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-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"
/> |
...
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-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
...
...
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
...
...
derbyclient.jar
...
Include Page | ||||
---|---|---|---|---|
|
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.
WebLogic 9.1 Application Server
...
.
...
Problem determination
See Data source configuration - problem determination
...