Re: Transactions with PDO_INFORMIX

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux