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
What are the supporting protocol by HttpServlet ?
What methodology can be followed to store more number of objects in a remote server?
Why is Servlet so popular?
What is api in servlet?
What are the phases of the servlet life cycle?
Explain the war file?
Where do you define dispatcherservlet?
What are the life cycle methods of the servlet?
what is the different between a servlet and a cgi? Why do you go for servlet rather than cgi?
What are the objects involved when a servlet receives a call from client?
What’s the difference between forward() and sendredirect() methods?
What is session?
How do we call one servlet from another servlet?
The code in a finally clause will never fail to execute, right?
What are the steps that are required to handle the multi-threading?