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
Java persist operation causes everytime a rollback in the MySQL DB
I have a problem.
I have this function:
public boolean insertOrgToAlign(OrganizationData orgData) {
try {
if (eManager.find(ScOrgNotAligned.class, orgData.getOrganizationCode()) == null) {
ScAdminGroup rootByOrg =…
sharkbait
- 2,980
- 16
- 51
- 89
0
votes
2 answers
How can you temporarily roll back a single file to a known good state in svn?
I'm currently trying to return a single file to the state of a previous revision in subversion. I don't want to commit the file, just leave it as a modification to the working copy for a bit. How would I do that?
Edit:
It was suggested that I use…
Kzqai
- 22,588
- 25
- 105
- 137
0
votes
2 answers
SQL server Rollback
I created a transaction procedure and it all works except for some reason the rollback keeps displaying its error message and it is not allowing the insert to function properly. So now I am unsure of what I need to do to fix this when I comment out…
user3380392
- 59
- 2
- 8
0
votes
2 answers
Strategy for rolling back an altered table using liquibase
I want to migrate my database from v1.0 to v1.1 and one of the changes is updates on some of the values in Table1. I know that for INSERT, I can easily include a rollback command of deleting the values I just added, but how about a table alteration?…
r051cky
- 115
- 4
0
votes
0 answers
What to do after a failed heroku db:rollback
I'm at the very beginning stages of learning rails using heroku as deployment tool. I ran into a bit of problem today, which is now fixed, but I was wondering if there's a proper/better way to do what I did.
My problem was as follows: I wrote a…
Daniel Sutantyo
- 183
- 1
- 1
- 9
0
votes
1 answer
Recover and Roll back SQL DB State
Friends,
I'm looking for an solution on SQL DB server. I'm being working in support organization on managing SQL Server.
When we make some changes on SQL DB (Schema changes, table alteration, data etc..) and found it is not compatible we need to…
baluchen
- 749
- 3
- 11
- 18
0
votes
2 answers
Rollback transaction multiple query
I have a store procedure like below:
DECLARE @FinalQuery varchar(max), @TableName varchar(200)
DECLARE ListTable CURSOR FOR SELECT....
DECLARE @isError bit=0
OPEN ListTable
FETCH NEXT FROM ListTable INTO @TableName
WHILE @@FETCH_STATUS=0
BEGIN
…
user2500561
- 133
- 1
- 2
- 14
0
votes
2 answers
Is there any way to rollback transactions in SQL Server?
Yesterday I wrote some code module, that wrote wrong data in almost 400 existing records in important database on SQL Server 2008. I didn't make backup of this database (my mistake). So the question is how do I rollback these 400 transactions? Is…
Mervin
- 113
- 2
- 8
0
votes
2 answers
Activiti + spring + transaction + rollback
I want to test the integration of Spring and Activiti, then I stuck with confusing problem. I have a workflow with 2 service task (using jpa repository saveAndFlush method to update database) A and B
In the service A, I actively throw a new…
Thien Dinh
- 373
- 1
- 6
- 15
0
votes
3 answers
Is Rollback necessary in this select for update (no rows returned)?
$stmt = $pdo->prepare("SELECT somedata FROM mytable FOR UPDATE");
$pdo->beginTransaction();
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if ( $row == FALSE ) {
$pdo->rollBack();
} else {
....run some code and then commit
Is the…
Luke Rehmann
- 514
- 5
- 12
0
votes
1 answer
WebSphere 7.0 remote client rollback global UserTransaction
I'm observing weird behavior for WebSphere 7.0.0.21:
Architecture:
Simple EJB bean with annotation @Local, @Remote Interfaces and transactional method marked as @Required
Standalone command line client that looks up remote "jta/usertransaction"…
d3ni5
- 51
- 4
0
votes
1 answer
Exception not cuaght with Entity Manager
I have an Entity Manager in my EJB
@PersistenceContext(unitName = "cnsbEntities")
private EntityManager em;
I populate an object and then I commit it in my DB, but if I have an exception, for duplicate ID, I can't catch it and I don't know why.
…
Bertotz
- 38
- 7
0
votes
2 answers
EJB 3.1 transactions rollback doesn't work
i have the following scenario:
i have a stateless ejb with two method A() and B(). The method B() perform n call to method A() which execute an INSERT operation.
Now, if A() throws an applicationException ( that i have annotated with…
user1645419
- 227
- 2
- 3
- 10
0
votes
1 answer
- Liquibase -
I would like to insert a elements in a . As opposed to having a single . Will this work? Or is the context of a
Chuck Herrick
- 63
- 1
- 9
0
votes
1 answer
Using PDO and transactions, but I dont get error so rollback wont work.
I am trying to create a simple class in php,
db = new…
Cevil
- 215
- 2
- 5
- 15