This page last changed on Jun 11, 2011 by pkamal.

1) Shutdown confluence
2) Edit CONFLUENCE_HOME/confluence.cfg.xml file
3) Delete

    <property name="hibernate.connection.datasource">java:comp/env/jdbc/confluence</property>
    <property name="hibernate.dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
    <property name="hibernate.setup">true</property>

and replace with

    <property name="hibernate.c3p0.acquire_increment">1</property>
    <property name="hibernate.c3p0.idle_test_period">100</property>
    <property name="hibernate.c3p0.max_size">250</property>
    <property name="hibernate.c3p0.max_statements">0</property>
    <property name="hibernate.c3p0.min_size">5</property>
    <property name="hibernate.c3p0.numHelperThreads">9</property>
    <property name="hibernate.c3p0.timeout">30</property>
    <property name="hibernate.connection.SetBigStringTryClob">true</property>
    <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
    <property name="hibernate.connection.password">PASSWORD</property>
    <property name="hibernate.connection.url">jdbc:oracle:thin:@HOST:1522:DATABASENAME</property>
    <property name="hibernate.connection.username">USERNAME</property>
    <property name="hibernate.database.lower_non_ascii_supported">true</property>
    <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>

filling out the details for your db

4) restart confluence

Document generated by Confluence on Sep 19, 2011 02:51