transactions Questions
5
Solved
The PostgreSQL manual page on the Serializable Isolation Level states:
[Like] the Repeatable Read level, applications using this level must be prepared to retry transactions due to serialization...
Fairing asked 9/10, 2011 at 17:39
6
Solved
I'm new to JPA and Hibernate and I have a problem with optimistic locking. I have a class which has an @Version annotated field. When I update the Entity represented by this class, the version coun...
Hayfork asked 20/6, 2014 at 6:32
3
Solved
I have a long running function that should be inserting new rows. How do I check the progress of this function?
I was thinking dirty reads would work so I read http://www.postgresql.org/docs/8.4/in...
Declassify asked 22/7, 2009 at 13:54
5
Solved
This question is related to my question: SQL Server and TransactionScope (with MSDTC): Sporadically can't get connection
I'm doing some transaction programming using the .net TransactionScope ...
Atiptoe asked 21/6, 2010 at 14:36
8
Solved
I'm using Spring 3.1.1.RELEASE, Hibernate 4.1.0.Final, JPA 2, JUnit 4.8.1, and HSQL 2.2.7. I want to run some JUnit tests on my service methods, and after each test, I would like any data written t...
Barbarbarbara asked 15/1, 2013 at 18:0
5
Solved
I did some queries without a commit. Then the application was stopped.
How can I display these open transactions and commit or cancel them?
Stoichiometric asked 29/9, 2011 at 13:54
6
Solved
We're running into a problem here and I can't figure out why it behaves how it behaves.
Given the following two (simplified) stored procedures in TSQL (SQL Server 2008R2)
create procedure [datetr...
Esoteric asked 13/9, 2013 at 13:33
1
Solved
I have implemented a class where i need to insert some data into a database but the insert must rollback if something goes wrong. Once i have performed the insert i throw an exception to test the r...
Nauseous asked 29/9, 2022 at 15:20
5
Solved
Sometimes I saw the following code snippet. When is the if @@trancount > 0 necessary with begin try? Both of them? Or it's a safe way(best practice) to check it always in case it's rollback befo...
Finer asked 21/12, 2012 at 2:23
2
Can somebody explain me whats exactly the difference between a
'lost update' and a 'write skew' in database transaction theory?
Can somebody give me an example?
Babism asked 7/1, 2015 at 19:1
2
Solved
I have a question regarding what purpose we are using SELECT FOR UDPATE? What does it do exactly?
I have 2 tables, from that I need to select rows from table and update the same rows.
For example:
...
Morello asked 9/1, 2015 at 17:29
1
I'm reading A Critique of ANSI SQL Isolation Levels
and get confused by the two definitions:
Dirty write
w1[x]...w2[x]...((c1 or a1) and (c2 or a2) in any order)
Lost update
r1[x]...w2[x]...w1[...
Krein asked 3/7, 2022 at 22:51
6
My Tests are using the trait RefreshDatabase to "migrate fresh" before starting tests and use transactions for each testing method.
The migration works fine, but the transactions are not working a...
Schaffhausen asked 10/2, 2018 at 20:4
5
Solved
From this oracle java tutorial:
A non-repeatable read occurs when transaction A retrieves a row,
transaction B subsequently updates the row, and transaction A later
retrieves the same row again. T...
Synchronous asked 18/8, 2013 at 9:23
2
Solved
I created several similar threads about particular issues, but let me summarize the problem I'm facing more globally:
GOAL
Need to intercept all Insert/Update/Delete DB Transactions in an applica...
Alfano asked 16/11, 2018 at 16:50
8
Solved
I want to know what isolation level is set for current Mysql database. How can find it out? I tried searching it on the google but did not find it.
Coaptation asked 24/1, 2017 at 10:31
4
I am trying to utilize the repository design pattern in my application for 2 reasons
I like to de-couple my application from Entity in case I decide to not use Entity Framework at some point
I wa...
Tribe asked 6/10, 2016 at 22:18
3
Solved
Does SQL Server allow a transaction to modify the data that is currently being modified by another transaction but hasn't yet been committed? Is this possible under any of the isolation levels, let...
Isisiskenderun asked 4/12, 2014 at 20:9
3
I'm facing the following problem at different points of my code.
An SqlException is returned from DB (SQL Server) with message "Uncommitable Transaction is detected at the end of the batch. Transac...
Teucer asked 27/5, 2014 at 14:14
3
Solved
Please help me understand the use-case behind SELECT ... FOR UPDATE.
Question 1: Is the following a good example of when SELECT ... FOR UPDATE should be used?
Given:
rooms[id]
tags[id, name]
room_...
Eudo asked 7/6, 2012 at 16:23
3
Solved
I read about database isolation levels and transactional phenomena.
Dirty reads are obvious but I don't understand dirty writes.
All descriptions of dirty write say something like:
A dirty write i...
Pericynthion asked 1/4, 2020 at 13:46
4
Solved
How do I set the isolation level of MySQL 5.1 InnoDB?
By entering:
mysql> show variables like '%isola%';
The default level set for InnoDB is repeatable read.
How do I change the isolation lev...
Vulgarize asked 29/10, 2011 at 7:2
4
Solved
I have been investigating transactions and it appears that they take care of themselves in EF as long as I pass false to SaveChanges() and then call AcceptAllChanges() if there are no errors:
Save...
Anselma asked 2/5, 2009 at 20:50
2
Solved
I'm just wondering as per the title if this can be done? For example, if I was to do something like this:
$this->db->autocommit(false);
But then afterwards I wanted to set it back to it's ...
Forgo asked 13/11, 2014 at 16:3
3
Solved
I'm working with transactions in laravel 5, so far I have been getting the results of any method outside of the statement with a reference param &$, but I red this is a bad practice because the...
Anthology asked 5/11, 2017 at 17:47
© 2022 - 2024 — McMap. All rights reserved.