[ https://issues.apache.org/jira/browse/FLINK-16681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17118389#comment-17118389 ]
Lijie Wang commented on FLINK-16681: ------------------------------------ Thank you [~jark], I see, I will also fix JdbcRowDataOutputFormat. > Jdbc JDBCOutputFormat and JDBCLookupFunction PreparedStatement loss > connection, if long time not records to write. > -------------------------------------------------------------------------------------------------------------------- > > Key: FLINK-16681 > URL: https://issues.apache.org/jira/browse/FLINK-16681 > Project: Flink > Issue Type: Improvement > Components: Connectors / JDBC > Reporter: LakeShen > Assignee: Lijie Wang > Priority: Major > Labels: pull-request-available > Fix For: 1.11.0, 1.10.2 > > Time Spent: 10m > Remaining Estimate: 0h > > 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 . -- This message was sent by Atlassian Jira (v8.3.4#803005)