英文:
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
<!--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>
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论