RE: Connection Pooling questions

2009-04-01 Thread Caldarale, Charles R
> From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Subject: Re: Connection Pooling questions > > Actually, I can't think of a reason why you'd have to use the unwrapped > version of the statement or result set (or even connection) to perform > state ma

RE: Connection Pooling questions

2009-04-01 Thread Caldarale, Charles R
> From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Subject: Re: Connection Pooling questions > > I think the JDBC spec should strengthen your faith at least > in the correctness of this behavior... I wasn't questioning the correctness of the intended beh

Re: Connection Pooling questions

2009-04-01 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David, On 4/1/2009 11:25 AM, David Smith wrote: > This is assuming the developer didn't unwrap any of the DBCP objects to > access driver specific features. In that case, the original wrapped > objects need to be maintained and closed instead of the u

Re: Connection Pooling questions

2009-04-01 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chuck, On 4/1/2009 10:47 AM, Caldarale, Charles R wrote: >> From: Shaun Farrugia [mailto:sfarru...@fry.com] >> Subject: RE: Connection Pooling questions >> >> What happens when the statement isn't closed but the >>

RE: Connection Pooling questions

2009-04-01 Thread Shaun Farrugia
- From: Shaun Farrugia [mailto:sfarru...@fry.com] Sent: Wednesday, April 01, 2009 11:00 AM To: Tomcat Users List Subject: RE: Connection Pooling questions Sweet, I set up a test.jsp page that will Connection.close() without rs.close() and ps.close(). Will let you know the results.. And

Re: Connection Pooling questions

2009-04-01 Thread David Smith
Caldarale, Charles R wrote: >> From: Shaun Farrugia [mailto:sfarru...@fry.com] >> Subject: RE: Connection Pooling questions >> >> What happens when the statement isn't closed but the >> connection is returned to the pool? >> > > The connection

RE: Connection Pooling questions

2009-04-01 Thread Caldarale, Charles R
> From: Shaun Farrugia [mailto:sfarru...@fry.com] > Subject: RE: Connection Pooling questions > > Are there any changes to DBCP other than package moves? No, just the package renaming to avoid collisions. > Can I utilize the DBCP source package and expect that it's >

RE: Connection Pooling questions

2009-04-01 Thread Shaun Farrugia
Connection Pooling questions > From: Shaun Farrugia [mailto:sfarru...@fry.com] > Subject: RE: Connection Pooling questions > > What happens when the statement isn't closed but the > connection is returned to the pool? The connection object your code sees isn't the real connect

RE: Connection Pooling questions

2009-04-01 Thread Caldarale, Charles R
> From: Shaun Farrugia [mailto:sfarru...@fry.com] > Subject: RE: Connection Pooling questions > > What happens when the statement isn't closed but the > connection is returned to the pool? The connection object your code sees isn't the real connection; it's a w

RE: Connection Pooling questions

2009-04-01 Thread Propes, Barry L
oblem. Thanks again! Original Message: - From: Caldarale, Charles R chuck.caldar...@unisys.com Date: Tue, 31 Mar 2009 22:44:32 -0500 To: users@tomcat.apache.org Subject: RE: Connection Pooling questions > From: allen.ir...@smartintegration.com.au > [mailto:allen.ir...@smartintegra

RE: Connection Pooling questions

2009-04-01 Thread Shaun Farrugia
. Thanks again! Original Message: - From: Caldarale, Charles R chuck.caldar...@unisys.com Date: Tue, 31 Mar 2009 22:44:32 -0500 To: users@tomcat.apache.org Subject: RE: Connection Pooling questions > From: allen.ir...@smartintegration.com.au > [mailto:allen.ir...@smartintegration.

RE: Connection Pooling questions

2009-04-01 Thread Propes, Barry L
[mailto:allen.ir...@smartintegration.com.au] Sent: Tuesday, March 31, 2009 8:43 PM To: users@tomcat.apache.org Subject: Connection Pooling questions Do I have to turn on some kind of cleanup explicitly? I do close the connections within my program using conn.close(); as the howto suggests. I thought that

Re: Connection Pooling questions

2009-04-01 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chuck, On 3/31/2009 10:57 PM, Caldarale, Charles R wrote: >> From: allen.ir...@smartintegration.com.au >> Subject: Connection Pooling questions >> >> I do close the connections within my program using conn.close(); &g

RE: Connection Pooling questions

2009-03-31 Thread allen.ir...@smartintegration.com.au
ssage: - From: Caldarale, Charles R chuck.caldar...@unisys.com Date: Tue, 31 Mar 2009 22:44:32 -0500 To: users@tomcat.apache.org Subject: RE: Connection Pooling questions > From: allen.ir...@smartintegration.com.au > [mailto:allen.ir...@smartintegration.com.au] > Subject:

RE: Connection Pooling questions

2009-03-31 Thread Caldarale, Charles R
> From: allen.ir...@smartintegration.com.au > [mailto:allen.ir...@smartintegration.com.au] > Subject: RE: Connection Pooling questions > >type="javax.sql.DataSource" > driverClassName="com.attunity.jdbc.NvDriver" > url=&

RE: Connection Pooling questions

2009-03-31 Thread allen.ir...@smartintegration.com.au
ssage: - From: Caldarale, Charles R chuck.caldar...@unisys.com Date: Tue, 31 Mar 2009 21:57:01 -0500 To: users@tomcat.apache.org Subject: RE: Connection Pooling questions > From: allen.ir...@smartintegration.com.au > [mailto:allen.ir...@smartintegration.com.au] > Subject: Conne

RE: Connection Pooling questions

2009-03-31 Thread allen.ir...@smartintegration.com.au
: - From: Martin Gainty mgai...@hotmail.com Date: Tue, 31 Mar 2009 22:33:36 -0400 To: users@tomcat.apache.org Subject: RE: Connection Pooling questions the configuration you describe only defines parameters to be passed to the Connection Pool Library..which connection pool library are you

RE: Connection Pooling questions

2009-03-31 Thread Caldarale, Charles R
> From: allen.ir...@smartintegration.com.au > [mailto:allen.ir...@smartintegration.com.au] > Subject: Connection Pooling questions > > I configure it using the suggested /META-INF/context.xml with: > maxActive="30" maxIdle="10" Post your entire context.xml

RE: Connection Pooling questions

2009-03-31 Thread Martin Gainty
rom: allen.ir...@smartintegration.com.au > To: users@tomcat.apache.org > Date: Tue, 31 Mar 2009 21:42:52 -0400 > Subject: Connection Pooling questions > > Hello, > > I searched on the mailing list back to 2007 and didn't see the answers I > needed for these DataSource

Connection Pooling questions

2009-03-31 Thread allen.ir...@smartintegration.com.au
Hello, I searched on the mailing list back to 2007 and didn't see the answers I needed for these DataSource related questions (though I did see similar, not quite what I needed though). I'm using Tomcat 5.5, Java 1.5 on Windows XP and have used the excellent guide: http://tomcat.apache.org/tomcat