I have a Java Web application which stops to give response to the production environment after some interval of time in which I have used Spring framework and hibernate, the below properties file in my project but after the deployment of project in tomcat the application runs fine for 2 to 4 days in the production but it stops giving response for the request generated by the users and me have to reload the application from tomcat and it works fine for 1 to 2 days and these tasks are done, again and again, kindly give me some suggestion that how can I resolve these issues. I have not faced these issues when I was using JDBC because the application which is developed using JDBC is running fine from last 2 yrs. Hibernate Properties hibernate.show_sql=false hibernate.hbm2ddl.auto=update hibernate.c3p0.min_size=5 hibernate.c3p0.max_size=100 hibernate.c3p0.timeout=3000 hibernate.c3p0.max_statements=50 hibernate.c3p0.idle_test_period=30000 hibernate.c3p0.acquire_increment=10 <beans:bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"> <beans:property name="dataSource" ref="dataSource" /> <beans:property name="hibernateProperties"> <beans:props> <beans:prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect </beans:prop> <beans:prop key="hibernate.show_sql">$ {hibernate.show_sql} </beans:prop> <beans:prop key="hibernate.hbm2ddl.auto">$ {hibernate.hbm2ddl.auto} </beans:prop> <beans:prop key="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</beans:prop> <beans:prop key="hibernate.c3p0.idle_test_period">$ {hibernate.c3p0.idle_test_period} </beans:prop> <beans:prop key="hibernate.c3p0.acquire_increment">$ {hibernate.c3p0.acquire_increment} </beans:prop> <beans:prop key="hibernate.c3p0.min_size">$ {hibernate.c3p0.min_size} </beans:prop> <beans:prop key="hibernate.c3p0.max_size">$ {hibernate.c3p0.max_size} </beans:prop> <beans:prop key="hibernate.c3p0.max_statements">$ {hibernate.c3p0.max_statements} </beans:prop> <beans:prop key="hibernate.c3p0.timeout">$ {hibernate.c3p0.timeout} </beans:prop> </beans:props> </beans:property> </beans:bean> |