Top "Transactions" questions

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

When to use SELECT ... FOR UPDATE?

Please help me understand the use-case behind SELECT ... FOR UPDATE. Question 1: Is the following a good example of when SELECT ... …

mysql sql sql-server transactions select-for-update
What is a database transaction?

Can someone provide a straightforward (but not simpler than possible) explanation of a transaction as applied to computing (even if …

database concurrency transactions theory failover
What is the difference between Non-Repeatable Read and Phantom Read?

What is the difference between non-repeatable read and phantom read? I have read the Isolation (database systems) article from Wikipedia, …

database oracle transactions isolation-level transaction-isolation
Android Database Transaction

I have created a database. I want to do the Transaction. SaveCustomer() contains more than one statement to insert records …

android sqlite transactions
How does TransactionScope roll back transactions?

I'm writing an integration test where I will be inserting a number of objects into a database and then checking …

c# .net nhibernate transactions transactionscope
How to enable INNODB in mysql

When I execute a query in MySQL it returns an error saying that InnoDB is not enabled. When I clicked …

mysql sql transactions innodb
How to start a transaction in JDBC?

Connection.setTransactionIsolation(int) warns: Note: If this method is called during a transaction, the result is implementation-defined. This bring up …

java jdbc transactions
Why do I need Transaction in Hibernate for read-only operations?

Why do I need Transaction in Hibernate for read-only operations? Does the following transaction put a lock in the DB? …

java database hibernate transactions database-connection
@EnableTransactionManagement in Spring Boot

Is @EnableTransactionManagement required in Spring Boot? I did some research. Some folks say you don't need it, as Spring Boot …

spring-boot transactions
JBoss transaction timeout setting?

We have a timer service triggered task in JBoss 5.1.0.GA application and the problem is that we cannot change the …

jboss timeout ejb-3.0 transactions jboss5.x