Share on Google+Share on Google+

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

what are different transaction levels

Ads

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
Java transaction
Java transaction  How do you handle your own transaction
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
Implement transaction serializability
Implement transaction serializability  I need to implement transaction serializability in Java using semaphores/monnitors. What is the code to do
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
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
Tutorials   
Java Spring Hibernate Struts Training how to retrieve text and images from mysql database and show on html page using jsp servlet How to install Neo4j on Ubuntu 15.10? please help me in these prog MYSQL - mysql copy table to another table example by creating new table solution for mapping hibernate and pojos from net beans through database Connect GWT application with Oracle inventory System of Medical Store inventory System of Medical Store inventory System of Medical Store inventory System of Medical Store This code have created jTable that connected with a database.every cell of last column have a button.But this button doesn't work properly.Where is the error java program Java Database Program jdbc Database connection class in a live project ..?? What is JDBC architecture? Unable to Create DSN for excel to ms access importing data and edit that data Database Scrolling Buttons how to use foreign key in java How to delete content of a log file from linux terminal? JSP-Oracle connectivity Student Management System Java code for Saving Marathi (Indian local language ) in Mysql and retrieving the same crud operations with foreign key constraint. I really need help with this assignment question Please help me out Please Backup Failed Mysqldump Got Errno 28 On Write Upgrade MySQL 5.1 to 5.5 in cpanel mysqldump all databases com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jpa.sequence' doesn't exist persistence xml class element persistence.xml for MySQL MySQL JDBC Driver pom dependency code Blob column jdk6 and oracle 8i connexion oracle 8i et jdk6 java [ cannot retrive date from sql ] why?? Order Entry System How to threow timeout exception when DB is not responding How to threow timeout exception when DB is not responding This is the employee form to add data to mysql database but I got error of NullPointerException, Is this write code please give me feedback as soon as possible make a method which takes user name & pwd as parameter & validate them against the database. If the corresponding user exist return true otherwise false. prabhakar validating credentials and displaying error message in login .jsp if not valid JDBC jdbc jdbc code register servlet vibhu connectiondetails from vibhu

Ads

 
Advertisement null

Ads