Category "transactions"

Is there a way to conditionally upsert in Elastic search in a single atomic transaction?

Upsert should only occur if the value of a particular field in the document that I'm attempting to upsert (the index) is greater than the one that is currently

EF6 allow read but disable insert/update/delete during transaction

I am doing some "sync" between different platform. During this sync I try to add/update/remove records. For it I'm wrapping all functionality in TransactionScop

SOL Transaction Fees Inquiry

Is it possible to code a solana program (smart contract) where the transaction fees that you should pay, i.e., for minting / stacking / swapping tokens within t

How to implement transaction in Azure Function?

How to keep multiple actions in one transaction? anyone is failed, I want to roll back the whole operation. e.g. Action 1 is to write a record to Azure Table. A

AWS SDK v3 TransactWriteItemsCommand TypeError: Cannot read property '0' of undefined

I am trying to use TransactWriteItemsCommand to work using the new AWS SDK V3 for NodeJS. Unfortunately I can't find an example and the docs are not really well

laravel db transaction context is available on called functions

I have found that for using DB::transaction in Laravel, in combination with the ORM, we need to run something like: DB::transaction(function() { // Mod

How can you merge the same type entities consecutively using JPA PresistanceContext

I am currently creating a small project to mimic simple bank transactions. Currently there are two types of transactions. Request transaction Transaction is can

How to force COMMIT inside function so other sessions can see updated row?

In a Postgres 12 database, I have multiple queries (SELECT, UPDATE, ...) in a function that all together take about 20 minutes to complete. I have a check at th

Spring transaction closes connection once commit for Propagation type REQUIRED_NEW

In my application i am processing messages from queue using camel and process it in multiple threads. I tried to persist the data to a table during the process

Avoid dyanmic content's translation in msgstr

I am using Django translations for ja and de using makemessage. There is a translation in that I don't want to translate dynamic content in de. I am using the

Two concurrent saveAll actions with a unique constraint

I am not using any type of locking. Is it possible that two concurrent saveAll requests trying to save the same set of records could collide with each other and

Design / Implement Transactional Outbox pattern in schema isolated multitenant application

I have a multi-tenant application. The tenants data is isolated based on schema. I want to implement a transactional outbox pattern, where I want to store the e

linked server : "No transaction is active." and "unable to begin a distributed transaction"

I have a CRM software on my local machine. In the SQL DB of the software, I added a linked server (our test website with our test DB: Windows Small Business Ser

eth-brownie: Deployed contract returning as transaction receipt instead of the contract itself. I cannot grab the contract from the address or alias

I deployed a token on the BSC network transaction it saved the object as a transaction receipt it is not returning the contract object, as it shows in the docs.

How do I add an error message to my stored procedure when 0 rows are affected?

I am trying to learn how to use transactions and error handling. Got stuck with custom error messages. The stored procedure generates badges for AdventureWorks

why does postgres set_config's is_local = true not persist the variable for the whole transaction?

I have a function that uses set_config with is_local = true to set a variable. Now I expected that a select statement using the variable with current_settings w

how to adjust ethereum transaction's nonce

In the process of developing the ethereum dapp, I tested the load and there was a nonce error. When building a rawTx, I used web3.getTransactionCount("accountAd

How to test a Django on_commit hook without clearing the database?

The on_commit function has been added to Django 1.9 to be able to trigger an action (e.g. a Celery task) after the current transaction has committed. They ment

select query inside loop - Database connections in JPA

In my Spring MVC application, I have @Transactional annotated method inside which I make call(select query) to DAO layer inside for loop. If my input list size

MQ: What happens if a message rollback FAILED?

I use IBM.XMS (9.1.0.0) to get the message from the queue from my .NET application. Under the session, I get the message from the queue then insert into the dat