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
Explain the working of service() method of a servlet.
What is httpservlet and how it is different from genericservlet?
What do you mean by cgi in servlet?
How the JSP file will be executed on the Server side?
Explain Action Servlet?
What is URL Encoding?
Differentiate between the print writer and servlet output stream?
What do you mean by scope object and what are its types?
Why servlet is used as controller ? Not JSP? I want complete explation?
Why are http servlets used in programming?
Why is http protocol called as a stateless protocol?
Explain the difference between generic servlet and http servlet?
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
What is the use of servlet wrapper classes?
When servlet object is created?