Top "Transaction-isolation" questions

How to set isolation level in @Transactional "READ_UNCOMMITTED". I am using EclipseLink 2.5.1-RC1

I have a requirement to start new Transaction within an ongoing Transaction so that an exception in 2nd transaction will …

jpa eclipselink transactional transaction-isolation read-uncommitted

What are the conditions for encountering a serialization failure?

The PostgreSQL manual page on the Serializable Isolation Level states: [Like] the Repeatable Read level, applications using this level must …

sql postgresql transactions transaction-isolation

Can a locked row [in Postgres] still be read from?

If I SELECT... FOR UPDATE a row in a transaction, it will obviously block the row from being written to, …

sql postgresql transaction-isolation

Minimum transaction isolation level to avoid "Lost Updates"

With SQL Server's transaction isolation levels, you can avoid certain unwanted concurrency issues, like dirty reads and so forth. The …

sql-server isolation-level transaction-isolation

postgresql trigger: disable auto commit and set isolation level

i'm writing a trigger on database INSTEAD OF INSERT ON a table, that made some operation, then insert data into …

sql postgresql triggers autocommit transaction-isolation

Atomic UPDATE to increment integer in Postgresql

I'm trying to figure out if the query below is safe to use for the following scenario: I need to …

multithreading postgresql concurrency race-condition transaction-isolation