Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are the supporting protocol by HttpServlet ?

1112


What methodology can be followed to store more number of objects in a remote server?

2208


Why is Servlet so popular?

1007


What is api in servlet?

964


What are the phases of the servlet life cycle?

1053


Explain the war file?

1015


Where do you define dispatcherservlet?

988


What are the life cycle methods of the servlet?

1037


what is the different between a servlet and a cgi? Why do you go for servlet rather than cgi?

989


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

964


What’s the difference between forward() and sendredirect() methods?

957


What is session?

998


How do we call one servlet from another servlet?

981


The code in a finally clause will never fail to execute, right?

1004


What are the steps that are required to handle the multi-threading?

1045