...
| Div |
|---|
|
On this page| Table of Contents |
|---|
| maxLevel | 12 |
|---|
| minLevel | 2 |
|---|
| exclude | On this page |
|---|
| type | flat |
|---|
| separator | pipe |
|---|
|
|
Summary
| Section |
|---|
| Column |
|---|
| This page describes describes Application server based data source configurations. Major elements of the configuration are: - Application server based data source configuration - consult your application server documentation on how this is done and problem determination mechanisms. Note that the configuration may be specific to the application server version. For example, older Tomcat versions have different configurations.
- JDBC driver specific for the database to be accessed - consult your database documentation and other sources for the best JDBC driver to use.
- Installation of JDBC driver on the application server
- Database access - consult your database documentation on how to configure your database for access
|
| Column |
|---|
|
| Info |
|---|
| title | Just 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 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 |
|---|
| title | Updated 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:
...
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.
...
| Tip |
|---|
| title | Consider 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 bewill look like: {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, choosing certain parameter choices options can affect the 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 let us know about the method in your comments on this page.
Problem determination
See Troubleshooting Application Server -based Based Data Sources - 10.x.
| Include Page |
|---|
info:css - pre formatted | info:css - pre formatted
Image Added