Hey,
I am having the same problem and tried the same solution to no effect. I've upgraded to the newest stable release of MM.Mysql and that did not help. I am fairly confident that it is a connection timing out, but the autoReconnect has not helped at all. I put the autoreconnect in a <set-property property="autoReconnect" value="true"/> After awhile, I get a communications link failure... -----Original Message----- From: janof [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 8:05 AM To: struts-user Cc: Stephen.Chambers; nuil Subject: Re: App will hang if it runs over night Billy, Edwin, Steve or anybody else: Where do I put this parameter (autoReconnect) in struts-config.xml ? Can you give me an example ? It doesn't seem to work for me. Thanks. Jano Billy Ng wrote: > Thanks! > > Billy Ng > >> From: "E.M. van Nuil" <[EMAIL PROTECTED]> >> Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >> To: Struts Users Mailing List <[EMAIL PROTECTED]> >> Subject: Re: App will hang if it runs over night >> Date: Wed, 07 Aug 2002 15:48:27 +0200 >> >> Thanks, >> >> This seems to be the solution to my problem. I just looked at the site of >> the mm.mysql driver and the author writes : >> "MySQL closes connections after idle times. Your connection pool needs to >> "refresh" connections, or (with a performance penalty), you can add >> "autoReconnect=true" to your JDBC URL. This is covered in the >> documentation >> with the latest driver versions." >> >> Is there a way to refresh connections in the connection pool of struts ?? >> I'll just use the autoReconnect for now. >> >> Edwin >> >> [EMAIL PROTECTED] wrote: >> >> > >> > I had this before. You need to set autoReconnect=true within your >> > connection url for the mysql driver. Do a google to do a search on the >> > exact syntax or you can look on the mysql site. >> > >> > Steve >> > >> > >> > >> > >> > "E.M. van >> > Nuil" To: Struts Users >> Mailing List >> > <[EMAIL PROTECTED]> >> > <nuil@oblivion cc: >> > .nl> Subject: Re: App will >> hang if >> > it runs over night >> > >> > 08/07/2002 >> > 08:13 AM >> > Please respond >> > to "Struts >> > Users Mailing >> > List" >> > >> > >> > >> > >> > >> > >> > This looks like the same problem I'm having. I posted this a few >> days ago, >> > but still no response. I mailed Craig my trace dumps and he is >> looking at >> > the problem. But I hadn't thought the problem was with the MySQL driver >> > but >> > >> > with my beans. >> > Can you give some more info ? >> > >> > Edwin >> > >> > Billy Ng wrote: >> > >> >> My app will be unable to access the mysql database if I leave it on >> over >> >> night. I cannot even shut Struts down when this happens. Did anybody >> >> experience this before? >> >> >> >> Thanks! >> >> >> >> Billy Ng >> > >> > >> > -- >> > To unsubscribe, e-mail: < >> > mailto:[EMAIL PROTECTED]> >> > For additional commands, e-mail: < >> > mailto:[EMAIL PROTECTED]> >> > >> > >> > >> > >> > >> > >> > -- >> > To unsubscribe, e-mail: >> > <mailto:[EMAIL PROTECTED]> For additional >> > commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >> >> -- >> To unsubscribe, e-mail: >> <mailto:[EMAIL PROTECTED]> >> For additional commands, e-mail: >> <mailto:[EMAIL PROTECTED]> > > > > > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
