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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Shang Yuanchun (Jira)
LakeShen created FLINK-16681:
--------------------------------

             Summary: 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
            Reporter: LakeShen
             Fix For: 1.10.2


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)