[FLINK-16681] Jdbc JDBCOutputFormat and JDBCLookupFunction PreparedStatement loss connection, if long time not records to write.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.11.0
• Component/s: Connectors / JDBC
• Labels: pull-request-available
• Assignee: Lijie Wang
• Reporter: LakeShen
• Due: 31/Mar/20
• Created: 19/Mar/20 11:51
• Updated: 30/Jun/20 06:04
• Resolved: 10/Jun/20 03:11

Description

In my thought, jdbc connector is the one of most frequently used connector in flink . But maybe there is a problem for jdbc connector. For example, if there are no records to write or join with dim table for a long time , the exception will throw like this :

java.sql.SQLException: No operations allowed after statement closed

Because there are long time no records to write , the PreparedStatement loss the connection.
If there is no other jira to solve this problem , can you assign this jira to me , I will try my best to solve it , thank you .

Issue Links

• links to: GitHub Pull Request #12427