Re: Transactional DataBases

El mar, 13-08-2002 a las 18:20, Martin Tsachev escribió: > 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. ok. I didn't mean different applications sharing the same connection. I mean different users using the same application that uses only one connection to the DataBase. William. _________________________________________________________ Do You Yahoo!? La emoción e intensidad del deporte en Yahoo! Deportes. http://deportes.yahoo.com.mx