This page last changed on Nov 19, 2007 by smaddox.
Database prerequisites
  • 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'.

Custom Installation - Connecting to your database.

Select one of these options:

  • Standard Database Connection
  • Datasource Connection


1.Standard Database Connection:

This uses a standard JDBC database connection. Connection pooling is handled within Confluence. You will need to know:

  • The Java class name for the appropriate database driver.
  • The JDBC URL for the database you will be connecting to.
  • A valid username and password for that database.
  • 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 speak)

The first two 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 common/lib directory.





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, and know:

  • 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.
  • What kind of database you're connecting to (so you can tell Confluence which "dialect" it needs to speak)

NEXT :

Load Content for the site

RELATED TOPICS

Custom Installation
Confluence Setup Guide
Confluence User Guide
Confluence Documentation Home
Database Configuration


datasource.PNG (image/png)
JDBC.PNG (image/png)
configuredatabase.PNG (image/png)
Document generated by Confluence on Dec 20, 2007 19:02