flink通过JDBC连接Oracle

沧海还一笑

已于 2022-04-19 13:52:08 修改

阅读量4.1k

点赞数 3

文章标签： java oracle flink

于 2022-04-13 16:24:04 首次发布

本文链接：https://blog.youkuaiyun.com/m0_58820420/article/details/124151113

版权

StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();
StreamTableEnvironment tableEnv = StreamTableEnvironment.create(env);

DataStreamSource<Row> input = env.createInput(JDBCInputFormat.buildJDBCInputFormat()
        .setDrivername("oracle.jdbc.driver.OracleDriver")
        .setDBUrl("jdbc:oracle:thin:@192.168.***.***:1521/orcl")
        .setUsername("FCDT")
        .setPassword("FCDT0606")
        .setQuery("select id from FCDT.X_NEWS_TCRNW0002 ")
        .setRowTypeInfo(new RowTypeInfo(BasicTypeInfo.BIG_DEC_TYPE_INFO))
        .finish());
Table table = tableEnv.fromChangelogStream(input);
table.execute().print();