This page last changed on Dec 12, 2005 by david.soul@atlassian.com.
Old Documentation

This documentation refers to Confluence 1.3. Users of Confluence 1.4 or later should ignore this documentation.

You are evaluating Confluence

We suggest that first-time evaluators of Confluence use the default installation, which installs an embedded database within Confluence itself. This allows you to see what Confluence can do for you as quickly as possible, without the unnecessary complexity of installing an external database.

Once you have determined that Confluence's features are for you, then it's time to set up against whichever database you plan to deploy against in production.

You Are Installing Confluence with Oracle for the First Time

A fresh installation of Confluence will work quite happily against an Oracle 8 or 9i database provided you keep the following in mind:

  • Regardless of what version of the Oracle database you are using, you must use the Oracle 10g JDBC drivers.
  • You must use the thin drivers.
  • You must connect to Oracle through a datasource configured in your application server. Confluence will not connect directly to an Oracle database.
  • You must set the following connection parameter in your datasource configuration: SetBigStringTryClob=true

Consult the documentation for your application server on how to configure a datasource, and set datasource properties. If you have any problems, ask on the Confluence forum, or http://support.atlassian.com

SetBigStringTryClob is a connection parameter, not a datasource parameter. Your application server may handle these two things differently. An example of how to configure a connection parameter in Tomcat is provided below.

Setting SetBigStringTryClob=true in a Tomcat Datasource

If you are using Tomcat (or the Confluence standalone, which is packaged with Tomcat) you will need to add the following to your datasource definition in order for it to recognise the new connection parameter:

<parameter>
    <name>connectionProperties</name>
    <value>SetBigStringTryClob=true</value>
 </parameter>

You Are Upgrading an Existing Confluence Instance

The same restrictions noted in the new installation apply to you also. Note that previous versions of Confluence only required the Oracle 9i JDBC drivers, so you will need to upgrade to the 10g JDBC drivers for Confluence 1.3.

Why No Oracle 10g Installation Option?

It may seem strange that we require the Oracle 10g drivers, but do not offer Oracle 10g as an option in the setup screens. This is simply because we have not yet tested Confluence against Oracle 10g. This will also be resolved by the time we release Confluence 1.3.2

Document generated by Confluence on Dec 20, 2007 18:51