Simply stated: What is the difference between "Transactional" and "Non-Transactional"? In my case I came up with this question while reading the following definition for "MDM": "In computing, ...

I am developing an app together with a partner. I do the database part in PostgreSQL, my partner implements the app on the web-server with Python using SQLAlchemy. We make heavy use of server-side ...

According to the documentation (https://www.postgresql.org/docs/current/app-psql.html), even with AUTOCOMMIT set to off, PSQL issues an implicit BEGIN just before any command that is not already in...

Is it possible to roll back automatically if any error occurs on a list of MySQL commands? For example something along the lines of: begin transaction; insert into myTable values1 ... insert into ...

When I am using pymongo 3.7 transaction function to connect to mongo server 4.0, this error "Transaction numbers are only allowed on a replica set member or mongos" occurred and I cannot find any a...

Hi I have following issue. I have prisma transaction but I would like to pass the prisma transaction client into a function like this: ... prisma.$transaction(async (tx) => { someFunction(t...

I know that by default, transaction is used in Django Admin when adding, changing and deleting data according to my tests. But, I selected Delete selected persons and clicked on Go in Django Admin ...

I've installed MongoDB v4.0 for the most amazing feature of it Transaction in Nodejs with mongodb 3.1 as a driver. When I try to use a transaction session I've faced this error: MongoError: Transac...

I am using a NoSQL database MongoDB with Java and Spring Data. I am aware that MongoDB only supports transactions for a single document. I am using Spring Transactions to carry out MongoDB transca...

We all use DB::transaction() for multiple insert queries. In doing so, should a try...catch be placed inside it or wrapping it? Is it even necessary to include a try...catch when a transaction will...

I have situation in which I have to commit a portion of code as transaction of its own. I have created a table subtransaction_tbl: CREATE TABLE subtransaction_tbl ( entryval integer ) And a fun...

I am following this link https://vladmihalcea.com/read-write-read-only-transaction-routing-spring/ to set up the database master and replica instance in my spring boot app. The only difference is I...

I want to read text data fixtures (CSV files) at the start on my application and put it in my database. For that, I have created a PopulationService with an initialization method (@PostConstruct a...

I recently ran into the need to disable transaction requests in one of my views, in order to be able to call db.connection.close() and connect() during requests in an effort to improve performance....

I have followed the official documentation for converting the standalone mongodb instance (local ubuntu machine) to replica set. The part where we restart mongod with --replset flag seems to invite...

I need to use table locking (write) and along with that update a few tables, so I need transactions at the same time, as the locking is not transaction-safe. From mysql documentation I read the fo...

I cannot catch exceptions in method annotated @Transactional. I want to send mail to created user if save operation succeded. When username is already in use PostgreSQL throws exception PSQLExcep...

Firstly it is possible that I am asking something that has been asked and answered before but I could not get a search result back. We define transactional annotations on service layer typical spri...

Can somebody explain how mysqldump --single-transaction actually works for transactional tables, like InnoDB? I've read the official documentation but still have no clue. Does it perform per table ...

Does anyone know the command to check if there is an un-committed transaction in SQL Server 2005?

I'm developing my insight about distributed systems, and how to maintain data consistency across such systems, where business transactions covers multiple services, bounded contexts and network bou...

I am building my own custom repository, based on entity framework, and I'm creating some extension methods that allow me to save partial view models as entity models so I'm building my own Add and ...

I'm trying to get a better handle on the use of Spring's @Transactional attribute. I understand that it basically wraps the contents of the method marked as @Transactional in a transaction. Would i...

I read this topics: SQL Server 2014 reseting isolation level How do I unset/reset a transaction isolation level for SQL Server? KB3025845 - FIX: The transaction isolation level is reset incorrectly...

I am using Mongoose to access to my database. I need to use transactions to make an atomic insert-update. 95% of the time my transaction works fine, but 5% of the time an error is showing : "Give...