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

we cant Override Jsp Service method?Why?

4 Answers   Infrasoft, Mind Tree,


What are cookies and how will you use them?

3 Answers  


Hello, My project requirement is like I need to create a web page using MVC pattern. I hava a bean class, jsp page, servlet, service and dao. My jsp has two fields. One is dropdown list. The option values has to get populated from the database table. The other one is a text box and its value has to come from database table. As of now I have defined the fields in bean class, got the values from database using arraylists in dao class and I called this from service class. Can anyone please tell me the workflow of how the servlet will get this arraylist and populate the arraylist values as dropdown options in jsp page? Also I would like to know the role of bean class in MVC pattern? Thanks in advance!

0 Answers  


Can we fetch the attributes related to a servlet on a different servlet?

0 Answers  


What are the objects involved when a servlet receives a call from client?

0 Answers  






What is meant by cookies?

0 Answers  


In the servlets, we are having a web page that is invoking servlets ,username and password? which is checks in database? Suppose the second page also if we want to verify

0 Answers  


Explain the war file?

0 Answers  


How do you invoke a servelt?

0 Answers  


What is session tracking?

0 Answers  


hi actully i hav form columns with origin and destination names .as like as i need to create one more column with name amount. my requirement is when i select origin and destination columns automatically i need to get amount from database.how can i. please tel me with relative code

0 Answers   CTS,


Write the code to get the server information in servlet.

0 Answers  


Categories