DBCP / Tomcat / MSSQL, connections staying active

  • Thread starter Michael Scovetta
  • Start date
M

Michael Scovetta

Hi all,
I have a connection pool going to MSSQL, running under Tomcat. Very
slowly, my connection pool fills up. Can anyone think of any reasons
why this would happen? I've checked through my code a few times, and I
can't find any places where I forget to .close() the ResultSet,
[Prepared]Statement, and Connection objects, and there are no
exceptions anywhere.
Any ideas? Sometimes a connection stays idle, and it automatically
closes those, but the active ones-- I wind up closing ALL connections
after my connection pool is over 80% full, but it's ugly and sometimes
someone will still be using a connection when it gets tossed out on
him.

Thanks a bunch!

Oh, I'm using Tomcat 4.1.24, MSSQL JDBC drivers, and the DBCP that
comes with 4.1.24.

Thanks!
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,020
Latest member
GenesisGai

Latest Threads

Top