I put it with the other options, but it still isn't working. So I'm still looking for a solution.
Edwin > -----Oorspronkelijk bericht----- > Van: Jan Fetyko [mailto:[EMAIL PROTECTED]] > Verzonden: vrijdag 9 augustus 2002 14:05 > Aan: Struts Users Mailing List > CC: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Onderwerp: 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]>