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’s the difference between sendredirect and forward methods

1064


What are the phases of the servlet life cycle?

1134


What is webservlet?

997


Why doesn’t a servlet include main()?

1054


Why do we have servlet filters?

1028


Explain servlet events?

1016


Can we use threads in Servlets?

1144


What’s the use of the servlet wrapper classes??

1107


What is called Session Tracking?

1192


What are the difference between RMI and Servlets?

1567


Are Servlets Thread Safe? How to achieve thread safety in servlets?

972


How to get the server information in a servlet?

1173


What is the requirement of servlet config and servlet context implemented and how are they implemented?

1006


Define declaration.

1080


What is the difference between context parameter and context attribute?

1050