Confluence Docs 3.0 : External Database This page last changed on Dec 17, 2008 by ggaskell. ## 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: 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: 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 Guide Confluence Documentation Home

Document generated by Confluence on Nov 05, 2009 23:34