iam using c3p0 connection pooling along with hibernate.
HOw to check whether c3p0 is configured properly with Hibernate and actually working?


----------------------------------------------
Along with hibernate iam using spring
---------------------------------------------
Below is sample configuration file which sets c3p0 properties

<property name="hibernateProperties">

<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.search.directory_provider">org.hibernate.search.store.FSDirectoryProvider</prop>
<prop key="hibernate.search.default.indexBase">D:\home\httpfuse\indexes</prop>
<!-- Deployment path -->
<!-- <prop key="hibernate.search.default.indexBase">/home/temphttpfuse/indexes</prop> -->
<!-- client path /home/temphttpfuse/indexes -->
<!-- <prop key="hibernate.search.default.indexBase">D:\home\httpfuse\indexes</prop> -->

<!-- Connection pooling and autoReconnect Properties -->

<prop key="hibernate.connection.autocommit">true</prop>
<prop key="hibernate.connection.pool_size">10</prop>

<!-- c3p0 -->
<prop key="hibernate.c3p0.acquire_increment">1</prop>
<prop key="hibernate.c3p0.idle_test_period">60</prop>
<prop key="hibernate.c3p0.timeout">120</prop>
<prop key="hibernate.c3p0.max_size">60</prop>
<prop key="hibernate.c3p0.min_size">10</prop>


<!-- Connection auto reconnect after long inactivity -->
<prop key="connection.autoReconnect">true</prop>
<prop key="connection.autoReconnectForPools">true</prop>
<prop key="connection.is-connection-validation-required">true</prop>

</props>
</property>