using Tomcat 7 connection pool to PostgreSQL with Axis2
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
On Fri, Sep 21, 2012 at 7:33 PM, Deepal jayasinghe 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
Hi Darren
did you configure your transports to use KeepAlive
HTTP/1.1
?
In the meanwhile take a look at DBCP examples for impelementing database
pooling characteristics
http://svn.apache.org/viewvc/commons/proper/dbcp/trunk/doc/
http://commons.apache.org/dbcp/
Martin
___
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
arren [mailto:darren.gemo...@aquilent.com]
Sent: Friday, September 21, 2012 15:04
To: java-user@axis.apache.org
Subject: RE: Problems using Tomcat 7 connection pool to PostgreSQL with Axis2
Interesting...I had run across ServiceLifeCycle somewhere along the way and
wondered if that should be part
@gmail.com]
Sent: Friday, September 21, 2012 14:52
To: java-user@axis.apache.org
Subject: Re: Problems using Tomcat 7 connection pool to PostgreSQL with Axis2
> This might give you some light.
>
> http://www.developer.com/db/article.php/3735771/Exposing-a-Database-as
> -a-Web-Service.htm
&
> This might give you some light.
>
> http://www.developer.com/db/article.php/3735771/Exposing-a-Database-as-a-Web-Service.htm
>
> Deepal
Darren said that he is using a connection pool, not the DriverManager
API. In that case, you manage connections differently than the pattern
shown in your artic
On 9/21/2012 2:27 PM, Gemoets, Darren wrote:
>
> Hello, all. I have a simple test program that opens a JDBC connection
> to a PostgreSQL database (using the Tomcat connection pool) and runs a
> simple query. It uses connection/result closing code from the
> documentation. The test program works
On Fri, Sep 21, 2012 at 3:27 PM, Gemoets, Darren
wrote:
> Hello, all. I have a simple test program that opens a JDBC connection to a
> PostgreSQL database (using the Tomcat connection pool) and runs a simple
> query. It uses connection/result closing code from the documentation. The
> test prog
