Custom Installation - Connecting to an External Database

This page is part of the Confluence Setup Guide.

Before you Start

  • Character encoding:
    • We strongly recommend that character encoding is consistent across your database, application server and web application, and that you use UTF-8 encoding.
    • Before setting up your database, please read about configuring character encoding.
  • Database name: When creating a new external database, give it the name 'confluence'.

You can choose to configure your database via a standard JDBC connection or via a server-managed datasource connection. Choose one of the two options below.

Option 1: Standard Database Connection — This uses a standard JDBC database connection. Connection pooling is handled within Confluence.

Screenshot above: Standard (JDBC) connection

Supply the following information:

  • Driver Class Name — The Java class name for the appropriate database driver. This will depend on the JDBC driver, and will be found in the documentation for your database. You will also need to put the appropriate database driver 'jar' file in the server's classpath. For the standalone version, this means copying the jar file into the <confluence-install>/lib directory.
  • Database URL — The JDBC URL for the database you will be connecting to. This will depend on the JDBC driver, and will be found in the documentation for your database.
  • User Name — A valid username which Confluence will use to access your database.
  • Password — The password corresponding to the above username.

You will also need to know:

  • The size of the connection pool Confluence should maintain. If in doubt, just go with the default provided.
  • What kind of database you're connecting to, so you can tell Confluence which dialect it needs to use.

Option 2: Datasource Connection — This asks the Java application server for a database connection. You will need to have configured a datasource into your application server.

Screenshot above: Datasource connection

Supply the following information:

  • Datasource Name — The JNDI name of the datasource, as configured in the application server.
    Note: Some servers will have JNDI names like jdbc/datasourcename; others will be of the form java:comp/env/jdbc/datasourcename. Consult your application-server documentation.

You will also need to know:

  • What kind of database you're connecting to, so you can tell Confluence which dialect it needs to use.

Next Step

Load content for the site

RELATED TOPICS

Database Configuration
Confluence Setup Guide
Confluence User's Guide
Confluence Documentation Home

  • No labels

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.