|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #63215 Add support for Firebird commit retaining transactions.
Submitted: 2012-10-04 00:01 UTC Modified: 2018-07-06 19:06 UTC
Avg. Score:4.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: james at kenjim dot com Assigned:
Status: Duplicate Package: PDO Firebird
PHP Version: 5.4Git-2012-10-03 (Git) OS: All
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: james at kenjim dot com
New email:
PHP Version: OS:


 [2012-10-04 00:01 UTC] james at kenjim dot com
Add the ability to do commit retaining transactions using the Firebird PDO driver.  Commit retaining is faster when committing because it reuses server transaction resources.  The downside is you are still in the old transaction context so you won't see any new concurrent commits.  Commit retaining is ideally used when you have lots of small transactions that do not rely on other data that may be changed by another thread/user.

I have written a patch to add the ability to do commit retaining transactions using 
$dbh->setAttribute(PDO::FB_ATTR_COMMIT_RETAINING, true);
Any following commits or rollbacks will use their retaining equivalent after this attribute is set.  You can return to using normal commit and rollbacks by setting the attribute to false.
$dbh->setAttribute(PDO::FB_ATTR_COMMIT_RETAINING, false);


CommitRetaining (last revision 2012-10-04 00:02 UTC by james at kenjim dot com)

Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2012-11-23 13:21 UTC]
-Assigned To: +Assigned To: mariuz
 [2012-12-05 07:22 UTC] james at kenjim dot com
I have uploaded a new improved patch with Bug #63690 that includes the functionality here.  I suggest using that patch instead of the one I uploaded here as that is a more complete solution and fixes some unexpected behavior if someone uses commit retaining.
 [2016-08-29 14:29 UTC]
-Package: PDO related +Package: PDO Firebird
 [2017-10-24 06:45 UTC]
-Status: Assigned +Status: Open -Assigned To: mariuz +Assigned To:
 [2018-07-06 19:06 UTC]
-Status: Open +Status: Duplicate
 [2018-07-06 19:06 UTC]
According to the @james comment, this ticket is now superseded.

PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Feb 27 20:01:30 2024 UTC