On Fri, Sep 21, 2012 at 7:33 PM, Deepal jayasinghe <deep...@gmail.com> wrote: > I guess main issue is not closing the connections (or rather not reusing > them). So any approach that helps you to reuse the connections would > help to resolve the issue. In the article I mentioned an approach, but > there could be many. One thing you need to make sure is depending on the > request scope you might have a large number of services instances so > does the DB connections. >
In practice any pool and db can support around 100 connections on vanilla hardware with auto re-use and commits. Put your close() statement in a finally block and that may be all you need to do. --------------------------------------------------------------------- To unsubscribe, e-mail: java-user-unsubscr...@axis.apache.org For additional commands, e-mail: java-user-h...@axis.apache.org
