flink定時讀取mysql

public class MysqlSource extends RichSourceFunction<Map<String, ValueConf>> {
    // 定時器間隔時間(ms)
    private static final CountDownLatch countDownLatch = new CountDownLatch(1);
    private final String sql;
    private QueryRunner qr;
    public SignalSource(String sql) {
        this.sql = sql;
    }
    @Override
    public void open(Configuration parameters) throws Exception {
        // 此處需要提前將mysql配置資訊儲存全域性變數中 env.getConfig().setGlobalJobParameters(params);
        ParameterTool params = (ParameterTool) getRuntimeContext().getExecutionConfig().getGlobalJobParameters();
        String jdbcUrl = params.getRequired("mysql.jdbc.url");
        String userName = params.getRequired("mysql.username");
        String password = params.getRequired("mysql.password");
        qr = new QueryRunner(JDBCUtils.getDataSource(jdbcUrl, userName, password));
    }
    @Override
    public void run(SourceContext<Map<String, ValueConf>> ctx) throws Exception {
        while (true) {
            Map<String, ValueConf> rs = qr.query(sql, new BeanListHandler<>(ValueConf.class)).stream().collect(Collectors.toMap(ValueConf::getCode, i -> i));
            ctx.collect(rs);
            // 每隔12小時執行一次
            countDownLatch.await(12, TimeUnit.HOURS);
        }
    }
    @Override
    public void cancel() {
    }}

MapStateDescriptor<String, ValueConf> descriptor=new MapStateDescriptor<>("mysql-descriptor",String.class,ValueConf.class);BroadcastStream<Map<String, ValueConf>> mysqlSource=env.addSource(new MysqlSource("querySql")).uid("MysqlSource").name("MysqlSource").setParallelism(1).broadcast(descriptor);

    <properties>
        <commons.dbutils.version>1.6</commons.dbutils.version>
        <mysql.connector.version>8.0.16</mysql.connector.version>
        <hikaricp.version>4.0.3</hikaricp.version>
    </properties>
        <!--MySQL-java連線驅動-->
        <dependency>
            <groupId>http/:w
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql.connector.version}</version>
        </dependency>
        <dependency>
            <groupId>commons-dbutils</groupId>
            <artifactId>commons-dbutils</artifactId>
            <version>${commons.dbutils.version}</version>
        </dependency>
        <dependency>
            <groupId>com.zaxxer</groupId>
            <artifactId>HikariCP</artifactId>
            <version>${hikaricp.version}</version>
            <exclusions>
                <exclusion>
                    <groupId>org.slf4j</groupId>
                    <artifactId>slf4j-api</artifactId>
                </exclusion>
            </exclusions>
        </dependency>