Confluence 4.0 : How to Convert a datasource to a direct JDBC connection in oracle
This page last changed on Jun 11, 2011 by pkamal.
1) Shutdown confluence <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 |