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
6
votes
3 answers
Manual Rollback of transactions in Seam
This is a similar problem to Forcing a transaction to rollback on validation error
The scenario is this:
A user edits a page, the transaction is set to MANUAL so only if we call flush it would be committed to the database. Now the user wants to…
Ben
- 1,922
- 3
- 23
- 37
6
votes
1 answer
Spring integration test does not roll back
I'm using Spring + Hibernate + H2. I do database operations in my integration tests (by calling a service class). I want Spring to rollback the changes after each test method, but I can't get it to work. At first I used MySQL (with MyISAM, which…
martin
- 2,150
- 1
- 34
- 48
6
votes
2 answers
How to undo ALTER TABLE using sqlplus (Oracle 10g Express)?
rollback;
doesn't seem to undo alter table changes.
Background:
I'm generating some .sql scripts (based on parsed Hibernate scripts) which are trashing my tables. Importing the full database for testing takes up to 30 minutes (also slowing my…
glenneroo
- 1,908
- 5
- 30
- 49
6
votes
2 answers
No rollback only for transaction when exception occurs in submethod
I'm using Hibernate + spring + @Transactional annotations to handle transactions in my application.
Transaction manager is declared as follows:
…
Ondrej Skalicka
- 3,046
- 9
- 32
- 53
6
votes
5 answers
Micronaut and JUnit rollback
I have some tests written for a micronaut micro service. I would want that after my tests are done all the changes in the DB are reverted (rollback). Firstly I have written a simple example which seems to work. Changes are reverted. But when I run a…
Jacob
- 3,580
- 22
- 82
- 146
6
votes
1 answer
Transactions in MySQL - Unable to Roll Back
I'm using MySQL 5.0.27 and am trying to get transactions to work. I followed this tutorial:
http://dev.mysql.com/doc/refman/5.0/es/connector-net-examples-mysqltransaction.html
and still cannot get these to work. The table I am trying to update is…
Austin
- 1,521
- 5
- 15
- 27
6
votes
4 answers
Unable to downgrade Angular from version 6 to 5
Recently (May 2018) newer stable version of angular has been released.
I have migrated succesfully from version 5 to 6.
But for some reason I wanted to rollback to version 5. I have tried following commands:
npm uninstall -g @angular/cli
it…
Suresh Karia
- 17,550
- 18
- 67
- 85
6
votes
2 answers
Transactions are not getting rollbacked with HikariCP
I am using HikariCP for connection pooling. I have tried setting autoCommit to both true and false. Still my transactions are not getting
rollbacked when an exception occur.
I have tried the same with org.apache.commons.dbcp.BasicDataSource.…
Abhishek Ramachandran
- 1,160
- 1
- 13
- 34
6
votes
2 answers
Best practice to 'rollback' REST method calls inside method
The title might be incorrect, but I will try to explain my issue. My project is a Spring Boot project. I have services which do calls to external REST endpoints.
I have a service method which contains several method calls to other services I have.…
tjeerdnet
- 344
- 1
- 6
- 14
6
votes
2 answers
Going back to a previous commit in Gitkraken
My programming partner and I, being fairly new to Git and Gitkraken, made some mistakes, did some pushes pulls and commits in the wrong order, and got things fairly bungled up. I would like to go get a snapshot from several commits back, and…
Joymaker
- 813
- 1
- 9
- 23
6
votes
5 answers
Best way to create a SQL Server rollback script?
I am working on some schema changes to an existing database.
I backed up the database to get a dev copy, and have made my changes. I will be creating a single roll script to migrate the changes on the production machine in a single transaction.
Is…
FlySwat
- 172,459
- 74
- 246
- 311
6
votes
1 answer
migration not rolling back
I had run this migration:
class AddUniqueToLocationColumnName < ActiveRecord::Migration
def change
remove_index :locations, :name
add_index :locations, :name, unique: true
end
end
And now I am trying to rollback but its showing…
abhishek
- 301
- 2
- 7
- 18
6
votes
0 answers
How to manage transactions in Apache Spark?
I want to use spark sql for data persistent, Can I rollback transaction in spark if transaction failed in between?
E.g. Lets say we have 3 tables t1, t2 and t3. t1 and t2 table data is persisted successfully but some how t3 failed in data integrity…
Sandeep Mandori
- 138
- 8
6
votes
3 answers
If I use a context manager with a pyodbc cursor, will it rollback on an error?
I tried reading the pyodbc source, but it is all C++ code (I'm not competent in C++). I need to know the behavior of a statement like:
with connection.cursor() as cursor:
cursor.execute(query_1) #inserts some stuff into table A
…
Andrew
- 6,295
- 11
- 56
- 95
6
votes
3 answers
get mvn release:rollback to delete tag in GIT
I have a maven project which is stored in our GIT repository. When I make a release of this project with mvn release:prepare and mvn release:perform sometimes it fails in the later step but a tag is created for this release anyway. This tag doesn't…
Pearl Jade
- 716
- 1
- 8
- 22