Versions Compared

Old Version 3

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

Saved on

compared with

New Version Current

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

Saved on

Key

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


Div
idProductTOC

On this page

Table of Contents
maxLevel
1
2
minLevel2
excludeOn this page
typeflat
separatorpipe

Summary

Section


Column
width40

This page describes describes Application server - based Data Source  data source configurations.

Major elements of the configuration are:

  • Application server - based Data Source data source configuration - consult your application server documentation on the problem determination mechanisms and how this is done and problem determination mechanisms. Note that the configuration configuration may be specific to the application server version. For example, older Tomcat versions have  have different configurations.
  • JDBC driver , specific to the accessed database for the database to be accessed - consult your database documentation and other sources for the compatible best JDBC driver to use.
  • Installation of the JDBC driver on the application server.
  • Database access - consult your database documentation on how to configure your database for access.


Column
width60


Info
titleJust Upgraded 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 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. If you get errors immediately  It is the most likely reason behind errors after an upgrade , this is the most likely causeactivity.


Info
titleUpdated documentation

This page is an updated from version of a previous version page that has been archived as SQL for Confluence datasource configuration. The former 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 user contributed configurations and or solutions. However, some of the information is also out datedoutdated.



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 has holds other tomcat jars. If you have a much older version of Confluence that does not have  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 data source resource elements. serverServer.xml is an example of adding a few Data Sources data sources for various local and non-local databases.

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

xml
Code Block
xml
<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

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

Database

...

examples

The sql SQL macro markup would bewill look like: {sql:dataSource=myDS| ... }  See Examples - 910.x.

Further

...

configuration management

See How to how to limit active database connections.

Other

...

databases

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

Problem determination

See See Troubleshooting Application Server -based Based Data Sources - 910.x.

Include Pageinfo:css - pre formattedinfo:css - pre formattedImage Added