There's also a pingQuery attribute in the datasource where you can test you're connection. for example :
pingQuery="SELECT * FROM DUAL" arno > -----Message d'origine----- > De: cahana [SMTP:[EMAIL PROTECTED]] > Date: jeudi 31 janvier 2002 07:32 > À: Struts Users Mailing List > Objet: Re: Connection Pooling > > Have you tried Poolman to do your connection pooling? It provides a way to > specify a validation query which periodically checks to see if the database > is still accessible. If it doesn't, it'll keep trying to connect to the > database until it comes back up. The url is www.codestudio.com > > ----- Original Message ----- > From: "Andrew Myers" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 30, 2002 7:57 PM > Subject: Connection Pooling > > > > Hi, > > > > I'm using Struts connection pooling in my Struts application. If the > database goes offline temporarily the only way I know of to re-establish the > pool is to stop and start the application server (in this case WebSphere > 3.5.5 which is quite a tedious process!). > > > > Is there a smarter way to recover from this situation or is this the only > option available? > > > > Thanks, > > Andrew. > > -- > > > > > > > > > > __________________________________________________________________ > > Your favorite stores, helpful shopping tools and great gift ideas. > Experience the convenience of buying online with Shop@Netscape! > http://shopnow.netscape.com/ > > > > Get your own FREE, personal Netscape Mail account today at > http://webmail.netscape.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]>