[IGNITE-22413] Jdbc. Reduce amount of roundtrips on statement execution

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: jdbc
• Labels: ignite-3
• Assignee: Konstantin Orlov
• Reporter: Konstantin Orlov
• Created: 05/Jun/24 12:33
• Updated: 04/Sep/24 16:08
• Resolved: 07/Jun/24 10:11

Description

At the moment, every but the very first call to execute on statement object results in 4 roundtrips:

// below are operation codes of incoming messages on the server side in the order they are appear

>>>>DEBUG incoming JDBC_MORE_RESULTS
>>>>DEBUG incoming JDBC_CURSOR_CLOSE
>>>>DEBUG incoming JDBC_EXEC
>>>>DEBUG incoming JDBC_CURSOR_CLOSE

First two looks suspicious given that query from the test is a single statement.

Issue Links

• links to: GitHub Pull Request #3880