Tune OpenMRS connection Pool

[githengi]

OpenMRS on Reveal was experiencing deadlocks on the mysql database.

openmrs.log

The default configuration for hibernate.c3p0.idle_test_period was greater than hibernate.c3p0.timeout. This means a connection can become stale and is killed, but hibernate is not able to detect.

On the reveal openmrs the configs were changed to

# Hibernate specific connection pool properties    
hibernate.c3p0.min_size=5
hibernate.c3p0.timeout=150
hibernate.c3p0.idle_test_period=120

Previously it was

# Hibernate specific connection pool properties    
hibernate.c3p0.min_size=0
hibernate.c3p0.timeout=100
hibernate.c3p0.idle_test_period=3000