Motivation I have a service which I want to make @Transactional. My service is storing complex data in multiple tables, there is a referential integrity between the tables. public class MyData { //...

I understand the error message and i know how to solve it, but i want to know why it occurs in this specific place especially on a find method. I created a mini example for this. I have three entit...

MongoDB is to me a great database. However there are cases where I really need atomic multi-document transactions. For example to transfer things (like money or reputation) between accounts and thi...

i must admit that i am very new to indexedDB I wrote a simple code of indexedDB and it is as followed: function go() { var req = window.indexedDB.open("Uploader", 1), db; req.onerror =...

We use Hibernate through JPA and Spring to manage object persistence in our web application. We use open-session-in-view pattern to create sessions for threads responding to http requests. We also ...

I'd like to configure "transactional" beans from my Spring @Configuration class instead of annotating the class implementation itself with @Transactional. Kind of like the old school way, configur...

I'm trying to use a server-side curser in psycop2 as detailed in this blog post. In essence, this is achieved with from django.db import connection if connection.connection is None: cursor = con...

If a stored procedure contains multiple statements e.g. first an insert, then an update and finally a deletes and the stored procedure gets killed in the middle of the delete, does the insert and u...

I have a lot of transactions in my code, and if an error occurs in executing in one of these transactions that doesn't trigger commit or rollback, then the database is locked and any subsequent att...

I am implementing an instance of the Realm Database within the android application I am designing. However, at first I got this error about Realm transactions on main UI thread: Running transaction...

Reading this documentation https://docs.djangoproject.com/en/4.0/topics/db/transactions/#django.db.transaction.on_commit This is the use case for on_commit with transaction.atomic(): # Outer atomic...

From a script I sent a query like this thousands of times to my local database: update some_table set some_column = some_value I forgot to add the where part, so the same column was set to the s...

I've a master function A that is called before function B and after function C. Both save one model and have their own begin transaction and master transaction in function A, how is data stored? I...

This method begins with Transaction @Transactional(propagation = Propagation.REQUIRED) public Account generateDirectCustomerAccountEntity(AccountReq source, Map<String, String> headers, Strin...

I am using SQLAlchemy and PostgreSQL. Postgres supports doing deferred constraints, which allows us to postpone checking the constraints on a table until the end of the transaction. For example, i...

GPay integration was working totally fine before 2 days but now its showing same error in gpay app. Intent calling for gpay payment is not working. I have completed transaction successfully days be...

Can JDBC transactions and kafka transactions work together as XA transaction? Does kafka transaction API supports XA transaction?

My application is experiencing lock contentions on one of our heavily-trafficked tables in our SQL Server database. I have been advised by our DBA team to follow other teams' configuration, which h...

I am trying to get Spring Transaction Management working in my new Spring Boot + MyBatis application. So far I have managed to get everything working with minimal issues - it's just getting the @T...

Can you have multiple transactions within one Hibernate Session? I'm unclear if this is an allowable desirable. In my code I have a long running thread and takes items from a Blocking Queue, depen...

I have method M with @Transactional in service A. I have service B extends A with overrided method M. Will be overrided method M still transactional? Or I should add there @Transactional?

I have the following strange scenario with spring's transaction management: I have method A which calls method B which calls method C, each of them in a different class. Methods B and C are both w...

I am using Flask-SQLAlchemy, with autocommit set to False and autoflush set to True. It's connecting to a mysql database. I have 3 methods like this: def insert_something(): insert_statement = &lt...

That's the source code, I need to detect the ID (see the marked position between the two queries below). $connection = Yii::app()->db; $transaction=$connection->beginTransaction(); try { $...

I have a Spring-managed service method to manage database inserts. It contains multiple insert statements. @Transactional public void insertObservation(ObservationWithData ob) throws SQLException ...