hi, this didnt solved, i created a file c3po.properties with the mentioned property and it didnt solved. also i have to wait a day for the error message, is there a way where i can reduce this time during test?
thanks abhi On Sat, Feb 26, 2011 at 12:32 AM, Burton Rhodes <burtonrho...@gmail.com>wrote: > I recall having a similiar issue when moving to MySQL from MSSQL. I > solved it by adding c3po.properties file to the classpath with the > text below. It kept the connection alive with the database. > > # This property corresponds to the query run defined by the > "hibernate.c3p0.idle_test_period" value > c3p0.preferredTestQuery = SELECT 1; > > On Fri, Feb 25, 2011 at 12:53 AM, Jerson John <jer...@cprvision.com> > wrote: > > Hi, > > > > Yup I faced this problem before and flush to Hibernate group.They have > > suggested me some solution based on my mapping xml fle....Why don't u > send > > me that mapping xml and let me compare with mine.....Actually Even though > it > > look like Server error,its more to do with hibernate ....Please feel free > to > > currect me if my assumption is wrong > > > > Many Thanks and Regards, > > > > Jerson > > > > > > -----Original Message----- > > From: abhishek jain [mailto:abhishek.netj...@gmail.com] > > Sent: Friday, February 25, 2011 2:31 PM > > To: Struts Users Mailing List > > Subject: Exception in hibernate3 > > > > hi, > > I am not sure if i am ringing the correct list, but i am sure people here > > must have encountered this problem. I am new to hibernate and when i ran > the > > code on server it was fine , strangely next day it keep on giving this > error > > till i restart tomcat. > > > > The last packet successfully received from the server was 54,880,316 > > milliseconds ago. The last packet sent successfully to the server was > > 54,880,317 milliseconds ago. is longer than the server configured value > of > > 'wait_timeout'. You should consider either expiring and/or testing > > connection validity before use in your application, increasing the server > > configured values for client timeouts, or using the Connector/J > connection > > property 'autoReconnect=true' to avoid this problem. > > > > I have searched a lot on net and added the following properties on > > hibernate.cfg.xml, as people there were suggesting this,but of no use. > > <!-- Sessions and transactions --> > > <!-- Use the C3P0 connection pool provider --> > > <property name="hibernate.c3p0.min_size">5</property> > > <property name="hibernate.c3p0.max_size">20</property> > > <property name="hibernate.c3p0.timeout">300</property> > > <property name="hibernate.c3p0.max_statements">50</property> > > <property name="hibernate.c3p0.idle_test_period">3000</property> > > <property name="current_session_context_class">thread</property> > > > > > > > > Pl. help me. > > I have used hibernate3 with myeclipse as the development environment, and > am > > using mysql 5.x and centos (Linux) with Tomcat 5.x > > -- >