Mombu the Programming Forum

Go Back   Mombu the Programming Forum > Programming > DBCP / Tomcat / MSSQL, connections staying active
User Name
Password
REGISTER NOW! Mark Forums Read




Reply Bookmark and Share
1 7th March 18:10
nospam_googlegroups
External User
 
Posts: 1
Default DBCP / Tomcat / MSSQL, connections staying active



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
  Reply With Quote


 


Reply


Thread Tools
Display Modes


Some other forums that might be of your interest : Development, Ada, Apple script, Assembler, Awk, Beos, Basic, C, C++, C#, C# .net, .net, .net frameworks, Asp .net, Clarion, Clipper, Clos, Clu, Cobol, Coldfusion, Delphi, Dylan, Eiffel, Forth, Fortran, Haskell, Hermes, Icon, Idl, Java, Java script, Jscript .net, Jcl, Linoleum, Lisp, Lotus, Limbo, Logo, Ml, Mumps, Oberon, Postscript, Pop, Pl1, Prolog, Python, Ruby, Pascal, Perl, Php, Rebol, Rexx, Sed, Sather, Scheme, Smalltalk, Tcl, Vhdl, Vrml, Visual basic, Visual basic .net, Yorick, Mysql, Omnis, Postgresql, Xbase, Access, Oracle, Adabas, Berkeley, Btrieve, Filemaker, Gupta, Db2, Informix, Ingres, Mssql server, Object, Olap, Paradox, Rdb, Revelation, Sybase, Theory, Dbase, Html, Java script, Css, Flash, Photoshop, Corel script, Xml, Tech, Beos, Gem, Hp48, Hpux, Linux, Mac, Ms-dos, Os2, Palm, Solaris, Ti99, Windows, Xenix, Aos, Chorus, Geos, Inferno, Lantastic, Lynx, Mach, Minix, Netware, Os9, Parix, Plan9, Psos, Qnx, Xinu, Sco, Unix, Aix, Aux, 386bsd, Bsdi, Freebsd, Netbsd, Openbsd, Ultrix, Amd, Intel, Aptiva, Buz, Deals, Homebuilt, Overclocking, Programming, Extra forums


Copyright © 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666