Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC what are different transaction levels
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Nagendran
what are different transaction levels
1 Answer(s)      2 years and 8 months ago
Posted in : JDBC


what are different transaction levels


Advertisement
View Answers

May 9, 2012 at 4:59 PM


Transaction levels are:

1) TRANSACTIONNONE: IF you dont set the transaction isolation or if you set it to TRANSACTIONNONE, the transaction executes according to the default isolation level of the underluing odbc driver.

2) TRANSACTIONREADUNCOMMITTED: A transaction reading the uncommitted data of a data source. A dirty read is possible, meaning that no shared locks are issued and no exclusive locks are honored.

3) TRANSACTIONREADCOMMITTED: A transaction reading the committed data of a data source. Shared locks are held while the data is being read to avoid dirty reads.

4) TRANSACTIONREPEATABLEREAD: Locks are placed on all data that is used in a query, preventing other users from updating the data.

5) TRANSACTION_SERIALIZABLE: A range lock is placed on the dataset Until the transaction is completed, preventing other users from updating or inserting rows into the dataset.



Related Tutorials/Questions & Answers:
HIbernate:What are the ORM levels?
HIbernate:What are the ORM levels?   What are the ORM levels?   The ORM levels are: Pure relational (stored procedure). Light objects mapping (JDBC). Medium object mapping. Full object Mapping
What is Isolation Levels?
What is Isolation Levels?  What is Isolation Levels?   Hi, Here is the answer, In database systems, isolation is a property that defines..., Durability) properties. There are four isolation levels: READ UNCOMMITTED READ
Advertisements
What the four ORM levels are in hibernate?
What the four ORM levels are in hibernate?  Hi, What the four ORM levels are in hibernate? Thanks
What is a transaction and what are ACID properties?
What is a transaction and what are ACID properties?  What is a transaction and what are ACID properties
what is Set Transaction?
what is Set Transaction?  what is Set Transaction?   Hi, The SET TRANSACTION statement to establish the current transaction as read only... rollback segment. The operations performed by a SET TRANSACTION statement affect only
Transaction
the transaction so I need to use the TransactionProxyFactoryBean. My question is that can I use the advice as well as the spring provided transaction in the same person bean as a AOP. I don't want to write the code for transaction, just want
What are the different types of AutoProxying?
What are the different types of AutoProxying?  Hi, What are the different types of AutoProxying? Thanks
What are different normalization forms?
What are different normalization forms?  What are different normalization forms?   Hi, 1NF: Eliminate Repeating Groups- Make a separate table for each set of related attributes, and give each table a primary key. Each
What are the different modules in Spring framework?
What are the different modules in Spring framework?  Hi, What are the different modules in Spring framework? Thanks
What are different environments to configure hibernate?
What are different environments to configure hibernate?  Hi, What are different environments to configure hibernate? Thanks
What are the different functions in sorting an array?
What are the different functions in sorting an array?  What are the different functions in sorting an array
WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?
WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?  WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP
with a different number, what’s the problem
with a different number, what?s the problem  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
with a different number, what’s the problem
with a different number, what?s the problem  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
the standard isolation levels defined by JDBC
the standard isolation levels defined by JDBC  What are the standard isolation levels defined by JDBC
What are the different types of property and class mappings?
What are the different types of property and class mappings?  Hi, What are the different types of property and class mappings? thanks
what are different M.I.S reporting tools basically used?
what are different M.I.S reporting tools basically used?  what are different M.I.S reporting tools basically used
what are different M.I.S reporting tools basically used?
what are different M.I.S reporting tools basically used?  write a java pgm using keyword super,static nd final
What is a join and explain different types of joins
What is a join and explain different types of joins  What is a join and explain different types of joins?   Hi, Joins are used in queries to explain how different tables are related. Joins also let you select data from
What are constructors ? explain different types of constructor with example
What are constructors ? explain different types of constructor with example  Hi, What are constructors ? explain different types of constructor... To know more related to What are constructors with examples
the isolation levels supported by my DBMS
the isolation levels supported by my DBMS  How can I determine the isolation levels supported by my DBMS
Transaction Management
Transaction Management  How are transactions managed in EJB
keeps coming up with a different number, what’s the problem.
keeps coming up with a different number, what?s the problem.  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
keeps coming up with a different number, what’s the problem
keeps coming up with a different number, what?s the problem  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
Java transaction
Java transaction  How do you handle your own transaction
Comparing Log Levels in Java
objects of the Level class with different logging levels. One... Comparing Log Levels in Java       This section describes, how to compare log levels to each other
Implement transaction serializability
Implement transaction serializability  I need to implement transaction serializability in Java using semaphores/monnitors. What is the code to do
What are the different types of interfaces in java? - Java Interview Questions
What are the different types of interfaces in java?  Hi, Is it correct question.I faced this in one interview. If yes can u tell me please. thanks chandu
Distributed transaction in java
the different types of transaction management and their associated components...-small; text-decoration: underline; } Distributed Transaction in java EE In distributed java enterprise application, transaction is processed
Transaction in last 3 months
Transaction in last 3 months  I have a project in which i have to calculate amount submitted through transactions in last three months. I have... submitted. What query can i use to get all the transactions in past 3 months starting
Hibernate 4.0-nested transaction not suported
Hibernate 4.0-nested transaction not suported  how i do nested transaction using Hibernate 4, i know hibernate 4 does not support nested transaction. Is there any way to do nested transaction like inserting more than one record
Advertisements
 

 

 

DMCA.com