Re: Problems using Tomcat 7 connection pool to PostgreSQL with Axis2

On Fri, Sep 21, 2012 at 7:33 PM, Deepal jayasinghe <[email protected]> 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.