transactions Questions
4
I'm making a self project in C#.Net, by using a 3-tier app, I wan't to make my sql statements transactional, these statements are used in several stored procedures, I've been using the WITH(NOLOCK)...
Sevigny asked 5/10, 2015 at 14:7
3
Solved
Whhen trying to test caching capabilities of Hibernate's (version 4) EHCache between transactions - it fails: Failed to retrieve PlatformTransactionManager for @Transactional test for test context....
Balata asked 20/5, 2016 at 10:35
0
This directly relates to this other question, as a natural follow-up question (which was asked in comments, but was never replied to).
Textual description
Assuming:
the application uses the defaul...
Servais asked 27/1, 2022 at 4:18
3
Solved
I have several integration tests for various services that extend the following baseclass:
@ContextConfiguration(locations="classpath:applicationContext-test.xml")
@TransactionConfiguration(transa...
Diatomite asked 3/3, 2011 at 9:16
2
Solved
Wikipedia describes the Phantom read phenomenon as:
A phantom read occurs when, in the course of a transaction, two identical queries are executed, and the collection of rows returned by the sec...
Rheology asked 26/1, 2015 at 6:43
4
Solved
The on_commit function has been added to Django 1.9 to be able to trigger an action (e.g. a Celery task) after the current transaction has committed.
They mention later in the docs that one should...
Soult asked 3/3, 2017 at 17:38
5
Solved
I have 2 Jobs that read and produce data in a Sql Server Database. Every once in a while the jobs crash with a System.Transactions.TransactionInDoubtException. The exact stack trace is:
Unhandled...
Spirited asked 16/4, 2014 at 12:20
4
Solved
I have a session (SQLAlchemy) on PostgreSQL, with an active uncommitted transaction. I have just passed the session to some call tree that may or may not have issued SQL INSERT/UPDATE/DELETE statem...
Mylor asked 30/10, 2009 at 17:26
2
Solved
My team needs a serial column to increase monotonically with each commit.
There are cases in which two transactions get values 100 and 101 from a sequence, then the 100 transaction takes longer t...
Pterous asked 24/8, 2017 at 15:56
3
Django's docs say this about transaction.atomic() and exceptions:
https://docs.djangoproject.com/en/1.10/topics/db/transactions/#django.db.transaction.atomic
Avoid catching exceptions inside atomi...
Supernova asked 3/3, 2017 at 19:21
2
I want to create a sequelize hook on afterCreate on my user model. it work great when i just create a user without a transaction. but if i run my create statement in a transaction the hook is run b...
Bohon asked 26/1, 2016 at 13:15
2
Solved
Say I'm working on an ETL that periodically reads source data from a CSV and replaces a table in Postgres (9.6).
Here is one approach:
BEGIN
DROP TABLE IF EXISTS table
CREATE TABLE table (...)
CO...
Exsiccate asked 6/6, 2017 at 16:45
7
Solved
I have a model function that I want to make sure uses a transaction. For example:
class Model
def method
Model.transaction do
# do stuff
end
end
end
My current approach is to stub a method...
Elfredaelfrida asked 9/5, 2012 at 7:1
4
Solved
I have written some APIs, for which the respective functions executive inside a transaction block. I am calling the save() method (after some modifications) on instance/s of a/several Model/s, and ...
Photothermic asked 16/10, 2015 at 22:56
7
Solved
Node.js 7 and up already support async/await syntax. How should I use async/await with sequelize transactions?
Glanville asked 18/3, 2017 at 4:12
4
Solved
I heard from a speaker at a Hackaton event organized by a bank that you should not use nosql for financial transaction for security reasons. But I have no idea what he's saying. I have been looking...
Hypothesis asked 21/3, 2017 at 4:41
4
Solved
background
I have some code which opens a sql connection, begins a transaction and performs some operations on the DB. This code creates an object from the DB (dequeue), gets some values and saves...
Saritasarkaria asked 11/4, 2016 at 14:59
3
Solved
I know that in the SQL standard there are four isolation levels when dealing with transactions:
READ UNCOMMITTED - will allow everything
READ COMMITTED - will not allow dirty reads
REPEATABLE READ...
Fredra asked 30/11, 2015 at 14:25
2
Solved
I need to use a transaction in my project on MySQL. But I'm not sure if I have to use mysql_query("SET AUTOCOMMIT=0"); or not.
I know I have 2 options:
BEGIN
START TRANSACTION
Also I have heard...
Unchain asked 7/7, 2012 at 14:36
2
Does anyone have experience they can share using MySQL savepoints (directly or via an ORM), especially in a non-trivial web service? Where have you actually used them? Are they reliable enough (ass...
Rabinowitz asked 26/2, 2009 at 18:46
2
Solved
I'm trying Laravel transaction for the first time... I do most of my queries with Eloquent and since there no transaction there I have to do a mixture of Eloquent and query builder.
Here is my cod...
Callant asked 7/8, 2016 at 10:46
2
Solved
There are two functions A and B which are defined with Transactional annotation.
I am calling B from A.
@Transactional(value=Constants.READ_WRITE_REQUEST)
public int A(....){
B();
}
@Transactio...
Skiles asked 13/1, 2012 at 7:44
3
Solved
I have a piece of code that involves multiple inserts but need to execute submitchanges method before I finish inserting in other tables so that I can aquire an Id. I have been searching through th...
Cooperate asked 16/4, 2009 at 11:54
2
Solved
I need to delete the majority (say, 90%) of a very large table (say, 5m rows). The other 10% of this table is frequently read, but not written to.
From "Best way to delete millions of rows by ID",...
Audiophile asked 3/2, 2016 at 22:22
1
In my Django apps, the first database operation that I want to wrap in a transaction might occur at any level of the framework -- it could be in the view, a manager method, or a model method.
Up u...
Anthelmintic asked 2/9, 2017 at 18:19
© 2022 - 2024 — McMap. All rights reserved.