I just implemented poolman on a struts application. It took me about 20 minutes to integrate it into an existing app and it really worked well. It does caching which was something I was looking for.
-----Original Message----- From: janof [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 8:50 AM To: struts-user Subject: Re: App will hang if it runs over night :(( Same here. I guess I'll have to build my own connection pooling or use something I find on the net. Also I was wondering if PostgreSQL is having the same problem, any idea ? Maybe it's worth changing Db platforms. Jano [EMAIL PROTECTED] wrote: > 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]> > > -- 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]>