Confluence 6 to enable validation queries directly from your JDBC connection

Determine confluence in the database connection pool Lieutenant-database connection:

2. Stop confluence.

4. Edit the file.

5. For your specific database, insert the following property configuration information.
   

   For Postgresql,sql Server, and MySQL

   <property name="hibernate.c3p0.validate">true</property><property name="hibernate.c3p0.preferredTestQuery">select 1</property>

   For Oracle

   <property name="hibernate.c3p0.validate">true</property><property name="hibernate.c3p0.preferredTestQuery">select 1from dual</property>

7. Saveconfluence.cfg.xml

9. If you use Confluence 5.10.3 or an earlier version, you need to add the following to your system property to verify your database.
   For example:

   -Dc3p0.preferredTestQuery="select 1"

11. Restart confluence.

You should be able to regain all database connections from the disconnected database connection without restarting the confluence.

Https://www.cwiki.us/display/CONFLUENCEWIKI/Surviving+Database+Connection+Closures




Confluence 6 to enable validation queries directly from your JDBC connection