transactions Questions
5
Solved
Does SQL Server allow constraint violations (i.e. deferred constraints) in a transaction as long as the transaction has not been committed yet?
I have a running, uncommitted transaction and while ...
Pasley asked 12/5, 2011 at 7:31
2
Solved
My entity has both autogenerated primary key (id) and business key (namespace). I need to update the record by replacing the old one. So, I'm searching it by business key, delete it and save a new ...
Angstrom asked 31/12, 2014 at 8:29
3
I kinda understand the purpose of entity locking and transaction isolation level, but can't get the difference between pessimistic locking and serializable level. As I understand, in both cases the...
Lientery asked 22/11, 2017 at 17:50
5
Here's a strange problem I'm running into on a production server. It has happened twice in the last two weeks, and this is a server that gets a lot of traffic.
We have some code in a Web Service t...
Alexina asked 11/4, 2011 at 15:43
6
Solved
I have an application - more like a utility - that sits in a corner and updates two different databases periodically.
It is a little standalone app that has been built with a Spring Application C...
Bryner asked 24/9, 2008 at 17:1
3
Solved
I have a CRUD with insert and update functions with commit at the end of the each one as follows:
@staticmethod
def insert(db: Session, item: Item) -> None:
db.add(item)
db.commit()
@stati...
Efficiency asked 13/1, 2021 at 10:24
6
Solved
The preamble:
I have designed a strongly interfaced and fully mockable data layer class that expects the business layer to create a TransactionScope when multiple calls should be included in a sing...
Kirkland asked 9/3, 2009 at 15:50
3
Solved
I am having problem with transactions in php script. I would like to make multiply queries and be able to recall them all, if at least one of them fails. Below you can find a simple example of the ...
Sequential asked 30/12, 2016 at 8:22
6
Solved
I'm trying to make a transaction to create an NFT collectible and the transaction gets reverted with the message: Gas estimation failed: 'execution reverted'. This transaction will likely revert. I...
Kessel asked 20/2, 2022 at 13:28
7
Solved
I understand how a transaction might be useful for co-ordinating a pair of updates. What I don't understand is wrapping single statements in transactions, which is 90% of what I've ever seen. In fa...
Spew asked 23/7, 2009 at 13:31
7
I was investigating the rapid growth of a SQL Server 2005 transaction log when I found that transaction logs will only truncate correctly - if the sys.databases "log_reuse_wait" column is set to 0 ...
Nanine asked 18/9, 2008 at 5:48
2
Solved
I can't find any information on this anywhere and yet the question is simple.
Can I wrap storage-related actions in a TransactionScope such that e.g. if there is a rollback, the uploaded file is r...
Cafeteria asked 4/8, 2013 at 17:20
4
Solved
I have read about 4 levels of isolation:
Isolation Level Dirty Read Nonrepeatable Read Phantom Read
READ UNCOMMITTED Permitted Permitted Permitted
READ COMMITTED -- Permitted Permitted
REPEATABLE...
Odilo asked 23/4, 2013 at 6:22
1
I'm very new to Prisma and NestJS. I have the following transaction-wrapped function that I want to unit test by mocking the internal function reserveSingleBook.
This is my code (it does a few acti...
Marvel asked 16/7, 2022 at 19:49
2
Solved
I would like know what is the best possible way to implement transactions with DBContext. In particular,
Does DbContext.SaveChanges implement transaction internall if i change multiple entities?
...
Colin asked 17/5, 2011 at 9:10
12
Solved
What is the difference between non-repeatable read and phantom read?
I have read the Isolation (database systems) article from Wikipedia, but I have a few doubts. In the below example, what will ha...
Defile asked 15/6, 2012 at 1:54
1
I use the repository pattern. My repository methods receive an optional IClientSessionHandle parameter which defaults to null. A part of each method prepares the filters/updates/etc., then a call i...
Braw asked 14/1, 2020 at 21:29
2
While analyzing some performance problems in Wildfly 10.1 in high pressure scenarios I came to the conclusion, that sometimes parallel HTTP threads block each other.
The reason seemed to be that ...
Overage asked 7/4, 2017 at 15:50
6
Solved
Consider the following:
START TRANSACTION;
BEGIN;
INSERT INTO prp_property1 (module_name,environment_name,NAME,VALUE) VALUES ('','production','','300000');
/** Assume there is syntax error SQL ...
Twinge asked 25/5, 2011 at 9:0
2
I am working on a Rails 5.x application, and I use Postgres as my database.
I often run rake db:migrate on my production servers. Sometimes the migration will add a new column to the database, and...
Board asked 30/8, 2019 at 6:14
3
Solved
Can the SQL "truncate table" command be used within a transaction? I am creating an app and my table has a ton of records. I want to delete all the records, but if the app fails I was to rollback m...
Hallerson asked 5/10, 2009 at 23:36
3
Solved
According to the official documentation, and the books I have read, services are transnational be default. however, we were getting records committed, even if we immediately throw a RuntimeExceptio...
Launder asked 26/2, 2015 at 14:5
1
Solved
TL;DR Should I use Transaction.getAll() or use a for loop and update the documents one by one using Transaction.get()
consider the following schema:
- someTopLevelCollection
- accountId1
- proj...
Janitajanith asked 24/5, 2019 at 12:17
3
Solved
I am trying Spring 3(.0.2.RELEASE) and JPA2 and Hibernate 3.5.1-Final...
One thing upsets me is that spring seems only accept a transaction Manager named "transactionManager"
If I don't name it "t...
Smegma asked 12/6, 2010 at 4:42
7
I have hosted my WebApp on server 1 and my database on server 2
But I'm getting following error
Communication with the underlying transaction manager has failed.
I googled and found a post which ...
Cherish asked 16/9, 2014 at 7:2
© 2022 - 2024 — McMap. All rights reserved.