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 |
Can we use servlets in JavaScript?
How to work with Chinese login page (internationalization).if he enters user name and password in chinese, how is it converted to English and validate in db? And in reverse it should display welcome message in Chinese,if user is valid
How session tracking can be achieved, if your browser doesn't support cookies (or) if cookies are disabled?
What are the steps that are involved in using the httpservlet class?
What are different ways for authentication of servlet?
why we should override only no-agrs init() method.
What are the exceptions thrown by Servlets?
Is it good idea to create servlet constructor?
What are the servlet events?
How to set a cookie that is persisted only for the duration fo the clients session?
Explain the methods of request dispatcher in servlet?
Can a servlet be called by passing its name as a parameter in the URL?