Re: Oracle and Record Locking

--0-1804289383-964813341=:8850
Content-Type: text/plain; charset=us-ascii

 I'm not so sure I'd want my result set changing on me. What happens if I've entered a value for several columns of a row, and someone else commits changes for the same data. Does it overwrite what I just changed? If so I wouldn't want it.

  Seth Dunehew <sdunehew_at_medicalmatrix.com> wrote:

We have a consultant at our shop who is convinced that Oracle is inadequate for a serious multi-user environment because of the lack of record locking and dynamic result sets. We have been using it to develop and deploy a OLTP system and haven't found any serious problems that could not be addressed.

The dynamic result set that he has mentioned has me a little puzzled. He is stating that relational databases that he has worked with in the past returned a result set to him for use in his apps that would change dynamically if another user changed one of the records that he was displaying. I'm a relative newcomer to the database arena, 2 years, but this is something new. I've been told by another developer that Access will do this, but he hadn't heard of any serious systems that do.

Has anyone else heard of databases that perform that function?

Any suggestions on resources related to record locking in Oracle? We have two other developers that have worked with it extensively in the past, but the consultant is convinced that he knows differently, so we do need some solid research to refute him.

Thanks

Seth Dunehew

-- 
Author: Seth Dunehew
INET: sdunehew_at_medicalmatrix.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).


---------------------------------
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
--0-1804289383-964813341=:8850
Content-Type: text/html; charset=us-ascii

<P> I'm not so sure I'd want my result set changing on me. What happens if I've entered a value for several columns of a row, and someone else commits changes for the same data. Does it overwrite what I just changed? If so I wouldn't want it.<BR>
<P>&nbsp; <B><I>Seth Dunehew &lt;sdunehew_at_medicalmatrix.com&gt;</I></B> wrote: <BR>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><BR>We have a consultant at our shop who is convinced that Oracle is inadequate<BR>for a serious multi-user environment because of the lack of record locking<BR>and dynamic result sets. We have been using it to develop and deploy a OLTP<BR>system and haven't found any serious problems that could not be addressed.<BR><BR>The dynamic result set that he has mentioned has me a little puzzled. He is<BR>stating that relational databases that he has worked with in the past<BR>returned a result set to him for use in his apps that would change<BR>dynamically if another user changed one of the records that he was<BR>displaying. I'm a relative newcomer to the database arena, 2 years, but<BR>this is something new. I've been told by another developer that Access will<BR>do this, but he hadn't heard of any serious systems that do. <BR><BR>Has anyone else heard of databases that perform that function? <BR!


><BR>Any suggestions on resources related to record locking in Oracle? We have<BR>two other developers that have worked with it extensively in the past, but<BR>the consultant is convinced that he knows differently, so we do need some<BR>solid research to refute him.<BR><BR>Thanks<BR><BR>Seth Dunehew<BR>-- <BR>Author: Seth Dunehew<BR>INET: sdunehew_at_medicalmatrix.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>

Kick off your party with Yahoo! Invites.