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.