users@glassfish.java.net

JDBC connection leak. Weird issue.

From: <glassfish_at_javadesktop.org>
Date: Mon, 29 Sep 2008 11:59:02 PDT

I'm writing a simple web service that calls 2 stored procedures. The web service is connecting to MSSQL 2000 with JTDS drivers.

Using soap UI simple model with 4 threads. The connections are leaking and are NOT being reclaimed further more I get allot of the following SQL Exceptions:

- Output parameters have not yet been processed. Call getMoreResults()
- Connection closed
- Invalid state, the CallableStatement object is closed.

My pool is setup to 5 - 10 connections.

Any ideas?

Thanks
[Message sent by forum member 'infectedrhythms' (infectedrhythms)]

http://forums.java.net/jive/thread.jspa?messageID=302407