python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - savepoints

SqlClient equivalent of "BEGIN TRY...END TRY"

We are trying to replicate the functionality of the following SQL, but using SqlClient code in c#. Consider the following SQL: BEGIN TRANSACTION -- lots of critical SQL that must be atomic --...
test-img

David I. McIntosh

c#

transactions

try-catch

sqlclient

savepoints

Votes: 0

Answers: 1

Latest Answer

The information in the link above, provided by @Charlieface, is fairly comprehensive and accurate. The upshot of the information is that one cannot always roll back to a point before the non-critical ...
test-img

David I. McIntosh

Is it possible to rollback only one command (not whole transaction) in SQL?

I know that you do the BEGIN; command, then all commands after that can be rolled back, as long as you haven't executed COMMIT; yet. My question is, is there a command to roll back just one command an...
test-img

an honest observer

sql

postgresql

rollback

savepoints

Votes: 0

Answers: 1

Latest Answer

Read https://www.postgresql.org/docs/14/tutorial-transactions.html about SAVEPOINT and ROLLBACK TO SAVEPOINT.
test-img

Bill Karwin

Flink 1.14 : Why can't resotore savepoint got error Caused by: org.apache.flink.runtime.messages.FlinkJobNotFoundException: Could not find Flink job

I'm trying to restore a savepoint which is save to my local tmp folder.However i got below error when i trying to restore it.Do you have any idea about this ? /home/chinthakasajith/flink-1.14.0$ ./bin...
test-img

Sajith Gunarathna

java

apache-flink

flink-cep

savepoints

Votes: 0

Answers: 1

Latest Answer

That error is thrown by the Job Manager. To find the root cause of this problem, look in the Task Manager logs.
test-img

David Anderson

Posts

Questions

Blogs

Jobs