[dbcp] connection autocommit property

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[dbcp] connection autocommit property

Melih Utkan UNSAL
Hi,

i am trying to find the behaviour of dbcp about autocommit property.

i am getting the connection from pool and then setting autocommit property false .


after doing a few transactions,i commit or rollback the transaction and then i close the connection so it goes back to the pool.

everthing is ok up to now.

if i get that connection one more time after theese operations, then what is the autocommit property? False or True ?

i expect to be false because i set it false and sent to pool.

what do you think?


     
Reply | Threaded
Open this post in threaded view
|

RE: [dbcp] connection autocommit property

wesclark

We do the same thing, and, yes, the pool doesn't change the state of
autocommit.  It is easy to check when you borrow the connection back
from the pool.

-----Original Message-----
From: Melih Utkan UNSAL [mailto:[hidden email]]
Sent: Wednesday, April 15, 2009 7:52 AM
To: [hidden email]
Subject: [dbcp] connection autocommit property

Hi,

i am trying to find the behaviour of dbcp about autocommit property.

i am getting the connection from pool and then setting autocommit
property false .


after doing a few transactions,i commit or rollback the transaction and
then i close the connection so it goes back to the pool.

everthing is ok up to now.

if i get that connection one more time after theese operations, then
what is the autocommit property? False or True ?

i expect to be false because i set it false and sent to pool.

what do you think?


     

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: [dbcp] connection autocommit property

Phil Steitz
In reply to this post by Melih Utkan UNSAL
Melih Utkan UNSAL wrote:

> Hi,
>
> i am trying to find the behaviour of dbcp about autocommit property.
>
> i am getting the connection from pool and then setting autocommit property false .
>
>
> after doing a few transactions,i commit or rollback the transaction and then i close the connection so it goes back to the pool.
>
> everthing is ok up to now.
>
> if i get that connection one more time after theese operations, then what is the autocommit property? False or True ?
>
> i expect to be false because i set it false and sent to pool.
>  
The answer depends on the defaultAutoCommit property setting.   The
default value of this property is true, so unless you have set it to
false in your configuration,  you should get connections with autoCommit
= true when borrowing from the pool.  

Phil
> what do you think?
>
>
>      
>  


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]