配置MySQL Sink,确保使用手动事务提交。 AI检测代码解析 transformedStream.addSink(newJdbcSink<Tuple2<String,Integer>>(// 添加 JDBC Sink"jdbc:mysql://localhost:3306/database_name",// 数据库连接字符串(element,preparedStatement)->{// 设置准备语句preparedStatement.setString(1,element.f0);// 第一个字...
在这里,我们使用JDBCSink 将数据写入 MySQL 数据库: importorg.apache.flink.api.java.tuple.Tuple2;importorg.apache.flink.streaming.api.datastream.DataStream;importorg.apache.flink.streaming.api.environment.StreamExecutionEnvironment;importorg.apache.flink.streaming.connectors.jdbc.JDBCAppendTableSink;importorg....
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) at com.mysql.cj.exceptions.ExceptionFactory.create...
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) at com.mysql.cj.util.Util.getInstance(Util.java:167) at com.mysql.cj.util.Util.getInstance(Util.java:174) at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateExcep...
import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; /** * @Description TODO * @Author zytshijack * @Date 2019-05-14 08:32 * @Version 1.0 */ public class SourceFromMySQL extends RichSourceFunction<Student> { //Student就是...
object JdbcSink { def main(args: Array[String]): Unit = { //创建执行环境 val env = StreamExecutionEnvironment.getExecutionEnvironment val inputStream = env.readTextFile("/opt/java2020_study/maven/flink1/src/main/resources/sensor.txt") ...
创建自定义sink类MySQLSinkFunction.java,这是本文的核心,有关数据库的连接、断开、写入数据都集中在此: package com.bolingcavalry.customize; import org.apache.flink.configuration.Configuration; import org.apache.flink.streaming.api.functions.sink.RichSinkFunction; ...
一个Person的类,对应MySQL中的一张表的字段。 模拟几条数据流,写入到 MySQL中。 package icu.wzk;import org.apache.flink.configuration.Configuration;import org.apache.flink.streaming.api.datastream.DataStreamSource;import org.apache.flink.streaming.api.functions.sink.RichSinkFunction;import org.apache.flink...
import java.sql.{Connection, DriverManager} import com.google.gson.Gson import org.apache.flink.configuration.Configuration import org.apache.flink.streaming.api.functions.sink.{RichSinkFunction, SinkFunction} class MysqlSink(url: String, user: String, pwd: String) extends RichSinkFunction[String] {...