hi,
I am using c3p0 for my connection pooling.My doubt is how to configure c3p0 for sending a test query for every connection every n seconds

My configuration of c3p0 done so far is

<property name="c3p0.acquire_increment">5</property>
<property name="c3p0.idle_test_period">5</property> <!-- seconds -->
<property name="c3p0.max_size">200</property>
<property name="c3p0.max_statements">100</property>
<property name="c3p0.min_size">10</property>
<property name="c3p0.timeout">94</property>
<property name="hibernate.transaction.auto_close_session">true</property>

c3p0.testConnectionOnCheckout=true
c3p0.maxConnectionAge=94
c3p0.automaticTestTable=tester

AkshayAjmani,

You already have it with hibernate.c3p0.idle_test_period [or c3p0.idleConnectionTestPeriod]. I think you application is not seeing the configuration that you are setting -- maybe c3p0.properties is misnamed, or there's some other issue. Please post c3p0's version banner and configuration dump [logged at INFO on initialization] to verify that c3p0 is seeing the settings you think you are providing.

smiles,
Steve