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.
Rahul Priyadarshi

----- Forwarded by Daniel Krook/White Plains/IBM on 01/14/2014 10:33 AM 

From:   Neomi TR <ne...@isoc.org.il>
To:     php-db@lists.php.net
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
PDO::rollBack to
begin, commit and rollback transactions.
I also check that we are in active or no active transaction with

System info:
PHP 5.3.28

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,

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to