GCP Apache Beam Dataflow JDBC IO 连接错误

huangapple go评论77阅读模式
英文:

GCP Apache Beam Dataflow JDBC IO Connection Error

问题

问题

在尝试将 Apache Beam 流水线部署到 Google Cloud Platform Dataflow 服务时,该流水线连接到一个 Oracle 11gR2(11.2.0.4)数据库 以检索行,但在使用 Apache Beam JdbCIO 转换 时出现以下错误:

工作程序返回的错误消息:java.lang.RuntimeException: org.apache.beam.sdk.util.UserCodeException: java.sql.SQLException: 无法创建 PoolableConnectionFactory(ORA-00604: 在递归 SQL 级别 1 处发生错误 ORA-01882:找不到时区区域)

英文:

Problem

When trying to deploy an Apache Beam Pipeline on Google Cloud Platform Dataflow service which connects to a Oracle 11gR2 (11.2.0.4) database to retrieve rows, I received the following error when using the Apache Beam JdbCIO Transform:

> Error message from worker: java.lang.RuntimeException: org.apache.beam.sdk.util.UserCodeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found )

答案1

得分: 1

为了解决这个问题,我更新了 pom.xml 文件:

<!-- https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc6 -->
<dependency>
    <groupId>com.oracle.database.jdbc</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.4</version>
</dependency>
英文:

To solve the problem, I updated the pom.xml

&lt;!--https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc6 --&gt;
&lt;dependency&gt;
    &lt;groupId&gt;com.oracle.database.jdbc&lt;/groupId&gt;
    &lt;artifactId&gt;ojdbc6&lt;/artifactId&gt;
    &lt;version&gt;11.2.0.4&lt;/version&gt;
&lt;/dependency&gt;

huangapple
  • 本文由 发表于 2020年9月3日 03:16:51
  • 转载请务必保留本文链接:https://go.coder-hub.com/63712220.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定