Most voted "transactions" questions
Tag referring to database transactions that is characterized by a sequence of operations in a database management system that are treated as a single, indivisible (atomic) block during a failure recovery and also provide isolation between concurrent accesses in the same data mass.
Learn more…63 questions
Sort by count of
-
0
votes1
answer464
viewsBegin Transaction and Save Transaction SQL Server
I have a Storedprocedure on a system I’m working on and I have the following code begin transaction; save transaction Integration_SP; -- CODIGO commit transaction; I have been searching and only…
-
0
votes2
answers177
viewsRun an SQL script in transaction without it blocking other scripts accessing the same table
Can anyone tell me if there is a way I can execute an SQL Server script in transaction without it blocking other scripts that try to access the same table? I created a program in c# that accesses my…
-
0
votes1
answer55
viewsTransaction in the Spring
I want to know more about transactions in spring. I have the following structure: My Service: @Service @Transactional public class MinhaClasseServiceImpl implements MinhaClasseService { @Autowired…
-
0
votes0
answers51
viewsTransaction with Entity Framework. Saves 2 times after error
I am using transaction to make changes to the bank. My problem is when there is an error in saving time. If there is error at the time of inserting the drive it treats the correct way not saving…
-
0
votes1
answer91
viewsMysql transaction error in php
Good morning, forum guys. I’m trying to do the simultaneous Insert, then I’m using transaction control in php, only it doesn’t make the first Insert, so it generates me a Foreign key error. public…
-
0
votes0
answers137
viewsStandard Singleton in simultaneous connections
I’m developing a project and I made a class in the pattern Singleton to connect to the database: <? class Conexao extends PDO { private static $instancia; public function __construct($dsn,…
-
0
votes1
answer916
viewsWhen is it valid to use XACT_ABORT() in a script that is already using TRY/CATCH?
Assuming the following code: /* DROP TABLE #Teste; CREATE TABLE #Teste(id INT); INSERT INTO #Teste VALUES(1); CREATE TABLE LogErros(id INT IDENTITY(1,1) PRIMARY KEY, nomeTransaction VARCHAR(100),…
-
0
votes1
answer204
viewsConflit FIREBIRD Lock Error
I’m new to the subject of database, so I hope you understand my doubt and lack of knowledge: We use Firebird as SGDB and Ibexpert as a tool for database administration and configuration. Because the…
-
0
votes0
answers147
viewsconcurrent transactions spring boot + Docker
I have an app on Docker with Jhipster(Spring Boot + Angular) where Gero protocols for service. I’m using the @Transactional in the class of generating the protocols for control in the generation of…
-
0
votes1
answer62
viewsSQL execution pouch while executing another program in transaction
I created a program that accesses my database in transaction READ UNCOMMITED. _oConn.BeginTransaction(IsolationLevel.ReadUncommitted, _transactionName); Everything that runs within that transaction…
-
0
votes1
answer99
viewsMYSQL - TRANSACTIONS
Good evening, I’m a beginner in mysql and I came up with the following question. When I make a transaction like this START TRANSACTION ; INSERT INTO PESSOA2(IDPESSOA,NOME) VALUES(NULL,'PEDRO2');…
-
0
votes0
answers58
viewsSpring Boot rollback in chain transactions
After validating all entities, I call a method to perform several operations in the bank, in which if one of them goes wrong, all the above must be undone. When arriving at the "throw new…
-
-1
votes1
answer354
viewsFiredac Fdquery with Mysql Transaction.commit and rollback does not work
I am running a test with Fdconnection and Fdquery and Mysql database. In my test table there is only one field called key with Primary key. Running command below, rollback does not work. Relate the…