Stack Overflow
Stack Overflow

Questions tagged [nested-transactions]

43 questions
0
votes
1 answer

Nested UI requiring nested transactions in ActiveRecord

I have a dialog D1 which edits model type M1, and another dialog D2 which edits model type M2. One of the things that M2 contains is a reference to an M1, and so as a convenience to the user D2 contains a button that launches D1, in addition to…
Miral
  • 12,637
  • 4
  • 53
  • 93
0
votes
1 answer

Hibernate REQUIRES_NEW or NESTED not working with MariaDB InnoDB

I have a potentially long-running transaction in JBoss-EAP 7.2.6 where I need to commit in several steps. I understand that MariaDB has no nested, but chained transactions. This is my idea of how this should work: public class MyEntityManager…
Daniel
  • 521
  • 1
  • 4
  • 13
0
votes
1 answer

SQL Server mismatching number of BEGIN and COMMIT statements nested transaction

I followed a recommended template for error handling in a transaction that should work when it's executed inside an existing transaction. This is my template CREATE PROCEDURE DoSomething AS BEGIN SET NOCOUNT ON DECLARE @trans INTEGER =…
Skere
  • 383
  • 2
  • 15
0
votes
0 answers

How to know which record fails in a Postgres bulk update transaction

The problem I have to update several records R1, R2, ..., Rn in a Postgres database using sqlalchemy. The operation has to be atomic; i.e., if Ri fails the whole transaction has to be rolled back. The code is something like this: try: for…
Cartucho
  • 3,257
  • 2
  • 30
  • 55
0
votes
0 answers

Nested sql transaction in .Net

I have two methods which start sql transaction and commit (or rollback) the connection inside the method. public void Method1(SqlConnection connection) { var trans = connection.BeginTransaction(); // do some work trans.Commit(); // or…
developer
  • 1,401
  • 4
  • 28
  • 73
0
votes
2 answers

What to do when neither TransactionScope nor nested transactions are supported?

TransactionScope is an amazing feature but too few providers do implement it correctly. I don't want to pass the connection as parameter.
Eduardo
  • 5,645
  • 4
  • 49
  • 57
0
votes
2 answers

grails nested transaction bean reset

I'm using grails 1.3.7 together with Oracle 11g and trying to manage inner transactions. I have a bean Person that is passed to a transactional (Propagation.REQUIRED) service method who makes some modification. Then it is passed to another…
albe
  • 1
0
votes
1 answer

An error occured while executing query with nested transactions

I encountered an error while trying to execute the query below. if exists (select null from sys.sysobjects where type='P' and name = 'myProc') drop PROCEDURE myProc go create procedure myProc as begin set nocount on set xact_abort on …
zagrr
  • 1
  • 2
0
votes
1 answer

Hibernate nested transactions / sessions and proxy associations

I am using hibernate 4 and spring-aop to handle transactions so that there is always an open transaction on the server side. I want to create a nested transaction to work on it in isolation but I get an error: Illegal attempt to associate a proxy…
Martins
  • 1,231
  • 2
  • 14
  • 17
0
votes
1 answer

Is it required to start MSDTC service on database server along with web server? Also should it be running on mirroring server too?

My project supports nested transactions and thus we have MSDTC service running on web server as well as on database server. The project is working fine. However, we have database mirroring established over database server and thus whenever fail-over…
Mahesh Padekar
  • 49
  • 6
0
votes
0 answers

Do we need nested database transactions?

I'm coding my own data layer using JDBC for accessing SQL databases and one of the main components is the transaction manager. I'm a little bit confused whether or not to support the nested transactions in this component. A sample code of a nested…
ovunccetin
  • 8,443
  • 5
  • 42
  • 53
0
votes
1 answer

Nested transaction scope .net

I'm using SQL Server 2008 R2 and trying to use transactions. First a question about transactions in .net and SQL Server. If I have something like this try { var transactionOption = new TransactionOptions(); transactionOption.IsolationLevel =…
Hamza Ahmed
  • 1,571
  • 4
  • 18
  • 35
0
votes
1 answer

how to manage nested transaction with try catch

--Drop Table Tab1 Begin Transaction TR1; Save Transaction TR1; Create Table Tab1(f1 decimal(10,0)); Begin Transaction TR2 Save Transaction TR2 insert into Tab1 values(1); Begin Transaction TR3; Save Transaction…
Haider Ali Wajihi
  • 2,756
  • 7
  • 51
  • 82
1 2
3