ok great, but why does the lookup for a datasource always return a new pool instance ?
I am running tomcat 4.0.1, maybe that is the problem?


hope you can help
Hans

At 04:13 PM 7/28/2003 +0200, Ralph Einfeldt wrote:
That doesn't happen under java.

You have to explicitly free/close all resources
that are more valuable than memory (file handles,
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
garbage collection determines that there are no
more references to the object.

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

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to