Versions Compared

Old Version 15

changes.mady.by.user Saumya Sunder (Inactive)

Saved on

compared with

New Version 16

changes.mady.by.user Saumya Sunder (Inactive)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Div
idProductTOC

On this page

Table of Contents
maxLevel2
minLevel2
excludeOn this page
typeflat
separatorpipe

Summary

Section


Column

This page describes Application server based data source configurations.

Info
titleJust Upgraded Confluence?

The most common problem after a Confluence upgrade is errors. Ensure that your upgrade procedures include server.xml updates and create a copy of all the JDBC drivers in use to an appropriate location. Also, check out this page for isolating these or application server version differences that cause problems. It is the most likely reason behind errors after an upgrade activity.


Info
titleUpdated documentation

This page is an updated version of a page that has been archived. The previous version of the page has been kept as a reference for links and comments. Some of the comments are still useful as they represent user-contributed questions and configurations or solutions. However, some of the information is also outdated.



Confluence Installation with Tomcat

Many users install the standard Confluence standalone distribution that includes Tomcat. This section will discuss the 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 holds other tomcat jars. If you have a much older version of Confluence without this directory, look for <install-dir>/common/lib instead.

Tomcat configuration

Modify <install-dir>/conf/server.xml to add one or more data source resource elements. Server.xml is an example of adding data sources for various local and non-local databases.

The essential element looks like the sample code mentioned below, where the data source name is myDS:

Code Block
<Resource name="jdbc/myDS"
    auth="Container" 
    type="javax.sql.DataSource" 
    username="confluence" 
    password="confluence"
    maxTotal="25"
    maxWaitMillis="10000"
    maxIdle="10"
    driverClassName="org.postgresql.Driver"
    url="jdbc:postgresql://localhost:5432/mydatabase"
    validationQuery="Select 1"
/>


Tip
titleResource must be within the confluence context tag


No Format
...
<Context path="" docBase="../confluence" debug="0" reloadable="false">
...
<Resource ... />
...
</Context>



Tip
titleConsider using a validation query

Refer to this stack overflow question, to know more about validationQuery with respect to a JNDI data source.


Database examples

The SQL macro markup would be: {sql:dataSource=myDS| ... }  See Examples - 10.x.

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 requires that certain JDBC features are available. In some cases, parameter choices can affect capabilities. User testing and community support are the only help resources available for less popular databases or JDBC drivers. If you have had success with other databases, please mention the same in comments on this page.

Problem determination

See Troubleshooting Application Server-based Data Sources - 10.x.

Include Page
info:css - pre formatted
info:css - pre formatted