By 'new pool instance' do you mean that:
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/TestDB");
System.out.println("ds instance : " + ds);
The result of System.out.println is always a different value ? In this
case, it's not a new instance of the pool, it's the new variable that
refers to a single instance of the pool. Just double checking.
> -----Original Message-----
> From: Hans Wichman [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 9:27 AM
> To: Tomcat Users List; Tomcat Users List
> Subject: RE: mysql connection pool
>
>
> 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
