what is meant by Transaction Isolation Levels?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / arghya
To avoid potential conflicts that can arise when two transaction are operating on a database at the same time, we use some transaction isolation level using conn.setTransactionIsolation().
| Is This Answer Correct ? | 0 Yes | 1 No |
Which httpsession object is used to view and manipulate information about a session?
How do I know if java is running on linux?
What happens, if server sends a cookie to a browser that doesn't supports cookies?
When should you prefer to use doget() over dopost()?
What is the difference between an applet and a servlet?
15 Answers GCEW, Miracle Solutions,
What are the functions of an intercepting filter?
How can we create deadlock situation in servlet?
If some new data has entered the database, explain how can a servlet refresh automatically?
how can you give alias to servlets?
Is it possible to have a constructor inside the servlet?
The code in a finally clause will never fail to execute, right?
What is servlet in tomcat?