Questions tagged [transactions]

-1 votes
0 replies
Locking entire SQLite3 database during update
I have to update a SQLite3 database, which will drop a table, recreate it, and then repopulate the table. I want to ensure all my other processe...
asked 4 months ago
0 votes
1 replies
“transaction do” without explicit receiver
According to the docs, in Rails models, transactions are made on either classes descending from ActiveRecord::Base or any instance of such a clas...
0 votes
1 replies
SQL Segmented Ranking Operation
I am willing to find the rows, which comes immediately after the (latest) row where Text = E. It is like an transaction log where I want to find...
0 votes
1 replies
Surround test class with transaction and rollback
I wrote an integration test with multiple tests which based on each other. Therefore the test methods aren't independent and the exection order i...
0 votes
1 replies
Spring Hibernate @Data update vs raw UPDATE query: Optimistic Lock Exception despite @Transactional?
I am working with Spring Hibernate ORM for Data Management with MYSQL DBMS using my Java Spring application. I have a simple requirement - when s...
0 votes
0 replies
how to log information from within transactions while accounting for rollbacks
In my Rails application there are some database transactions which can sometimes fail and be retried following optimistic concurrency rules. The...
asked 4 months ago
1 votes
0 replies
How do Nested Transactions work in Laravel?
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 mast...
asked 4 months ago
0 votes
0 replies
Is it possible one transaction for multiple connections in mongodb?
I'm trying implement one transaction for multiple database connection in mongodb. But it's stuck in startSession(). I have two db(replica set) an...
asked 4 months ago
-2 votes
0 replies
No transaction is currently active java.lang.IllegalStateException:
Exception Description: No transaction is currently active at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.rollback try...
asked 4 months ago
0 votes
1 replies
PDO Transaction while using multiple methods and direct queries together?
I need to be sure that the following works fine with PDO Transactions: // Database Transaction try { // Start the transaction. $db->b...
asked 4 months ago
0 votes
1 replies
What is solution for save multiple MySQL database connections in PHP
I need a solution for save every MySQL connections in PHP and use it in sql transactions between connections. I know that I can't do transaction...
asked 4 months ago
0 votes
1 replies
Why does the database not reflect the changes made by the php INSERT?
I am calling INSERT and DELETE Statements via PHP to a MySQL Database. The PHP script finishes successfully, but in the database nothing has chan...
asked 4 months ago
0 votes
1 replies
SQL UPDATES/INSERTS are not getting blocked during a transaction
I have a table where it is constantly being sent UPDATES/INSERTS from other processes, and I am trying to perform a transaction to my SQL table w...
0 votes
0 replies
how to design storage for transactions involving multiple tables in dynamodb?
I am trying to add transaction support to an existing dynamodb storage which looks like this: public interface Storage<T>{ T put(T entity)...
-1 votes
0 replies
A way to store data offline and upload it to the database when it comes back online
Here's the scenario: every hour, I upload some data to the database, however, if the database goes offline for a couple of hours, I'd still like...
1 votes
1 replies
Entities not persisted to DB when using Spring's asynchronous execution
I need to run an asynchronous job that imports data (read from a file) to a MySQL DB. I am using Spring Data's CrudRepository. The problem is tha...
asked 4 months ago
0 votes
1 replies
Achieving Isolation for Specific Rows in Database C#
I have an application which issues letters to users in sequential order. This is the database structure ------------------- UserID LastIssued -...
asked 4 months ago
1 votes
1 replies
SSIS Transactions: Does Supported option create a new transaction if it does not exist?
Required starts a new transaction while Supported joins an existing transaction. However, if a transaction does not already exist, then does the...
asked 4 months ago
1 votes
0 replies
Issue in managing Hibernate transactions
I am using a thread based approach to poll the status of a specific task on AWS. For this, I use a while loop to constantly check the status as s...
0 votes
1 replies
Lock the concurrent reading row table
I have a table called "Consecutives" in SQL Server, in this table a number is stored. I have another table "Data", where they store the records...
0 votes
0 replies
SQL Server unexpectedly rolling back transaction
Using SQL Server 2016+ and VB.Net I am currently seeing an issue where I have gaps in my logs. These logs are created by manually inserting inf...
asked 4 months ago
0 votes
1 replies
Scala mongodb transaction: How to rollback?
There is an example of Scala mongodb transaction: https://github.com/mongodb/mongo-scala-driver/blob/r2.4.0/driver/src/it/scala/org/mongodb/scal...
asked 4 months ago
8 votes
1 replies
GAE/P: Transaction safety with API calls
Suppose you use a transaction to process a Stripe payment and update a user entity: @ndb.transactional def process_payment(user_key, amount):...
1 votes
1 replies
Strategy to select correct Aggregate root, so transaction won't span multiple aggregates
I'm modeling Category/Menu domain context and decided to have 2 Aggregate roots for this context. public class MenuItem : Aggregate<Guid>...
0 votes
1 replies
How to fix LazyInitializationException - no Session in Spring application?
In Spring application sometimes I have exception: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role ......