[IGNITE-7253] JDBC thin driver: introduce streaming mode

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.5
• Component/s: jdbc, sql
• Assignee: Alexander Paschenko
• Reporter: Vladimir Ozerov
• Created: 20/Dec/17 07:36
• Updated: 15/Feb/21 14:52
• Resolved: 14/Mar/18 09:24

Description

Should be done after IGNITE-6022. We should allow optional streaming mode for JDBC driver. In this mode only INSERTs without SELECT should be possible. All other DML operations should throw an exception.

Design considerations:
1) Add command SET STREAMING=1|ON|0|OFF which will enable or disable streaming for connection.
2) Add command STREAMER FLUSH which will force data flush.
3) Only INSERT without SELECT works, all other DML statements should throw an exception
4) It should be possible to stream into several tables simultaneously (i.e. several streamers could be opened)
5) Any DDL statement should force flush of all currently opened streamers.

Issue Links

• blocks: IGNITE-7855 ODBC: Support streaming mode
• is related to: IGNITE-14187 .NET Thin Client: DataStreamer
• is related to: IGNITE-7738 Allow 'multiple statements' in thin JDBC streaming mode
• relates to: IGNITE-7859 SQL streaming support via native API
• relates to: IGNITE-7942 Document streaming in thin JDBC driver
• links to: GitHub Pull Request #3499
• links to: GitHub Pull Request #3591