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
1 answer
Do I need to call a rollback() method when a commit() has thrown an exception in Spring programmatic transactions?
I have one jUnit test where I test if my Entity - a Musician must have unique name and I am checking if it is declined by the DB as intended. I have decided to manage my transactions in Spring manually to better understand what is going on and not…
Xenon
- 189
- 1
- 1
- 14
0
votes
3 answers
SSIS - not truncate if it fails
Currently I have an Excel file that I load into a table every night. To do this, I make a TRUNCATE of the table and then I have a data flow in which I load the data from the Excel file to my table.
In the case the loading fails, I would like not…
user3640552
- 1
- 3
0
votes
1 answer
How to roll back to previous Entity Framework
Recently I've just updated my Entity Framework in my project from 4.0 to 6.0, after updating I got almost 300 errors, and now it's a mess. I wish to rollback to the previous point where the Entity Framework was 4.0.
How can I do it with .Net Visual…
f855a864
- 177
- 10
0
votes
0 answers
MQ JMS - messages not getting requeued getting error as MQJMS1080 No Backout-Requeue queue defined
We are using MQ JMS standalone client application (NO app server) to consume WebSphere MQ messages. Our Queue definition is as follows:
APP_QUEUE1 - (QA, PUT enabled)
APP_QUEUE1.CL - (QL and target of above APP_QUEUE1)
APP_QUEUE1_BOQ - (QA and…
mformusic
- 41
- 1
- 5
0
votes
1 answer
Spring Hibernate Transaction Rollback Not Working
I am calling 2 different dao method from service layer.
The second method throw Null Pointer Exception (Column 'address' cannot be null), but the task done from first method couldn't rollback.
Service Layer
package…
Surendra Jnawali
- 3,190
- 5
- 28
- 44
0
votes
0 answers
MYSQL Transaction not rolled back
I have the following stored procedure in Mysql 5.1.73-cll:
BEGIN
DECLARE finished1 INTEGER DEFAULT 0;
DECLARE cursor1 CURSOR FOR SELECT ... FROM table1 WHERE Id= 1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished1 = 1;
DECLARE EXIT…
user1888333
- 1
- 2
0
votes
1 answer
Rollback changes in test after manual interaction with the datasource?
I'm using dbsetup for my db tests. The problem is I can't manage to get data rolled back after each test using the aproach which have always worked which is annotating the test case (or method) with @Transactional annotation. I suppose this happens…
kboom
- 2,279
- 3
- 28
- 43
0
votes
1 answer
Docker - Rollback data in MySQL container after recreating
"With docker images we can keep both the previous image and the new image on an instance at the same time. Since the previous images are still on the instance, rollbacks are just a matter of restarting the container pointing to the previous…
Hans
- 451
- 1
- 6
- 20
0
votes
1 answer
Transaction allow to fail and continue
Im having a problem with a major data migration that can be configured by the user, lets say it goes like this:
try {
daoManager.beginTransaction();
for (Entity node : nodeList) {
boolean inserted;
if…
leomcpugo
- 35
- 8
0
votes
2 answers
Transactions in codeigniter with multiple tables
I'm new to transactions in general, but especially with CodeIgniter. I'm using InnoDB and everything, but my transactions aren't rolling back when I want them to. Here's my code (slightly simplified).
$dog_db =…
Ethan
- 5,660
- 9
- 44
- 51
0
votes
2 answers
Powershell ActiveDirectory Logging and import for easy rollback
Im writing a custom script from start to finish to search for users ,so i can disable and move them. (script is done and working)
What im trying to do now is to create a easy readable log which also has to be used as an easy…
vya
- 57
- 1
- 2
- 7
0
votes
2 answers
SQL transaction always caught
I have 3 delete queries executed by my sql command. The last of the three queries can only execute if there is no reference to it in other tables. It fails to execute if there is a reference. So, if the last delete fails, I want to rollback to not…
starvator
- 989
- 1
- 11
- 26
0
votes
1 answer
Should I try a rollback before beginning a new transaction?
I have a doubt and I can't find a similar question.
In a generic php script like:
$pdo->beginTransaction();
//...
//many things to do...
//...
$pdo->commit();
Let's say the user stops the page loading or loses connection before the commit is…
the_nuts
- 5,634
- 1
- 36
- 68
0
votes
2 answers
Rollback transaction inside cursors and inside transactions
I'm pretty new in T-SQL and I'm in trouble with some huge scripts with transactions, cursors and storage procedures. So, my code is something like this (this code is just an example of the structure of my scripts, in fact I have multiples procedures…
Ninita
- 1,209
- 2
- 19
- 45
0
votes
8 answers
How do I rollback app-engine deployment
I have an Appengine connected android project (eclipse). I am trying to deploy it as I have done countless times. But this time I am getting the following error.
Unable to update app: Error posting to URL:
…
Katedral Pillon
- 14,534
- 25
- 99
- 199