Java program batch operation data report error: ora-01013: the user requests to cancel the current operation

Alibaba cloud Q & A 2022-02-13 09:17:27 阅读数:436

java program batch operation data

Java Program batch operation data report error :ORA-01013: The user requested to cancel the current operation : image.png

Take the answer 1:

It may be that the caller threw an exception after requesting the timeout of database operation and returned , This means canceling the operation ; Should check SQL Is there a performance problem , It can be analyzed in combination with the explanation plan

Take the answer 2:

Hello! ,java.sql.SQLTimeoutException: ORA-01013: The user requested to cancel the current operation ORA-01013. General possible causes :oracle The watch is locked , Led to sql Statement has been running Unable to commit transaction . Common solutions : Commit transactions in data , Or roll back . such as : After data execution update or for update operation , Not submitted .

copyright:author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.