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 at http://www.php.net/manual/en/pdo.transactions.php You can trust on transaction handling built-in function of PDO, it is well implemented inside PDO_INFORMIX. Thanks, Rahul Priyadarshi ----- Forwarded by Daniel Krook/White Plains/IBM on 01/14/2014 10:33 AM ----- From: Neomi TR <neomi@xxxxxxxxxxx> To: php-db@xxxxxxxxxxxxx Date: 01/14/2014 10:30 AM Subject: Transactions with PDO_INFORMIX Sent by: Neomi TR <neomi@xxxxxxxxxxxxxxxx> Hi, I use the PDO functions PDO::beginTransaction, PDO::commit and PDO::rollBack to begin, commit and rollback transactions. I also check that we are in active or no active transaction with 'PDO::inTransaction'. System info: PHP 5.3.28 INFORMIX 11.70 PDO_INFORMIX-1.3.0 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? Thank you, Neomi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
