Resolved Issue with JDBC PreparedStatement.cancel() Failing to Terminate Queries
Details
| Detail name | Value |
|---|---|
| Changelog Number | 25986 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0 |
| Fix Versions | JDBC 25.2.6 |
| Resolution Date | 2025-12-23 |
Description
The JDBC PreparedStatement.cancel() method is supposed to cancel the execution of a running SQL query initiated using a PreparedStatement. However, it currently fails to terminate the query as expected, leaving the operation running indefinitely or until the database finishes executing the query.
Workaround
Currently, there is no workaround available to effectively stop a running SQL query initiated via a PreparedStatement. The PreparedStatement.cancel() method does not terminate the query as intended.
Fix
This issue has been resolved, and the PreparedStatement.cancel() method now properly cancels the execution of a running SQL query.
