Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-16681

Jdbc JDBCOutputFormat and JDBCLookupFunction PreparedStatement loss connection, if long time not records to write.

    XMLWordPrintableJSON

Details

    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 .

      Attachments

        Issue Links

          Activity

            People

              wanglijie Lijie Wang
              shenlang LakeShen
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10m
                  10m