[FLINK-34014] Jdbc connector can avoid send empty insert to database when there's no buffer data

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: jdbc-3.2.0
• Component/s: Connectors / JDBC
• Labels: pull-request-available
• Assignee: Jeyhun Karimov
• Reporter: luoyuxia
• Created: 08/Jan/24 03:42
• Updated: 26/Mar/24 14:11
• Resolved: 26/Mar/24 14:11

Description

In jdbc connector, we will have a background thread to flush buffered data to database, but when no data is in buffer, we can avoid the flush to database.

we can avoid it in method JdbcOutputFormat#attemptFlush or in
JdbcBatchStatementExecutor like TableBufferedStatementExecutor  which can aovid calling  statementExecutor.executeBatch() when buffer is empty

Issue Links

• links to: GitHub Pull Request #100