Re: Transactional DataBases

On Wed August 14 2002 5:14 pm, William Lovaton wrote: > 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, if different users use the same application it opens a connection for each user, normally. -- Martin Tsachev Web developer http://martin.f2o.org