This page contains instructions on how to set up an SQL Server datasource connection for Confluence or Confluence EAR/WAR.
On this page:
1. Install the Driver
- Download the latest SQLServer JTDS drivers from http://sourceforge.net/projects/jtds/files/.
- After unpacking the file you have downloaded, you'll find a file called something like
jtds-1.2.5.jar(whatever is the latest version). - Copy this file into the
common/libdirectory of your Tomcat installation. Be aware that this directory may be justlibfor Tomcat version 6 and beyond (i.e.<tomcat-install>/librather than<tomcat-install>/common/lib).
2. Shut down Tomcat
- Run
bin/shutdown.shorbin/shutdown.batto bring Tomcat down while you are making these changes.
3. Configure Tomcat
Firstly, you need to edit <confluence install>/conf/server.xmland find the following lines:
<Context path="" docBase="../confluence" debug="0" reloadable="true"> <!-- Logger is deprecated in Tomcat 5.5. Logging configuration for Confluence is specified in confluence/WEB-INF/classes/log4j.properties -->Within the Context tags, directly after the opening <Context.../> line, insert the DataSource Resource tag:
<Resource name="jdbc/confluence" auth="Container" type="javax.sql.DataSource" username="yourDatabaseUser" password="yourDatabasePassword" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://localhost:1433/yourDatabaseName" maxActive="20" maxIdle="10" validationQuery="select 1" />- Replace the username and password parameters with the correct values for your database
- In the url parameter, replace the word 'yourDatabaseName' with the name of the database your confluence data will be stored in.
4. Configure the Confluence web application
- Edit
/confluence/WEB-INF/web.xmlin your confluence installation Go to the end of the file and just before </web-app>, insert the following:
<resource-ref> <description>Connection Pool</description> <res-ref-name>jdbc/confluence</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
5. Configure Confluence
- If you have not yet set up Confluence
- Follow the steps in the Confluence Setup Guide.
- In the Database Setup section, choose the "Datasource Connection" option.
- Set the JNDI name to
java:comp/env/jdbc/confluence - Set the Database dialect to SQL Server.
- If you are changing an existing Confluence installation over to using a Tomcat datasource
- Edit the
<confluence home>/confluence.cfg.xmlfile - Delete any line that contains a property that begins with hibernate.
Insert the following at the start of the <properties> section.
<property name="hibernate.setup">true</property> <property name="hibernate.dialect">net.sf.hibernate.dialect.SQLServerIntlDialect</property> <property name="hibernate.connection.datasource">java:comp/env/jdbc/confluence</property>
- Restart Confluence.
- Edit the