Top "Transactions" questions

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

Stored Procedure Transaction

I have never used a Transaction, Commit and Rollback before and now I need to use one. I have checked …

sql-server stored-procedures transactions commit rollback
PHP-MySQL-How to safely increment MySQL integer field?

I want to increment a field value safely using php and mysql. What type of table/field must I use? …

php mysql transactions counter
Difference between Implicit and Explicit Transaction

What is the difference between Implicit and Explicit transaction in Sql Server 2008? What happens in TransactionScope background? I'm using TransactionScope …

sql-server-2005 sql-server-2008 c#-4.0 transactions transactionscope
how to convert data.frame to transactions for arules

I read data from a csv file, the data has 3 columns, one is transaction id, the other two are product …

r transactions attributes arules
Automatic Rollback if COMMIT TRANSACTION is not reached

Consider the following: START TRANSACTION; BEGIN; INSERT INTO prp_property1 (module_name,environment_name,NAME,VALUE) VALUES ('','production','',…

mysql transactions rollback
Where should "@Transactional" be place Service Layer or DAO

Firstly it is possible that I am asking something that has been asked and answered before but I could not …

spring transactions dao
Do DDL statements always give you an implicit commit, or can you get an implicit rollback?

If you're halfway through a transaction and perform a DDL statement, such as truncating a table, then the transaction commits. …

sql oracle transactions ddl
Differences between requires_new and nested propagation in Spring transactions

I can't understand the behavior difference between the PROPAGATION_REQUIRES_NEW and PROPAGATION_NESTED propagation policies. It seems to me …

java spring transactions propagation
How to configure transaction management for working with 2 different db in Spring?

I have 2 databases (MySql and HSQLDB). I configured 2 data sources and 2 EntityManagerFactory beans. I can also configure 2 correspondent JpaTransactionManager beans. …

java spring jpa transactions multiple-databases
Django: How can I protect against concurrent modification of database entries

If there a way to protect against concurrent modifications of the same data base entry by two or more users? …

django django-models concurrency transactions atomic