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
3 answers

Ways to rollback a "soft" transaction in Java

When I say "soft" transaction I mean something which doesn't involve persistence in some DB but just logical object modifications. Here's the story. Plain JAVA application, no frameworks, possibly lots of threads. Object Ob, in his separate thread,…
Ema
  • 104
  • 11
0
votes
1 answer

Limit or abort a Sql Server transaction initiated by Asp.Net

Goal: to limit the duration of a Sql Server transaction that was initiated on an Asp.Net web page. A transaction is more than a single command, so SqlCommand.CommandTimeout is not strong enough. Scenario: an Asp.Net page does something like…
Nick
  • 21
  • 1
  • 4
0
votes
1 answer

How to view my last transaction in Oracle?

I updated only one column in the table. Now I must update it to the previous value. How can I view the previous value? I disconnected from the session and now dba_2pc_pending returned 0 rows.
0
votes
2 answers

Subversion merge fails with "Entry for ... has no URL"

I'm trying to roll back a range of commits. Say my working copy is revision 10, and I'm wanting to roll back all changes made in revisions 4 through 7. I'm attempting to do so with: svn merge -r 7:4 . This fails with: svn: Entry for 'library'…
Madbreaks
  • 19,094
  • 7
  • 58
  • 72
0
votes
1 answer

C# Insert all rows or none?

I have done simple My sql transactions. But Is there a way to make transactions through c# ? Example: Insert all rows from a file or never insert anything. Are there any examples or directions for doing this in c#? I have only done single query…
Dexters
  • 2,419
  • 6
  • 37
  • 57
0
votes
2 answers

How to rollback impdp in oracle11g

I have the task to import oracle database (big data) with the command impdp. I have to migrate big data which take a long time. Is there a way to rollback the database when during the import job has been interrupted? Thanks
0
votes
1 answer

Nested TransactionScope Rollback - Is it possible?

I am trying to wrap two TransactionScopes within another TransactionScope, but when I run the program and an error is triggered in the 2nd transaction scope, the 1st transaction is not rolled back. Is it possible to rollback both, or am I better off…
0
votes
1 answer

NullPointerException while adding data to the database from online page

I am getting a NullPointerException Exception while adding data from the online JSP page. The error description is as follows: javax.transaction.TransactionRolledbackException: CORBA TRANSACTION_ROLLEDBACK 0x0 No; nested exception…
manoja swaro
0
votes
1 answer

Rails - Transactions and Rollbacks

I am trying to get transactions to work because I need to save the @event so I can assign the given @event.id to its dependents. I have raise ActiveRecord::Rollback, but it doesn't do anything. I know it hits it too because it displays the…
user1977840
0
votes
1 answer

Yii add action on transaction rollback

Is there a way to add an action to a CDbConnection when rollback action is called ? I have this code and it works : $transaction = $model->dbConnection->beginTransaction(); try { //... //doing some manipulations //... …
Philippe Boissonneault
  • 3,949
  • 3
  • 26
  • 33
0
votes
3 answers

Custom Installer class , rollback method never called

I am having an installer class , Here is a snippet: [RunInstaller(true)] public partial class ServerWrapInstaller : Installer { public override void Install(IDictionary stateSaver) { EventLog.WriteEntry("Installer", "Install",…
user88637
  • 11,790
  • 9
  • 37
  • 36
0
votes
2 answers

Grails validate in service causes silent rollback

In a Grails service, I create/update domain entities based on an external list. Updates take place in a loop. If the line in the input file is valid, entities are updated. Otherwise, I store the faulty line number and process the next one. Problem:…
youri
  • 3,685
  • 5
  • 23
  • 43
0
votes
1 answer

JDBC Savepoints doesn't rollback

I'm using JDBC but I got some problems with rollback and savepoint. I can't understand why this code actually doesn't rollback to the savepoint and the record inserted remains. try { conn.setAutoCommit(false); stmt =…
alkz
  • 337
  • 2
  • 7
  • 17
0
votes
1 answer

How To Rollback Transactions From Windows Application

I am working on a Windows application (WinForms) that requires four different processes to run (stored procedures) that include the ability to commit or rollback the entire process in the instance that any of the four processes raised an error. …
clockwiseq
  • 4,189
  • 9
  • 38
  • 61
0
votes
0 answers

Is it possible to re-raise an ActiveRecord::Rollback exception from inside a transaction block?

In my rails app, I have a transaction block in a controller's create action in which I attempt to create two records. def create ActiveRecord::Base.transaction do @foo = Foo.new(params[:foo].except(:bar)) raise ActiveRecord::Rollback…
glevine
  • 697
  • 1
  • 7
  • 19
1 2 3
99
100