Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How does Oracle support REPEATABLE READ
Our developers use Enterprise JavaBeans.
Choosen isolation level is REPEATABLE READ.
Does Oracle give this isolation level (or better)
as described below ?
(Text is taken from a standard JavaBeans book).
Thanks,
Ben Brugman
Environment :
Borland Enterprise Server.
Oracle JDBC driver.
From: Mastering Enterprise JavaBeans.
"When to Use REPEATABLE READ
Use REPEATABLE READ when you need to update one or more data elements
in a resource, such as one or more records in a relational database.
You want to read each of the rows that you're modifying and then be
able to update each row, knowing that none of the rows are being
modified by other concurrent transactions. If you choose to reread any
of the rows at any time later in the transaction, you'd be guaranteed
that the rows still have the same data that they did at the beginning
of the transaction."
JDBC drivers should support the REPEATABLE READ isolation level. When using the Oracle JDBC driver will it support the REPEATABLE READ isolation level with the functionality as stated above? Especially the part : "knowing that none of the rows are being modified by other concurrent transactions" ?
Side question: On which ORACLE isolation level is the JDBC REPATABLE READ isolation level mapped ?
Ben Brugman Received on Thu Apr 25 2002 - 08:27:12 CDT