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