transactions

I would like to use the TransactionScope class in my business layer: In AdminService class: public void DeleteSchoolclass(Schoolclass schoolclass) {…

Which code is right for transaction? do i need to check query result for commit? this code result nothing mysql_query("BEGIN"); $strSQL = "INSERT…

Last week I finally got around to making my app use transactions. I am using Spring declarative transactions, and I know that the transactions…

Let's say I have a Student and a School table. One operation that I am performing is this: Delete all Students that belong to a School Modify the…

I have a very gerneral question: 1.) Given I have a transaction (in mysql) that comprises the modification of ten-/hundred thousand or even million…

How can i lock empty rows? I want to lock an empty select for example: Session 1 mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql>…

I have a situation where I need to lock 2 tables, until some operations are done on those 2 tables individually. For that I have chosen…

Hallo, I am writing a database application that does alot of inserts and updates with fake serialisable isolation level ( snapshot isolation ). To…

I'm building a website for ordering resources. I have a pool of resources (say 10 resources) and when a user wants to order a resource, I check…

I am trying find out what is postgres can handle safely inside of transaction, but I cannot find the relavant information in the postgres manual .…

Apparently ColdFusion doesn't like multiple SQL statements within a single query... so what once was this: SET @sender_user_id = 3,…

The following simple example seems to work: var conn = new NpgsqlConnection("<connection string>"); conn.Open(); NpgsqlCommand command = new…

My objective here is to read a list of files. The list of files is preselected. I currently am using 4 files of around 5KB each. I read each line of…

I have 2 store procedures A, B, both are in a transaction block. The problems is A calls B, so, there is recursive transaction. I'm not sure is…

How can I tell if the transaction was FALSE or if something else happened(locked table)? $this->db->trans_start();…

I have the following script... START TRANSACTION; INSERT INTO `Image` (`id`,`created`,`deleted`,`fileName`,`used`) VALUES (-114, NULL, NULL,…

MySQL stored procedure will read and update several tables, so I want to make it transactional. I just want to know is it transactional by default?…

How to use the XA transactions inside the transaction scope in C#. What I read from the http://dev.mysql.com/doc/refman/5.0/en/xa-statements.html is…

Hi, I came across a very problematic issue. I'm developing a system of online ordering (events that occur in the real world). user is ordering an…

In postgres manual: "Important: To avoid blocking concurrent transactions that obtain numbers from the same sequence, a nextval operation is never…