what is meant by Transaction Isolation Levels?

Answer Posted / shraddha

Connection.setTransactionIsolation (level)

TRANSACTION_READ_UNCOMMITTED Allows dirty reads, non-
repeatable reads, and phantom reads to occur.

TRANSACTION_READ_COMMITTED Ensures only committed data
can be read.

TRANSACTION_REPEATABLE_READ Is close to
being "serializable," however, "phantom" reads are possible.

TRANSACTION_SERIALIZABLE Dirty reads, non-repeatable
reads, and phantom reads are prevented. Serializable.


A "phantom" read occurs when one transaction reads all rows
that satisfy a WHERE condition, and a second transaction
inserts a row that satisfies that WHERE condition, the
first transaction then rereads for the same condition,
retrieving the additional "phantom" row in the second read.

In addition, JDBC defines an additional constant,
TRANSACTION_NONE, which is used to indicate that the driver
does not support transactions.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the working of service() method of a servlet.

502


What is httpservlet and how it is different from genericservlet?

604


What do you mean by cgi in servlet?

627


How the JSP file will be executed on the Server side?

642


Explain Action Servlet?

621






What is URL Encoding?

617


Differentiate between the print writer and servlet output stream?

561


What do you mean by scope object and what are its types?

566


Why servlet is used as controller ? Not JSP? I want complete explation?

650


Why are http servlets used in programming?

546


Why is http protocol called as a stateless protocol?

535


Explain the difference between generic servlet and http servlet?

539


How to get ip address in jsp login page and how to validate like 127.1.0.1 all should not be greater than 255

2914


What is the use of servlet wrapper classes?

667


When servlet object is created?

600