Home Answers Viewqa JDBC what are different transaction levels

 
 


Nagendran
what are different transaction levels
1 Answer(s)      a year ago
Posted in : JDBC

what are different transaction levels

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 Pages:
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
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
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
the standard isolation levels defined by JDBC
the standard isolation levels defined by JDBC  What are the standard isolation levels defined by JDBC
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
Know the Different Types of E-Commerce
Know the Different Types of E-Commerce There are different types of e-commerce and we need to know what e-commerce is and how different it is from e... transaction which takes place between two consumers. There many online sites
What are the different types of AutoProxying?
What are the different types of AutoProxying?  Hi, What are the different types of AutoProxying? Thanks
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
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
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
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
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 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 modules in Spring framework?
What are the different modules in Spring framework?  Hi, What are the different modules in Spring framework? Thanks
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
Use JTA to control transaction demarcation
Use JTA to control transaction...; Use JTA to control transaction demarcation In a bean-managed transaction (BMT), the code in the session
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 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?  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
What is Fashion Jewelry?
What is Fashion Jewelry? What is Fashion Jewelry, as most women can tell you... of fashion jewelry you should also know about the actual price levels. Depending... items, the prices can be very different. For example, for the above mention happy
different kinds of actions in Struts
different kinds of actions in Struts  What are the different kinds of actions in Struts
different JDBC drivers available
different JDBC drivers available  What are the different JDBC drivers available
Transaction Management
Transaction Management  How are transactions managed in EJB
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
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
Different between getRequestParameterMap() and getRequestParameterValuesMap()
Different between getRequestParameterMap() and getRequestParameterValuesMap()  What is the different between getRequestParameterMap() and getRequestParameterValuesMap
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
MySQL Network
to ensure the highest levels of reliability, security and uptime. As a proactive... to be curious about some of the details, or indeed be apprehensive about what it all..., support, consulting, and more. This has always been the case. What MySQL
different between ntfs and fat
different between ntfs and fat   hello, what is the different between ntfs and fat ???   hello, The major difference between FAT and NTFS is security. If you have FAT partition then Security and Quota tap
Different tables present in MySQL
Different tables present in MySQL  What are the different tables present in MySQL? Which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2),ename varchar(10))?  
Technology What is and FAQs
Technology What is and FAQs     ... Information Control System that is a very powerful transaction processing system... of  data transaction in the network. The computer system is design
different types of storage devices of a computer
different types of storage devices of a computer  What are the different types of storage devices of a computer?   Magnetic disks, Tapes and DVDs are few examples of storage devices of a computer
What is normalization?
What is normalization?  What is normalization?   Hi, Normalization is basically to design a database schema such that duplicate... of normalization levels from 1. normal form through 5.normal form. Each normal form
What is webservices?
What is webservices?  What is web-services and what are the different types of web-services? It would be great if someone explain me the difference between these types of web-services in Java
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
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
I am trying to assign a variable the value of 0123, but it 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?  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s
I am trying to assign a variable the value of 0123, but it 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?  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s
Hibernate Transaction
Hibernate Transaction In this tutorial you will learn about the Transaction in Hibernate. In transaction multiple operations are gathered into a single unit... exceptions, are FATAL. In this case transaction is need to be rolled back
what is the server
what is the server  what is the server?   Server... several different server software packages running on it, thus providing many different servers to clients on the network. Sometimes server software is designed
What does COMMIT do?
What does COMMIT do?  What does COMMIT do?   Hi, here... in the transaction. The changes made by the DML statements of a transaction become... transaction is committed. Thanks
Web Page Transaction
Web Page Transaction  Hello sir, i want to add an Effective page transaction when i go to my home page to other page in js...plllzzz help me...rppy soon

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.