Re: Commits and Sequences for same user logged in

A copy of this was sent to Bill Mann <bill.mann_at_worldtalk.com> (if that email address didn't require changing) On Mon, 21 Jun 1999 00:11:04 -0700, you wrote:

>Since I’m building an application for the web, I will be logging-into
>the database with the same Oracle username. I have not got very far
>with this, but I assume I will keep a list of available database
>handles, and when web traffic is busy I will select from this list to
>database handle to web requests (I'm using DBI and DBD)
>
>Since the same user is logged into Oracle, what are the issues wrt to
>1. Database commits, if commit occurs for a particular web transaction,
>since the same user is logged in, will the commit occur for everyone

only the current session will commit. commit doesn't commit all work for every session using a given username -- it only commits the work for the session it was called from.

>2. Can I rely on the value of currval (for sequences)
>

yes, same as above. sequences (currval and nextval) are specific to a session.

>Thanks,
>Bill.
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jun 21 1999 - 07:01:36 CDT