[IGNITE-23464] Implement cancellation in JDBC

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: jdbc, sql
• Labels: ignite-3
• Epic Link: Kill Queries
• Assignee: Unassigned
• Reporter: Pavel Pereslegin
• Created: 16/Oct/24 14:18
• Updated: 12/Nov/24 10:27

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