Dear all,

Please help me

i am using connection.datasource through jndi in hibernate.cfg file to connect database , it works fine .

i lost connection after 8 hours if my application idle, so i used c3p0 in hibernate.cfg. c3p0 is working well if didnt use JNDI datasource . but i want to use JNDI and c3p0 in hibernate.cfg file



MY configuration file

<hibernate-configuration>

<session-factory>

<!--<property name="connection.driver_class">-->
<!-- org.gjt.mm.mysql.Driver-->
<!-- </property>-->
<!-- <property name="connection.url">jdbc:mysql://localhost:3306/dbname</property>-->
<!---->
<!---->
<!-- <property name="connection.username">root</property>-->
<!-- <property name="connection.password">root</property>-->
<!-- -->



<property name="connection.datasource">java:jndiname</property>


<property name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="connection.datasource">java:pic</property>
<property name="c3p0.min_size">5</property>
<property name="c3p0.max_size">20</property>
<property name="c3p0.timeout">1800</property>
<property name="c3p0.max_statements">50</property>



<mapping resource="persistantDB/ApplicationConfig.hbm.xml" />
<mapping resource="persistantDB/CheckInStatus.hbm.xml" />
<mapping resource="persistantDB/CheckInBackup.hbm.xml" />
<mapping resource="persistantDB/DeviceTable.hbm.xml" />

</session-factory>

</hibernate-configuration>