Questions tagged [rollback]

A rollback is reverting data to a previous state. Typically questions in this tag involve transactions in Relational Database Management Systems, where a ROLLBACK command is used to discard any changes to the data since a transaction started.

1545 questions
0
votes
1 answer

How to rollback the data in mysql server

How to roll back old database after importing new script in it. I have imported a script over my existing database. Now I want to rollback my latest import and want to get the previous database as such. Is there any possibility to get my previous…
R J.
  • 1,522
  • 10
  • 25
  • 40
0
votes
1 answer

Rollback an object properties to their initial state

I have a grid that is displaying some data, each row corresponding to an object (Dataset being: IEnumerable MyObject). The user is able to update the data but would also like to give him the possibility to undo these changes. I was going to…
goul
  • 813
  • 1
  • 13
  • 32
0
votes
1 answer

Script design many-to-many insertion with partial rollback

I am trying to understand partial roll backs, in TSQL. Following a tutorial i found this example but I do not understand / find can you save to a table the second object if the first fails? BEGIN TRAN PRINT 'First Transaction: ' +…
Bogdan M.
  • 2,161
  • 6
  • 31
  • 53
0
votes
2 answers

Pass OracleTransaction value to new form

I have some stored Procedures on one form and at the end I do not commit or rollback. A new form loads and a question prompts the user "Are there any other products in the box?" When the user clicks YES the transaction must rollback. When NO the…
Werner van den Heever
  • 745
  • 6
  • 17
  • 40
0
votes
2 answers

SQL Rollback a Commit from Multiple Stored procedure inserts

I have C# code (wcf) connects to a DB and inserts an entire "report" including address table, person table, etc. which all must be done by calling stored procedures. On a side note, some stored procedures may be called multiple times (as we may have…
Kairan
  • 5,342
  • 27
  • 65
  • 104
0
votes
1 answer

git "local changes checked into the index but not commited"

I edited files on home desktop and pushed to bitbucket.org as well as uploading to my test website. I then pulled from bitbucket.org to my laptop. It told me I needed to merge files but I did not know how so I copied files from test website into…
firemankurt
  • 97
  • 3
  • 12
0
votes
3 answers

Dealing with RollbackException in Java

Is there any way to "replay" transaction? I mean, sometimes I get RollbackException and rollback the transaction. Can I then "clone" the transaction and try again, or once rollback is called, transaction is lost? I really need the changes, and…
Udi
  • 1,080
  • 1
  • 12
  • 25
0
votes
1 answer

In SVN, how to roll back to previous revision instead of merge

I have seen other similar post and answers. But my situation is more restricted as following: Branch repo/A has child branches repo/B and repo/C. C pushed/merged new foo.c to A. Then B pull/merged to get foo.c then pushed/merged other changes. Let's…
Linghua Jin
  • 570
  • 2
  • 6
  • 22
0
votes
1 answer

data inserted into db after spring transaction rollback

I'm testing my declartive transaction configuration with following testcase: I try to insert 2 record into a table with 4 columns(id, content, position, time) while position is a UNIQUE index. I use mysql 5.5 with innoDB engine, and develop the test…
Snowwolf
  • 138
  • 2
  • 11
0
votes
2 answers

Transaction in mysql

I am working on a c# application with Mysql database(version 5.5). I am facing an issue where I need to catch an exception occurred in Mysql. It doesn't matter whether it is caught in Mysql or in dotNet. The problem is that I want to rollback all my…
vaibhav
  • 1,028
  • 12
  • 31
0
votes
2 answers

linq to sql submitchanges rollback

is there a way to roll back after a db.submitchanges without de need of transactions? It would be a shame having to run a service special for loggings. Is there an alternative to roll back and not to use that special service? thanks in…
user1122844
  • 87
  • 4
  • 13
0
votes
1 answer

C# Nested transaction in a loop, but rolling back if any of them fail

The issue i'm trying to solve is as follows: I have a process that ingests data from a file and inserts certain things in multiple tables, as it is now it is all done with one transaction, however with very large data sets the rollback or the commit…
A.D
  • 31
  • 1
  • 5
0
votes
1 answer

Delayed rollback (ado.net) not working

I wish to do some sort of delayed rollback (not in batch) in sample c# desktop app 1 button inserts the data, the other rolls it back I tried the following but it is not working error: The ROLLBACK TRANSACTION request has no corresponding BEGIN…
AngelicCore
  • 1,413
  • 3
  • 22
  • 40
0
votes
1 answer

Rollback with catched RuntimeException

I clearly need some help about transaction roll back. I'm working on a Spring/JPA/Hibernate application. For me, RuntimeException even if they are catched, are rolling back the transaction. I deduce this with some tests (that I can't put here…
DessDess
  • 787
  • 1
  • 6
  • 20
0
votes
1 answer

Hibernate constraint violation/error rolling back

I have encountered a strange error with hibernate, most likely due to improper use of it, but I was wondering if there is any way to find the root cause of it and perhaps remedy it. Currently I have a class hierarchy that looks…