Div | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
Summary
Section | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Confluence
...
Installation With Tomcat
...
Many users install the standard Confluence standalone distribution that includes Tomcat. This section will discuss configuration specific to this application server environment. The most recent versions of Confluence use newer versions of the Tomcat application server where the following configuration examples apply:
JDBC
...
Driver Location
Put the driver jar in <install-dir>/lib - this is the directory that has other tomcat jars. If you have a much older version of Confluence that does not have this directory, look for <install-dir>/common/lib instead.
Tomcat
...
Configuration
Modify <install-dir>/conf/server.xml to add one or more data source Data Source resource elements. server.xml is an example of adding a few data sources Data Sources for various local and non-local databases.
The essential element is something like the following where the data source Data Source name is myDS:
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" /> |
...
Tip | ||
---|---|---|
| ||
...
...
Database
...
Examples
The sql macro markup would be: {sql:dataSource=myDS| ... }
Csv | ||
---|---|---|
| ||
Database, Information, JDBC driver example, Resource configuration
PostgreSQL, [PostgreSQL JDBC|http://jdbc.postgresql.org/], postgresql-8.2-507.jdbc3.jar, "{noformat}
<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""
/>{noformat}"
MySQL, [MySql connector|http://dev.mysql.com/downloads/connector/j/5.1.html], mysql-connector-java-3.1.14-bin.jar, "{noformat}
<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""
/> {noformat}\\ See SQL-146 for info on how to configure multiple result sets."
Oracle, Thin Driver\\ [Oracle 11g JDBC|http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html]\\ [Oracle 12c JDBC|http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html], ojdbc6.jar\\ ojdbc7.jar, "{noformat}
<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""
/> {noformat}"
Oracle Advanced, Thin Driver \\ [Oracle 11g JDBC|http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html]\\ [Oracle 12c JDBC|http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html], ojdbc6.jar\\ ojdbc7.jar, See [Tomcat 6.0 using Oracle Universal Connection Pool|http://www.oracle.com/technetwork/articles/oem/ucp-jdbc-tomcat-355431.html]
Microsoft SQL Server, [jtds driver|http://jtds.sourceforge.net/], jtds-1.2.2.jar, "{noformat}
<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""
/> {noformat}"
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|http://www-03.ibm.com/systems/i/software/toolbox/troubleshooting.html], jt400.jar, "{noformat}
<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""
/>{noformat}"
Derby, [Derby|http://db.apache.org/derby/], derbyclient.jar, "{noformat}
<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""
/>{noformat}"
|
...
See Examples.
Further Configuration Management
See How to limit active database connections
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
- In the WebLogic console, under Services > JDBC, create a data source (see WebLogic's documentation on how to Configure JDBC data sources for more information).
- Take note of the JNDI name you used to create the data source.
- Point the SQL macro to that JNDI name (dataSource parameter).
Problem determination
...
Problem determination
See Troubleshooting Application Server-based Data Sources.
Include Page | ||||
---|---|---|---|---|
|