> 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
> 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
-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
-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
>>
-
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
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
> 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
>
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
> 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
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
. 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.
Yes! And also, close out any other connections that may be embedded, like a
prepared statement, result set or stored procedure. These will also show that a
connection is still opened if not explicitly closed!
-Original Message-
From: allen.ir...@smartintegration.com.au
[mailto:allen.ir
-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();
>
> The evidence suggests otherwise
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:
> 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=&
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
:
-
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
> 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 so we can see the rest of the element.
the configuration you describe only defines parameters to be passed to the
Connection Pool Library..which connection pool library are you using?
are you using Thread starve algorithm? or explicit no-activity-on-connection
algorithm?
Most connection pools with close the connection only after stat
19 matches
Mail list logo
