Top "Transactions" questions

A set of interrelated operations that must all succeed in order for any of them to succeed.

How to use TransactionScope in C#?

I am trying to use TransactionScope, but keep getting the exception below. The app is running on a different machine …

c# .net database transactions transactionscope
How to use transactions with a datacontext

Can I use transactions with a datacontext, so that I can rollback the state of the context after an error? …

c# linq linq-to-sql transactions datacontext
PostgreSQL cannot begin/end transactions in PL/pgSQL

I am seeking clarification of how to ensure an atomic transaction in a plpgsql function, and where the isolation level …

transactions runtime-error plpgsql postgresql-9.2 read-committed
Node.js mysql transaction

Can anyone provide an example of how I could achieve MySQL transactions in Node.js. I am trying to get …

mysql node.js transactions express node-mysql
What is the 'best' way to do distributed transactions across multiple databases using Spring and Hibernate

I have an application - more like a utility - that sits in a corner and updates two different databases …

java hibernate spring transactions xa
MySQL AUTO_INCREMENT does not ROLLBACK

I'm using MySQL's AUTO_INCREMENT field and InnoDB to support transactions. I noticed when I rollback the transaction, the AUTO_…

mysql transactions innodb auto-increment
now() default values are all showing same timestamp

I have created my tables with a column (type: timestamp with timezone) and set its default value to now() (current_…

postgresql transactions timestamp postgresql-9.1
SAVE TRANSACTION vs BEGIN TRANSACTION (SQL Server) how to nest transactions nicely

I have a stored procedure that needs to set a save point so that it can, under certain circumstances, undo …

sql-server transactions nested-transactions