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.
Questions tagged [rollback]
1545 questions
7
votes
2 answers
TransactionScope does not rollback inside wcf service method, does roll back if called directly
I am facing a problem that drives me crazy for couple of days now, hoping someone can help me.
Here it is ;
I'm using EF4 with oracle database, using dotConnect for oracle from devart as provider.
I have wcf service method which calls DeleteCabinet…
rayback2
- 81
- 5
7
votes
3 answers
Rollback committed data
Can committed data be rolled back in oracle? If yes then how can we do this.
Please help.
facebook
- 1,894
- 3
- 21
- 28
7
votes
1 answer
Capistrano deploy:assets:restore_manifest Rails assets manifest file (or backup file) not found
TLDR;
I have been deploying with Capistrano for over a year and able to rollback and now all of a sudden I cannot rollback saying it cannot find the rake asset file
Problem
Capistrano Rollback is failing complaining that it cannot find the rake…
gwnp
- 1,127
- 1
- 10
- 35
7
votes
1 answer
I cannot catch exceptions in method annotated @Transactional
I cannot catch exceptions in method annotated @Transactional.
I want to send mail to created user if save operation succeded.
When username is already in use PostgreSQL throws exception PSQLException which is extention of SQLExcpetion which is…
user
- 4,410
- 16
- 57
- 83
7
votes
1 answer
Liquibase - Multi-line SQL rollback using rollbackSplitStatements and rollbackEndDelimiter
In 3.5.2 rollbackSplitStatements and rollbackEndDelimiter were introduced to allow us to write our rollback statements in multiple lines and not have to tag every line with "--rollback" or at least I am assuming that from the PR…
user3006906
- 71
- 1
- 3
7
votes
1 answer
NHibernate 3 session state after rollback()
I have a problem.
using (var tran = repository.Session.BeginTransaction())
{
try
{
repository.Save(entity);
tran.Comit();
}
catch(Exception)
{
tran.Rollback();
throw;
}
}
using (var tran =…
Luka
- 4,075
- 3
- 35
- 61
7
votes
1 answer
How to rollback a specific migration in Cakephp?
I am working on migrations in Cakephp3, I want to rollback a specific migration, I know how to rollback a previous migration by using the follow way:
bin/cake migrations rollback
But I couldn't find a way to rollback a specific migration.
Note: I…
Amrinder Singh
- 5,300
- 12
- 46
- 88
7
votes
5 answers
SQL Server 2008 Transaction, rollback required?
I have a stored procedure that has a BEGIN TRANSACTION and COMMIT TRANSACTION statement. Within the transaction is a select query WITH(XLOCK, ROWLOCK).
The transaction can potentially fail due to some calculations that cause an arithmetic overflow…
TJF
- 2,248
- 4
- 28
- 43
7
votes
4 answers
How can I implement commit/rollback for MySQL in PHP?
Well basically I have this script that takes a long time to execute and occasionally times out and leaves semi-complete data floating around my database. (Yes I know in a perfect world I would fix THAT instead of implementing commits and rollbacks…
Andrew G. Johnson
- 26,603
- 30
- 91
- 135
7
votes
2 answers
PHP & mySQL: Simple code to implement Transaction - Commit & Rollback
MY PLATFORM:
PHP & mySQL
MY SITUATION:
I am trying to implement transactions within my code. I tried to follow examples, but it's not much help. I am running 3 queries and I wanted to write a transaction in such a way so that if any of the…
Devner
- 6,825
- 11
- 63
- 104
7
votes
6 answers
How implement Rollback feature?
I want to create a C# application in which copy some files in two diffrent folders(already contains older version files) and also run sql scripts. During whole process if any exception generate i need to rollback all the changes.
For sql scripts,…
Nakul Chaudhary
- 25,572
- 15
- 44
- 47
7
votes
4 answers
How will this affect the data using Loops with rollback transaction
While @@Fetch_Status = 0
Begin
INSERT INTO [server].MyDatabase.dbo.Mytabletobeinserted (
UPC,
Sale_date)
VALUES(
@UPC,
@Sale_date)
'Inserting the error trapping here'
IF (@@ERROR <> 0)
BEGIN
ROLLBACK…
Androidz
- 413
- 1
- 6
- 19
7
votes
1 answer
How to perform SQL Roll back from transaction logs
I have transaction log file that goes back 6 months. I need to roll back everything that happened after 5/20/2013 from a database. Can anyone please enlighten me on how to do this?
torres
- 1,283
- 8
- 21
- 30
7
votes
2 answers
spring hibernate manual commit
can somebody help for this?
currently i met some problems, i am using spring,jpa,hibernate.
here is the problem, when i try to save several objects, and then manually roll back as when solrj return false.
i tried the following:
1. usertransaction…
Stupidfrog
- 2,042
- 6
- 25
- 35
7
votes
2 answers
Oracle 11 - sqlplus - rollback the whole script on error - how?
How can I make Oracle 11g rollback the whole transaction on any error in included SQL file?
The file contents are:
set autocommit off
whenever SQLERROR EXIT ROLLBACK
insert into a values (1);
insert into a values (2);
drop index…
Grzegorz
- 504
- 1
- 3
- 14