Top "Isolation-level" questions

Isolation level defines what data an SQL transaction can view or access while other transactions work with the same data.

SELECT Statement - NOLOCK with SET TRANSACTION ISOLATION LEVEL READ COMMITTED

My understanding is that when NOLOCK is used in SELECT statement, it could read uncommitted / dirty rows as well. But …

sql sql-server sql-server-2005 tsql isolation-level
Why is System.Transactions TransactionScope default Isolationlevel Serializable

I am just wondering what a good reason to use Serializable as the default Isolationlevel may be when creating a …

c# transactionscope isolation-level
Spring Batch ORA-08177: can't serialize access for this transaction when running single job, SERIALIZED isolation level

I am getting this exception with SERIALIZED isolation level on JobRepository in Spring Batch: org.springframework.dao.CannotSerializeTransactionException: PreparedStatementCallback; SQL […

oracle spring-batch isolation-level
How to Select UNCOMMITTED rows only in SQL Server?

I am working on DW project where I need to query live CRM system. The standard isolation level negatively influences …

sql sql-server tsql isolation-level transaction-isolation
What is default isolation level hibernate uses if not explicitly set?

I have an application that uses hibernate version 3.6.4, and c3p0 version 0.9.1.2 for connection pooling. My underlying RDBMS is MySql …

hibernate isolation-level transaction-isolation
How to set isolation level on SqlCommand/SqlConnection initialized with no transaction

The following method is supposed to peroform a dirty read on an open connection. There are no transactions. Where do …

sql sql-server tsql sqlcommand isolation-level
Isolation levels in oracle

I would like to know different isolation levels with respect to commit, and would also like to know about row-level …

database oracle isolation-level transaction-isolation
View isolation level for a query in mysql

How do I determine the isolation level in use for a given query? After a query is executed (by a 3…

mysql entity-framework-4 locking isolation-level
Default isolation level in Spring Framework

I have a method in service layer which does the update functionality to database. @Transactional(propagation = Propagation.REQUIRES_NEW) public …

database spring isolation-level
set isolation level for postgresql stored procedures

Hopefully a simple question, but one for which I haven't readily found a decent answer. I'm reliably informed that stored …

postgresql stored-procedures isolation-level