create is a method that should return true only when everything went as expected and false otherwise. I'm going for error codes style control flow. class TransferOperator class TransferError <...

I came across a situation where I started doubting whether the two-phase commit protocol really guarantees the ACID properties, especially the 'A' part of it. Let's look at a theoretical distribute...

I was assuming that it was possible to do something like: transaction.add(collectionRef,{ uid: userId, name: name, fsTimestamp: firebase.firestore.Timestamp.now(), }); But apparently it is no...

I am currently working on an API using ASP.NET Core Web API along with Entity Framework Core 2.1 and a SQL Server database. The API is used to transfer money from two accounts A and B. Given the na...

Suppose I have a query: begin tran -- some other sql code And then I forget to commit or roll back. If another client tries to execute a query, what would happen?

Coming from the MS SQL world, I tend to make heavy use of stored procedures. I'm currently writing an application uses a lot of PostgreSQL plpgsql functions. What I'd like to do is rollback all INS...

I want to be able to query settings in another existing session. In particular the transaction_isolation. We have: current_setting('transaction_isolation') I want to call something like: sessio...

I will want to read all SQL query only committed transaction. I have Postgres 9.5 or can will update on PG 11. I need to get Transaction Log on SQL format

I am reading a manual about innodb transactions but still, there is lots of unclear stuff to me. For instance, I don't quite understand to the following behaviour: -- client 1 -- client 2 mysql&gt...

This seems like it should be really easy to find out, but I don't see it documented anywhere. If I open a sqlite connection and begin a transaction without specifying a timeout by calling sqlite3_b...

I'm trying to do MySQL locks implementation in PHP (I need both shared and exclusive, so I can't use GET LOCK). <?php $conn = new \Pdo('mysql:host=localhost;dbname=locks', 'root', 'root', [\PDO:...

I've started using mysql2 gem. I'm trying to figure out a few basic things - one of them is how to explicitly perform transactions (for batch operations, like multiple INSERT/UPDATE queries). In ...

I'm using Spring 3.1.1.RELEASE and Hibernate 4.1.0.Final. I'm getting a "could not initialize proxy - no Session" exception, despite the fact I'm wrapping the relevant method call in a @Transaction...

How do you guys decide that you should be wrapping the sql in a transaction? Please throw some light on this. Cheers !!

i go first straight for my questions: Why would one rather use engine.connect() instead of engine.begin(), if the second is more reliable? Then, why is it still on the tutorial page of SQLAlchemy a...

I've a number of controllers with a lot of methods that deal with transactions... and I want to set transaction timeout to 60 for all of them: @AllArgsConstructor @Controller public class MyControl...

I'm using Laravel 5.2. I would like to know what are the differences between : DB::beginTransaction() and DB::transaction() DB::commitTransction() and DB::commit() DB::rollbackTransction() and D...

I'm reading very detailed tutorials on how to use transactions with database types and database engines, but I haven't found a guide that teaches me when and why I should use them. I know transact...

Playing around with MongoDB and NoRM in .NET. Thing that confused me - there are no transactions (can't just tell MongoConnection.Begin/EndTransaction or something like that). I want to use Unit ...

Goal Invoke a CREATE TEMPORARY TABLE statement in Hibernate without using native SQL. That means using HQL or Hibernate APIs only. Save objects to the temporary table. Invoke a stored procedure w...

I'm trying to write to a log file inside a transaction so that the log survives even if the transaction is rolled back. --start code begin tran insert [something] into dbo.logtable [[main code ...

I'm trying to follow Clean Architecture using Go. The application is a simple image management application. I'm wondering how to best design the interfaces for my Repository layer. I don't want to...

After some googling I have found: Note from mysql docs: MySQL Cluster automatically shards (partitions) tables across nodes, enabling databases to scale horizontally on low cost, commodity ha...

What is the best practice for managing Kafka producer objects in request oriented (e.g. http or RPC servers) applications, when configured as transactional producers? Specifically, how to share pro...

i cannot provide specific code because the solution is classified. I'd just like to ask if, in some situation, it is possible to have the error ORA-14450 "attempt to access a transactional temporar...