If any query failed inside a transaction then PDO will not issue a
rollback, It will left the decision on you that you want to ignore the
failed query it or want a rollback.
You can find the examples of handing of query failure inside a transaction
You can trust on transaction handling built-in function of PDO, it is
well implemented inside PDO_INFORMIX.
----- Forwarded by Daniel Krook/White Plains/IBM on 01/14/2014 10:33 AM
From: Neomi TR <ne...@isoc.org.il>
Date: 01/14/2014 10:30 AM
Subject: [PHP-DB] Transactions with PDO_INFORMIX
Sent by: Neomi TR <ne...@post.isoc.org.il>
I use the PDO functions PDO::beginTransaction, PDO::commit and
begin, commit and rollback transactions.
I also check that we are in active or no active transaction with
Lately we have encountered few failures when using transactions.
Queries have failed and there was no rollback, although the failed
queries were part of transaction.
Even after one of the queries has failed, there was no rollback although
it was declared, and part of the queries in the transaction were executed.
My question is - can I trust the build-in functions of the PDO?
Does this problem is known?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php