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

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 fine standalone, but when I use
> it via an Axis2 web service, it seems to be causing abandoned
> connections.  After a few connections, it can't connect because there
> are no connections available because they're all abandoned.
>
>  
>
> I haven't done anything fancy with the service, the WSDL, the
> transport, or anything...in poking around I see some things that maybe
> look related like REUSE_HTTP_CLIENT and I also ran across this entry
> from StackOverflow
> <http://stackoverflow.com/questions/1093888/how-can-i-test-if-my-connection-pool-is-working-in-a-correct-way>
> (http://stackoverflow.com/questions/1093888/how-can-i-test-if-my-connection-pool-is-working-in-a-correct-way)
> that could be relevant, though not for the novice Axis2 user.
>
>  
>
> Any thoughts?  Any more info needed?
>
>  
>
> Thank you.
>
This might give you some light.

http://www.developer.com/db/article.php/3735771/Exposing-a-Database-as-a-Web-Service.htm

Deepal