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 is the process to implement doget and dopost methods?
What’s the use of the servlet wrapper classes??
What do you mean by cgi in servlet?
How is the get () method different from the post() method?
What is the difference between the getrequestdispatcher(string path) method of javax.servlet.servletrequest interface and javax.servlet.servletcontext interface?
What are the differences between servlet context vs servlet config?
how many jsp scripting elements are there and what are those?
Write a command to get actual path of a servlet to the server?
How the typical servlet code look like ?
Whether thread can be used in servlets?
What are the advantages of Servlet over CGI?
How does java thread pool work?
How forward () method is different from send redirect () method?
What are the features added in Servlet 2.5?
What is the use of request dispatcher interface?