Thanks, it works for me now too, although it's the syntax that I wouldn't expect, since I thought that this is the right way :
<set-property property="autoReconnect" value="true"/> Jf Billy Ng wrote: > The problem is totally gone after I added the autoReconnect parameter > in the mysql's url. Here is the example > > <data-sources> > <data-source autoCommit="false" > description="Example Data" > driverClass="org.gjt.mm.mysql.Driver" > maxCount="4" > minCount="2" > user="ie" > password="foobar" > url="jdbc:mysql://localhost:3306/ieDB?autoReconnect=true"/> > </data-sources> > > > Billy Ng > >> From: [EMAIL PROTECTED] >> Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >> To: [EMAIL PROTECTED] >> Subject: RE: App will hang if it runs over night >> Date: Fri, 9 Aug 2002 09:28:29 -0400 >> >> >> 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]> > > > > > > _________________________________________________________________ > 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]>
