commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Trenton D. Adams (JIRA)" <>
Subject [jira] Commented: (DBCP-286) MAJOR, MAJOR, MAJOR dbcp does not rollback
Date Mon, 30 Mar 2009 16:54:50 GMT


Trenton D. Adams commented on DBCP-286:

We turn autocommit off usually.  In this case, it is turned off, which is why I noticed this.
 I was trying to retrieve a record that had just been inserted, but it wasn't showing up.
 So, a co-worker mentioned that I might be in a transaction, which would prevent me from seeing
the latest records.  So, I knew that there was no way that "I" was in the middle of a transaction.
 So, I decided to do a rollback just after getting the connection, and it then worked.  Then
i tried 1.2.1, to see if it worked, without my own rollback, and it did.


-rw-r--r-- 1 trenta trenta  559366 Jul 17  2008 commons-collections-3.1.jar
-rw-r--r-- 1 trenta trenta  121757 Mar 27 15:43 commons-dbcp-1.2.2.jar
-rw-r--r-- 1 trenta trenta   42492 Jul 17  2008 commons-pool-1.2.jar

Java 1.4.2-03, which I assume is JDBC2

> I assume that what you are seeing is when a connection is returned with readonly=false,
automcommit=false, no rollback is 
> happening in 1.2.2. Correct?

Yes, that is what I am seeing.

> MAJOR, MAJOR, MAJOR dbcp does not rollback
> ------------------------------------------
>                 Key: DBCP-286
>                 URL:
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.2.2
>         Environment: maven, gentoo linux, any java version
>            Reporter: Trenton D. Adams
>            Priority: Blocker
>   Original Estimate: 1h
>  Remaining Estimate: 1h
> DBCP 1.2.2 does not do connection rollbacks.  Or, at least the one in maven 2 repositories
does not.  I switched back to 1.2.1, and it works great.
> I asked about this back in 2005, and it was stated that it did.  And, it does, up until

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message