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’s the difference between sendredirect and forward methods
What are the phases of the servlet life cycle?
What is webservlet?
Why doesn’t a servlet include main()?
Why do we have servlet filters?
Explain servlet events?
Can we use threads in Servlets?
What’s the use of the servlet wrapper classes??
What is called Session Tracking?
What are the difference between RMI and Servlets?
Are Servlets Thread Safe? How to achieve thread safety in servlets?
How to get the server information in a servlet?
What is the requirement of servlet config and servlet context implemented and how are they implemented?
Define declaration.
What is the difference between context parameter and context attribute?