Problems using Tomcat 7 connection pool to PostgreSQL with Axis2

"Gemoets, Darren" <[email protected]>
Newsgroups gmane.text.xml.axis.user
Message-ID <F0A90F284CBA814586E6FF5D0BD861C21DAD70FA@SN2PRD0710MB383.namprd07.prod.outlook.com>
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.