Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Subject: RE: mysql connection pool
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Date: Mon, 28 Jul 2003 16:13:01 +0200
content-class: urn:content-classes:message
Message-ID: <C19D2E05B25FA94E943431666541E5B71C8D44@server01.hh.uptime.de>
Thread-Topic: mysql connection pool
Thread-Index: AcNVER7abJY8794aR7+jh3dv1mgTcQAADQqw
From: "Ralph Einfeldt" <ralph.einfeldt@uptime-isc.de>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>

That doesn't happen under java.

You have to explicitly free/close all resources
that are more valuable than memory (file handles,=20
db connections, ...)

The finalizer is called by the garbage collector,
which in turn can run any time or not even at all
(if you don't consume enough memory).

>From the JavaDoc:

finalize():
Called by the garbage collector on an object when=20
garbage collection determines that there are no=20
more references to the object.

> -----Original Message-----
> From: Hans Wichman [mailto:hans@trimm.nl]
> Sent: Monday, July 28, 2003 4:03 PM
> To: tomcat-user@jakarta.apache.org
> Subject: mysql connection pool
>=20
>=20
> Hi,
> does anyone know why I have to close the connection retrieved=20
> from a mysql  database connection pool ?
> Isn't the connection returned to the pool automatically when=20
> the object goes out of scope?
>=20
> And why is the datasource.getNumActive() value always 0 even=20
> though I have=20
> multiple connections open ?
>=20

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org