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
WSO2 data services server distributed transactions can not roll back for different types of database
I am following this guide to test distributed transactions of DSS.
It is OK. The addAccountToBank1 service call rolled back because of the error in addAccountToBank2 operation. In this test, the two operations are both involve H2 DB.
Then I do…
iceguo
- 103
- 1
- 12
0
votes
1 answer
Mysql : select a "rollback" query (visualizing the rollback query)
The state of these two row are set to 1. I want to set them to 0 and visualizing the result of a rollback query .
This query does the job :
START TRANSACTION;
UPDATE jkm_content SET state=0 WHERE title IN ('001','002');
SELECT * FROM jkm_content…
JinSnow
- 1,553
- 4
- 27
- 49
0
votes
1 answer
How to rollback a CREATE TABLESPACE in Oracle 11g?
I executed:
CREATE BIGFILE TABLESPACE tspvr010
datafile 'tspvr010.dbf'
size 120g;
but while that was working, my PC crashed (unexpected shutdown).
When PC start again, the tablespace tspvr010 was not created, and tablespace USERS grow up by 30…
Netheril
- 1
- 1
0
votes
1 answer
Spring @Transaction not rolling back on RuntimeException
I want to support rollback when an exception occurs in my code.
I use junit + datasource in Spring config file for testing and Glassfish 2.1 for the real code (using jndi datasource).
Here a sample of the…
Sebastien Dionne
- 757
- 2
- 19
- 34
0
votes
1 answer
Rolled back but an error persists
Semantics:
I am using PostGreSql 9.0.3 as my Dbms. Actually i was tried to accomplish one of the objectives assigned for me, which is to Raise Exception with some predefined message when some conditions failed in a IF - Statement inside my stored…
Rajaprabhu Aravindasamy
- 66,513
- 17
- 101
- 130
0
votes
2 answers
WMQ Transactions Rollback using .net explicit Transactions not working
I have used .net C# code to put messages on the queue and get messages back. I have no problem in accessing the queue and getting messages. Now I want to have the get message calls under Transaction and used explicit transaction option to commit and…
Aman
- 1
- 3
0
votes
1 answer
java:not able to set auto commit mode with value false in java 1.4 api?
sql server 200
java 1.4
jboss 3
HI am getting exception message
"You cannot set autocommit during a managed transaction"
code is below
try {
try {
connection = getConnection();
} catch…
Maddy.Shik
- 6,609
- 18
- 69
- 98
0
votes
1 answer
How to rollback DB transaction after http connection is lost
Recently at a interview the interviewer asked me a question, below is the question -
Suppose a request is sent to a servlet and the servlet performs several DB transactions(first update and commit, then read and update and again commit) which takes…
Ravi Jain
- 1,452
- 2
- 17
- 41
0
votes
1 answer
PL/SQL Rollback Transaction with multiple package calls
I am new to Oracle PL/SQL and am trying to adjust from SQL Server with C# to a Oracle custom web application using PL/SQL for multiple layers of the application.
I currectly am having issues with rolling back a transaction. Since I am using to…
Laura Ritchey
- 711
- 8
- 20
0
votes
1 answer
Execution flow of SQL Script in c#
This is not a repeated question of rollback sql transactions if any failed in c#. But this question is based on the content of the previous question. Thanks to all who gave their opinion on my last question.I tried all those solutions and could…
vysakh
- 266
- 2
- 4
- 19
0
votes
1 answer
SharedPreferences commit and rollback
Is the following the intended/reasonable way to commit and rollback SharedPreferences, and to use it in general?
public class Settings {
private static final String PREFS_NAME = "Settings";
private static SharedPreferences preferences =…
user2583621
- 165
- 12
0
votes
0 answers
How to check if a @transactional method perform rollback correctly in Grails?
Let's say we have a code like the following (I got the code frome here):
@Transactional
private def unitaryOperationUpdate {
Integer roleId = params.roleSelector.toInteger()
def roleInstance = Role.findById(roleId)
UserRol.removeAll…
chelder
- 3,819
- 6
- 56
- 90
0
votes
1 answer
How to join two unit operations (removeAll + create) into one
There is only a role per user in the application at the same time. To update a role, we previously remove all the current roles:
Integer roleId = params.roleSelector.toInteger()
def roleInstance = Role.findById(roleId)
UserRol.removeAll…
chelder
- 3,819
- 6
- 56
- 90
0
votes
1 answer
nhibernate use_identifier_rollback all-delete-orphan
In NH is a configuration setting 'use_identifier_rollback' which is sets the id of an entity back to its default value.
This settings works with every cascade options except 'delete-orphan'. (And I know why!)
Take a look at C# Identifier…
crip
- 145
- 1
- 8
0
votes
1 answer
rollback transaction associate with more than one session in Spring MVC + Hibernate
I am using Spring MVC + Hibernate , the following is generic method for save ( one - to Many). I use this to insert the record for both table with the same session, if any one table fail, then all operation roll beck because they are associate with…
Shahid Ghafoor
- 2,991
- 17
- 68
- 123