Re: Transactional DataBases

On Tue August 13 2002 5:28 pm, William Lovaton wrote: > Hi Martin, thank you very much for your answer! Hi WIlliam, > 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? How exactly do other applications share the same connection, I don't get it? There should be a connection for every user and the RDBMS should guarantee that users don't step on each other. > feel free to flame me. > > TIA, > > William. -- Martin Tsachev Web developer http://martin.f2o.org