[IGNITE-23464] Implement cancellation in JDBC

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: jdbc, sql
• Labels: ignite-3
• Epic Link: Kill Queries
• Assignee: Konstantin Orlov
• Reporter: Pavel Pereslegin
• Created: 16/Oct/24 14:18
• Updated: 05/Dec/24 09:56
• Resolved: 05/Dec/24 09:56

Description

We need to support Statement#cancel() method.

    /**
     * Cancels this <code>Statement</code> object if both the DBMS and
     * driver support aborting an SQL statement.
     * This method can be used by one thread to cancel a statement that
     * is being executed by another thread.
     *
     * @exception SQLException if a database access error occurs or
     * this method is called on a closed <code>Statement</code>
     * @exception SQLFeatureNotSupportedException if the JDBC driver does not support
     * this method
     */
    void cancel() throws SQLException;

Issue Links

• blocks: IGNITE-23492 Implement cancelation in ODBC
• is blocked by: IGNITE-23430 Sql. Provide an ability to cancel query before first page ready
• is blocked by: IGNITE-23432 Provide System View for running queries
• links to: GitHub Pull Request #4814