Reddy: Thank you for your reply. I like your second idea better and unless I hear objections from the list, shall go with that solution, which I certainly like better than my original one..:)
Thank you again, Geeta > -----Original Message----- > From: Pingili, Madhupal [mailto:[EMAIL PROTECTED] > Sent: Monday, July 26, 2004 10:53 AM > To: 'Struts Users Mailing List' > Subject: RE: Connecting to a database during > sessionDestroyed(HttpSessionevent) in HttpSessionlistener class > > > > Two ideas that come to mind quickly are: > > 1. Adjust the pool size to a reasonable limit, keeping in > mind that NOT only > actual users who come to the application need a connection > from pool, but > also > these background processes like listeners need a > connection from the same > pool. > > 2. Keep a loop while getting connection from the pool until you get a > non-null connection. > > Then, you will always use a pooled connection. > > Suggestions/Corrections are welcome. > > HTH, > Reddy Pingili > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
