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
0
votes
0 answers
How do I handle a transactional scope in this situation?
I haven't worked much with transaction scoping and I want to make sure that I'm approaching this idea correctly before I jump in too deeply.
The Setup / Goal
I have a list of items that are files to be copied to a remote system.
For each file in…
SeanKilleen
- 8,809
- 17
- 80
- 133
0
votes
4 answers
Continuous Delivery Scenario - implementing Rollback
Imagine I have a vanilla continuous delivery scenario with a Java webapp.
This scenario has:
- one build server running cruisecontrol
- one web server running Tomcat with tomcat manager running
One of the Ant build targets running on the build…
hawkeye
- 34,745
- 30
- 150
- 304
0
votes
1 answer
core data failure in iOS
Im developing a iphone app and for DB im using core data. While saving the core data works properly.
But once in a while, the saving fails. This cause duplicate records in my app. I have 2 tables
Parent table
Child table
When child table fails…
cancerian
- 942
- 1
- 10
- 18
0
votes
0 answers
how to roll back svn with externals
I'm trying to roll back a subversion repository, that I've made a few errors in.
I would like to roll back the entire repository to a 'good version'.
The normal method to do this is:
svn merge -rHEAD: .
svn commit -m 'roll back to
will
- 71
- 6
0
votes
0 answers
HOWTO: Rollback on Oracle (ODP.NET) and SqlCe bulk operation failure
I would like to know how to:
1) rollback an oracle (odp.net) and sqlce bulk operation (insert, update, delete) if it has failed for some reason. I do not know If bulk operations (oracle and sqlce) do rollback automatically internally on any…
Willy
- 9,848
- 22
- 141
- 284
0
votes
1 answer
How to get hibernate failed transaction details
I'm writing a script to load records from a file in to a mysql DB using hibernate. I'm processing records in batches of 1000 using Transactions, an insert would fail if the record already exists in the DB, which would essentially make entire…
Aryan
- 61
- 2
- 7
0
votes
1 answer
How can I add MySQL transaction in a PDO class?
I have a PDO class that I created the help me connect and communicate with MySQL server.
What I am trying to do add a function or a method to the class that will help me open a transaction to MySQL along with commit and rollback. I never used commit…
Jaylen
- 39,043
- 40
- 128
- 221
0
votes
1 answer
Hibernate 4 + Spring 3.2 + Transaction Manager + No Roll Back in Mysql
I need some help. I'm have a problem with a transaction with hibernate and spring.
I'm trying to fill up a File table in mysql. My first insert works great, the second doesn't work (but it's normal...). But data from the frist insert are still…
ZheFrench
- 1,164
- 3
- 22
- 46
0
votes
1 answer
how to rollback committed data in sql server 2005
by mistake i have updated my table without any condition like update mytable set status = 1 and all row of my table got updated.
Can committed data be rolled back in SQL Server? If yes then how can we do this. Please help.
Vijay
- 8,131
- 11
- 43
- 69
0
votes
1 answer
Rollback in Ironpython using System.Data.SqlClient
I am unable to rollback using the following code snippet and need help:
import clr
import sys
clr.AddReference('System.Data')
from System.Data.SqlClient import SqlConnection, SqlParameter, SqlTransaction
conn_string = "****"
connection =…
user177215
- 249
- 2
- 5
- 11
0
votes
1 answer
How to make checkpoints in a message passing system?
In a message passing/distributed systems, we do checkpoints based on synchronized clock, where we store the state of the process.
Now i want to know, how can we do this practically?
Say, my system deals with request /response client server system.…
Ratha
- 9,434
- 17
- 85
- 163
0
votes
1 answer
Datamapper transaction doesn't rollback
I have such code:
Vhost.transaction do
domains.each do |domain|
unless domain.save
errors << domain.errors
end
end
unless vhost.save
errors << vhost.errors
end
end
I expect a rollback if any domain.save or vhost.save…
ciembor
- 7,189
- 13
- 59
- 100
0
votes
1 answer
Does the MySQL workbench show uncommitted changes?
Why does the MySQL workbench show uncommitted changes?
-- create a new empty table
DROP TABLE IF EXISTS X;
CREATE TABLE X (val varchar(10));
-- disable autocommit
SET AUTOCOMMIT = 0;
-- insert a row without committing
INSERT INTO X (val) VALUES…
nrainer
- 2,542
- 2
- 23
- 35
0
votes
1 answer
Transaction rollback on connection failure or timeout
This question is asked by Navaneeth Adruguli on Link Of form
The question is:
In SQL server how transaction rollback will work? If i have a huge number of updates in a transaction and during update connection failure or connection timeout occurs…
harry34
- 135
- 1
- 2
- 11
0
votes
2 answers
Recover from SQL batch-abort errors inside a transaction? Alternative?
I'm looking for a way to continue execution of a transaction despite errors while inserting low-priority data. It seems like real nested transaction could be a solution, but they aren't supported by SQL Server 2005/2008. Another solution would be to…
Djof
- 603
- 1
- 7
- 20