Re: Exception in hibernate3
Hello, No, the query isnt running. What do i need to do for this, Also i have to wait for 8 hours to see if mysql has timeout with my code in hibernate , cannt i reduce some values in hibernate.cfg.xml and test. Can some one post the relevant sections of hte config file, pl advice, i am now approaching application release date, thanks abhi On Wed, Mar 9, 2011 at 2:30 AM, Burton Rhodes wrote: > There are a number of ways to do this, either by java (log4j for > exmaple) or directly via your database. If you are using MySQL > perhaps you do it this way > > http://www.howtogeek.com/howto/database/monitor-all-sql-queries-in-mysql/ > > > On Mon, Mar 7, 2011 at 12:34 AM, abhishek jain > wrote: > > No, i havent setup logs, but apparently it is not running else there > would > > have been no exception message. > > Hey, can you guide me to the correct setup, i have asked this on > hibernate > > forumns but apparently they are slow in replying , no response yet, > > > > Pl. help > > thanks > > abhishek > > > > > > On Sun, Mar 6, 2011 at 3:55 AM, Burton Rhodes > > wrote: > >> > >> Have u set up you logs to verify that your 'select 1' query is > >> actually being run? > >> > >> On Saturday, March 5, 2011, Dave Newton wrote: > >> > If this question is related to hibernate it'd be more efficient and > >> > appropriate to ask on a hibernate-related list probably. > >> > > >> > Dave > >> > On Mar 5, 2011 3:32 AM, "abhishek jain" > >> > wrote: > >> >> hi, > >> >> thanks for the mail, > >> >> i tried this but the problem still persists, i added the context.xml > >> >> file > >> > in > >> >> META-INF and the database information was not being picked from > there. > >> >> Also i added the connect-timeout parameter in my.cnf file in the > mysqld > >> >> section, but still the the timeout was after 8 hours of inactivity. > >> >> > >> >> I will appreciate if one can tell me exactly what to do, pl consider > me > >> >> a > >> >> newbie and will appreciate if the instructions be given. > >> >> > >> >> thanks > >> >> abhishek > >> >> > >> >> On Tue, Mar 1, 2011 at 3:26 PM, Maurizio Cucchiara < > >> >> maurizio.cucchi...@gmail.com> wrote: > >> >> > >> >>> I struggled with this issue for a long period, at the end I reached > a > >> >>> good point: I started using database connection pools [1]. > >> >>> Actually you should wait until the mysql connection dies (it should > be > >> >>> after 8 hours of db inactivity ), but you could change the > >> >>> connect-timeout=seconds [2] in order to achieve the before mentioned > >> >>> scenario. > >> >>> > >> >>> [1] http://commons.apache.org/dbcp/ > >> >>> [2] http://dev.mysql.com/doc/refman/5.5/en/mysql-options.html > >> >>> > >> >>> > >> >>> Here my context.xml is: > >> >>> > >> >>> >> >>> override="true" > >> >>> reloadable="false" > >> >>> unpackWARs="true" autoDeploy="true" > >> >>> liveDeploy="false" allowLinking="true"> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> >> To unsubscribe, e-mail: user-unsubscr...@struts.apache.org > >> For additional commands, e-mail: user-h...@struts.apache.org > > > > >
Re: Exception in hibernate3
No, i havent setup logs, but apparently it is not running else there would have been no exception message. Hey, can you guide me to the correct setup, i have asked this on hibernate forumns but apparently they are slow in replying , no response yet, Pl. help thanks abhishek On Sun, Mar 6, 2011 at 3:55 AM, Burton Rhodes wrote: > Have u set up you logs to verify that your 'select 1' query is > actually being run? > > On Saturday, March 5, 2011, Dave Newton wrote: > > If this question is related to hibernate it'd be more efficient and > > appropriate to ask on a hibernate-related list probably. > > > > Dave > > On Mar 5, 2011 3:32 AM, "abhishek jain" > wrote: > >> hi, > >> thanks for the mail, > >> i tried this but the problem still persists, i added the context.xml > file > > in > >> META-INF and the database information was not being picked from there. > >> Also i added the connect-timeout parameter in my.cnf file in the mysqld > >> section, but still the the timeout was after 8 hours of inactivity. > >> > >> I will appreciate if one can tell me exactly what to do, pl consider me > a > >> newbie and will appreciate if the instructions be given. > >> > >> thanks > >> abhishek > >> > >> On Tue, Mar 1, 2011 at 3:26 PM, Maurizio Cucchiara < > >> maurizio.cucchi...@gmail.com> wrote: > >> > >>> I struggled with this issue for a long period, at the end I reached a > >>> good point: I started using database connection pools [1]. > >>> Actually you should wait until the mysql connection dies (it should be > >>> after 8 hours of db inactivity ), but you could change the > >>> connect-timeout=seconds [2] in order to achieve the before mentioned > >>> scenario. > >>> > >>> [1] http://commons.apache.org/dbcp/ > >>> [2] http://dev.mysql.com/doc/refman/5.5/en/mysql-options.html > >>> > >>> > >>> Here my context.xml is: > >>> > >>> >>> override="true" > >>> reloadable="false" > >>> unpackWARs="true" autoDeploy="true" > >>> liveDeploy="false" allowLinking="true"> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> To unsubscribe, e-mail: user-unsubscr...@struts.apache.org > For additional commands, e-mail: user-h...@struts.apache.org >
Re: Exception in hibernate3
Have u set up you logs to verify that your 'select 1' query is actually being run? On Saturday, March 5, 2011, Dave Newton wrote: > If this question is related to hibernate it'd be more efficient and > appropriate to ask on a hibernate-related list probably. > > Dave > On Mar 5, 2011 3:32 AM, "abhishek jain" wrote: >> hi, >> thanks for the mail, >> i tried this but the problem still persists, i added the context.xml file > in >> META-INF and the database information was not being picked from there. >> Also i added the connect-timeout parameter in my.cnf file in the mysqld >> section, but still the the timeout was after 8 hours of inactivity. >> >> I will appreciate if one can tell me exactly what to do, pl consider me a >> newbie and will appreciate if the instructions be given. >> >> thanks >> abhishek >> >> On Tue, Mar 1, 2011 at 3:26 PM, Maurizio Cucchiara < >> maurizio.cucchi...@gmail.com> wrote: >> >>> I struggled with this issue for a long period, at the end I reached a >>> good point: I started using database connection pools [1]. >>> Actually you should wait until the mysql connection dies (it should be >>> after 8 hours of db inactivity ), but you could change the >>> connect-timeout=seconds [2] in order to achieve the before mentioned >>> scenario. >>> >>> [1] http://commons.apache.org/dbcp/ >>> [2] http://dev.mysql.com/doc/refman/5.5/en/mysql-options.html >>> >>> >>> Here my context.xml is: >>> >>> >> override="true" >>> reloadable="false" >>> unpackWARs="true" autoDeploy="true" >>> liveDeploy="false" allowLinking="true"> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>>
Re: Exception in hibernate3
If this question is related to hibernate it'd be more efficient and
appropriate to ask on a hibernate-related list probably.
Dave
On Mar 5, 2011 3:32 AM, "abhishek jain" wrote:
> hi,
> thanks for the mail,
> i tried this but the problem still persists, i added the context.xml file
in
> META-INF and the database information was not being picked from there.
> Also i added the connect-timeout parameter in my.cnf file in the mysqld
> section, but still the the timeout was after 8 hours of inactivity.
>
> I will appreciate if one can tell me exactly what to do, pl consider me a
> newbie and will appreciate if the instructions be given.
>
> thanks
> abhishek
>
> On Tue, Mar 1, 2011 at 3:26 PM, Maurizio Cucchiara <
> maurizio.cucchi...@gmail.com> wrote:
>
>> I struggled with this issue for a long period, at the end I reached a
>> good point: I started using database connection pools [1].
>> Actually you should wait until the mysql connection dies (it should be
>> after 8 hours of db inactivity ), but you could change the
>> connect-timeout=seconds [2] in order to achieve the before mentioned
>> scenario.
>>
>> [1] http://commons.apache.org/dbcp/
>> [2] http://dev.mysql.com/doc/refman/5.5/en/mysql-options.html
>>
>>
>> Here my context.xml is:
>>
>> > override="true"
>> reloadable="false"
>> unpackWARs="true" autoDeploy="true"
>> liveDeploy="false" allowLinking="true">
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> > type="javax.sql.DataSource"
>> name="jdbc/${CONTEXT_NAME}"
>> password="PASSWORD"
>> driverClassName="org.gjt.mm.mysql.Driver"
>> username="${USERNAME}"
>>
>>
url="jdbc:mysql://localhost/${DB_NAME}?zeroDateTimeBehavior=convertToNull"
>> auth="Container"
>> factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
>> maxActive="20"
>> maxIdle="5"
>> validationQuery="select 1"
>> testOnBorrow="true"
>> testWhileIdle="true"
>> timeBetweenEvictionRunsMillis="1"
>> minEvictableIdleTimeMillis="6"
>> maxWait="5000"
>> removeAbandoned="true"
>> removeAbandonedTimeout="60"
>> logAbandoned="true"
>> />
>>
>>
>>
>> On 1 March 2011 07:09, abhishek jain wrote:
>> > 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 > >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
>> >> wrote:
>> >> > Hi,
>> >> >
>> >> > Yup I faced this problem before and flush to Hibernate group.They
>> have
>> >> > suggested me some solution based on my mapping xml fleWhy 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.
>> >> >
>> >> >
>> >> > 5
>> >> > 20
>> >> > 300
>> >> > 50
>> >> > 3000
>> >> > thread
>> >> >
>> >> >
>> >> >
>> >> > 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
>> >> > --
>> >>
>> >
>>
>>
>>
>> --
Re: Exception in hibernate3
hi,
thanks for the mail,
i tried this but the problem still persists, i added the context.xml file in
META-INF and the database information was not being picked from there.
Also i added the connect-timeout parameter in my.cnf file in the mysqld
section, but still the the timeout was after 8 hours of inactivity.
I will appreciate if one can tell me exactly what to do, pl consider me a
newbie and will appreciate if the instructions be given.
thanks
abhishek
On Tue, Mar 1, 2011 at 3:26 PM, Maurizio Cucchiara <
maurizio.cucchi...@gmail.com> wrote:
> I struggled with this issue for a long period, at the end I reached a
> good point: I started using database connection pools [1].
> Actually you should wait until the mysql connection dies (it should be
> after 8 hours of db inactivity ), but you could change the
> connect-timeout=seconds [2] in order to achieve the before mentioned
> scenario.
>
> [1] http://commons.apache.org/dbcp/
> [2] http://dev.mysql.com/doc/refman/5.5/en/mysql-options.html
>
>
> Here my context.xml is:
>
> override="true"
>reloadable="false"
>unpackWARs="true" autoDeploy="true"
>liveDeploy="false" allowLinking="true">
>
>
>
>
>
>
>
>
>
>
>
>
>type="javax.sql.DataSource"
>name="jdbc/${CONTEXT_NAME}"
>password="PASSWORD"
>driverClassName="org.gjt.mm.mysql.Driver"
>username="${USERNAME}"
>
> url="jdbc:mysql://localhost/${DB_NAME}?zeroDateTimeBehavior=convertToNull"
>auth="Container"
>factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
>maxActive="20"
>maxIdle="5"
>validationQuery="select 1"
>testOnBorrow="true"
>testWhileIdle="true"
>timeBetweenEvictionRunsMillis="1"
>minEvictableIdleTimeMillis="6"
>maxWait="5000"
>removeAbandoned="true"
>removeAbandonedTimeout="60"
>logAbandoned="true"
>/>
>
>
>
> On 1 March 2011 07:09, abhishek jain wrote:
> > 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 >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
> >> wrote:
> >> > Hi,
> >> >
> >> > Yup I faced this problem before and flush to Hibernate group.They
> have
> >> > suggested me some solution based on my mapping xml fleWhy 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.
> >> >
> >> >
> >> > 5
> >> > 20
> >> > 300
> >> > 50
> >> > 3000
> >> > thread
> >> >
> >> >
> >> >
> >> > 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
> >> > --
> >>
> >
>
>
>
> --
> Maurizio Cucchiara
>
>
Re: Exception in hibernate3
I struggled with this issue for a long period, at the end I reached a good point: I started using database connection pools [1]. Actually you should wait until the mysql connection dies (it should be after 8 hours of db inactivity ), but you could change the connect-timeout=seconds [2] in order to achieve the before mentioned scenario. [1] http://commons.apache.org/dbcp/ [2] http://dev.mysql.com/doc/refman/5.5/en/mysql-options.html Here my context.xml is: On 1 March 2011 07:09, abhishek jain wrote: > 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 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 >> wrote: >> > Hi, >> > >> > Yup I faced this problem before and flush to Hibernate group.They have >> > suggested me some solution based on my mapping xml fleWhy 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. >> > >> > >> > 5 >> > 20 >> > 300 >> > 50 >> > 3000 >> > thread >> > >> > >> > >> > 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 >> > -- >> > -- Maurizio Cucchiara - To unsubscribe, e-mail: user-unsubscr...@struts.apache.org For additional commands, e-mail: user-h...@struts.apache.org
Re: Exception in hibernate3
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 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 > wrote: > > Hi, > > > > Yup I faced this problem before and flush to Hibernate group.They have > > suggested me some solution based on my mapping xml fleWhy 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. > > > > > > 5 > > 20 > > 300 > > 50 > > 3000 > > thread > > > > > > > > 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 > > -- >
Re: Exception in hibernate3
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 wrote: > Hi, > > Yup I faced this problem before and flush to Hibernate group.They have > suggested me some solution based on my mapping xml fleWhy 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. > > > 5 > 20 > 300 > 50 > 3000 > thread > > > > 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 > -- > Thanks and kind Regards, > Abhishek jain > > > > - > To unsubscribe, e-mail: user-unsubscr...@struts.apache.org > For additional commands, e-mail: user-h...@struts.apache.org > > - To unsubscribe, e-mail: user-unsubscr...@struts.apache.org For additional commands, e-mail: user-h...@struts.apache.org
RE: Exception in hibernate3
Hi, Yup I faced this problem before and flush to Hibernate group.They have suggested me some solution based on my mapping xml fleWhy 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. 5 20 300 50 3000 thread 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 -- Thanks and kind Regards, Abhishek jain - To unsubscribe, e-mail: user-unsubscr...@struts.apache.org For additional commands, e-mail: user-h...@struts.apache.org
