Stack Overflow
Stack Overflow

Questions tagged [rollback]

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.

1545 questions
0
votes
2 answers

MSSQL Transaction never returns error

I have a mssql code which never returns error. Here are the codes: alter proc USP_Havale @GonderenID int, @AliciID int, @GonderilenPara money as begin try begin transaction update Hesap set Para = Para - @GonderilenPara …
Onur
  • 414
  • 1
  • 11
  • 31
0
votes
1 answer

sqlite3 back end DB for django - weird error

So for a project I am querying a bunch of Google Analytics data and storing it into a Sqlit3 database. Right now I am working on a script that retrieves historical data for each day over the course of several months. The Script runs without error…
byates
  • 11
  • 1
0
votes
0 answers

ROLLBACK TRANSACTION ON CURSOR

I'm using SQL Server 2008. In my stored procedure I can't rollback transaction on ELSE condition in WHILE. Error: The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. How to rollback transaction while using cursor? There…
REX SAMSON
  • 7
  • 4
0
votes
0 answers

How to rollback Query on Oracle SQL Developer

I am suck on a major issue. By mistake I executed a bunch of sql files on my QA database. Because of that, application is facing severe issue. So I want to rollback all those scripts. I am using Oracle SQL developer and Oracle 11g. Is it possible in…
Gunjan Shah
  • 5,088
  • 16
  • 53
  • 72
0
votes
1 answer

commit and rollback conflict

I faced one problem in this query execution on Microsoft SQL Server Management Studio CREATE DATABASE myDB USE myDB CREATE TABLE udata(uid INT PRIMARY KEY identity(101, 2), uname VARCHAR(25), unum INT UNIQUE) CREATE TABLE usalary(sid INT…
jabir jazz
  • 187
  • 1
  • 2
  • 10
0
votes
0 answers

PHP Library for implementing transaction aware api calls?

To implement a few of my functionalities, I need to call a set of APIs in order. There are times when one of the APIs in the middle fail. At such times I need to rollback the API calls that have successfully happened before that. Essentially a…
deadbeef
  • 41
  • 4
0
votes
1 answer

Spring @Transational no rollback for jdbctemplate.update(PreparedStatementCreator， KeyHolder）

I'm newbie with spring framework. I used spring.xml to define the datasouce and DataSourceTransactionManager, so that I could insert data with jdbctemplate object. And now I want to add the rollback to the transaction. Unfortunately this rollback…
Ophiuchus Hahn
  • 145
  • 2
  • 12
0
votes
1 answer

Avoid rollback for an insert statement

I have this SQL code that checks for some parameters, if invalid will raise an error, I want also to insert an error record into errors table. the problem is that if error happens the whole transaction will be roll-backed including the error record,…
mmohab
  • 2,303
  • 4
  • 27
  • 43
0
votes
0 answers

Canceling all above operations, something like transaction "rollback", but not only database operations

Something like databases transactions rollback function, but this would work for all above operations, not only database. For example: first query for my database send service to first other server second query for my database send service to…
Oto Shavadze
  • 40,603
  • 55
  • 152
  • 236
0
votes
0 answers

How to Trap Errors in a PHP MySQL Transaction with Rollback

I have a transaction that does an insert into several tables. I want to catch any errors so that if any of the inserts fail they will all be rolled back. Here is a short version of what I am trying to do: try { …
user1633947
  • 149
  • 2
  • 12
0
votes
1 answer

Rollback first of two transactions

Is it possible to make third step in PostgreSQL? Make changes X to DB. Make changes Y to DB that are based on changes X. Rollback changes X. If yes, please describe.
alex23
  • 353
  • 2
  • 13
0
votes
0 answers

Windows rollback driver location information

When we select the rollback option for device driver in windows operating system, generally system takes you back to last installed driver, but if say i have 3 4 drivers installed then how does it go to last one? i.e. it must be storing some…
NxC
  • 320
  • 1
  • 2
  • 16
0
votes
1 answer

Laravel, why do I use rollback

I would like to know when do I need to use the rollback? I understood the rollback is something to revert the DB structure, but (I think) it affects my local DB only. If something is wrong in the structure, then is better to create another migration…
kappa
  • 520
  • 1
  • 5
  • 11
0
votes
2 answers

Transaction commands executing but not reflecting in db c#

The below code is to insert student details and run 3 stored procedures (all on cmd1). I have used transaction and rollback for the same. All 4 executenonquery() are executed but nothing is reflected in the database. Can anyone explain what is…
HMcompfreak
  • 161
  • 2
  • 3
  • 20
0
votes
1 answer

Spring @Transactional wont rollback after putting aspect around method

I have two transactional methods one inside other. When around aspect is not set around methodA Transactional anotation work well. After calling methodA we call methodB, methodB write something in DB, then we return in methodA, throw an exception…
Juka
  • 37
  • 1
  • 9
1 2 3
…
99 100