Re: Transactional DataBases
| From: | William Lovaton | Date: | Tue, 13 Aug 2002 14:28:00 +0000 |
| Subject: | Re: Transactional DataBases | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-2104@lists.php.net to get a copy of this message | ||
El lun, 12-08-2002 a las 19:19, Martin Tsachev escribió:
> On Tue August 13 2002 3:09 am, William Lovaton wrote:
> > Hi,
>
> Hi Willim,
>
> > I would like to know if there is a way to get advantages from
> > Transactional DataBases in PEAR (like Oracle).
>
> Yes, check the autoCommit, commit and rollback methods.
>
Hi Martin, thank you very much for your answer!
I was wondering if autoCommit would work on the connection or on the
transaction... OCICommit() and OCIRollback() functions works on the
connection to the DB, so if an specific application user fails on a
transaction, OCIRollback() will make a roll back over the whole
connection, restoring every INSERT, UPDATE or DELETE made by other
application user that are sharing the same connection to the DB.
Am I right? or wrong?
feel free to flame me.
TIA,
William.
_________________________________________________________
Do You Yahoo!?
La emoción e intensidad del deporte en Yahoo! Deportes. http://deportes.yahoo.com.mx