ReadMeFeed / Community knowledge

#transaction-management

Real questions. Useful conversations. Find the people who know your stack.

Question1 answer1 comment2,218 followingPosted 24 Feb 2020, 09:45 UTC33.6K views1,601 votes

ORA-01013: SQL Developer does not automatically rollback after query cancellation

Problem Statement When a long‑running query is stopped in Oracle SQL Developer via the worksheet stop button, the database returns the ORA‑01013 error. However, the transaction that was in progress remains active, holding locks until a manual COMMIT or ROLLBACK is issued. Context and Constraints SQL Developer does not expose a UI setting to automatically rol

Community & Careers · Editorial question

Community & Careers

Question1 answer511 followingPosted 01 Jan 2020, 07:04 UTC94.7K views2,119 votes

owner answered

Azure SQL Database 2022: Query Timeout Enforcement Across Multi-Statement Batches and Distributed Transactions

Scope Understanding how client-configured query timeouts and explicit cancellation calls propagate through Azure SQL Database when a workload spans multiple statements in a single batch or participates in a distributed transaction. Constraints and Uncertainty Documentation indicates that a client-side timeout (for example, CommandTimeout or setQueryTimeout )

Community & Careers · Editorial question

cancellation azure-sql-database

azuresqldatabase