what is meant by Transaction Isolation Levels?

Answers were Sorted based on User's Feedback



what is meant by Transaction Isolation Levels?..

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

what is meant by Transaction Isolation Levels?..

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

Post New Answer

More Servlets Interview Questions

How does Cookies work in Servlets?

0 Answers  


What do you mean by cgi?

0 Answers  


What is the protocol used by Server & Client?

2 Answers  


What is connection pooling?

4 Answers   Wipro,


How do I use cookies to store session state on the client?

0 Answers  






describe all about advanced java with presentation

4 Answers   Sun Microsystems,


Describe in brief RequestDespatcher?

0 Answers   Tech Mahindra,


Explain the concept of ssi ?

0 Answers  


What's the difference between authentication and authorization?

0 Answers  


What is generic servlet class?

0 Answers  


What are common tasks performed by Servlet Container?

0 Answers  


In jsp custom tags from child tags to how many levels of parent tags you can acess

1 Answers   Bosch,


Categories