[
https://issues.apache.org/jira/browse/BEAM-10858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anonymous updated BEAM-10858:
-----------------------------
Status: Triage Needed (was: Resolved)
> beam.io.jdbc not working on Google Cloud Dataflow
> -------------------------------------------------
>
> Key: BEAM-10858
> URL: https://issues.apache.org/jira/browse/BEAM-10858
> Project: Beam
> Issue Type: Bug
> Components: cross-language, extensions-java-gcp,
> runner-py-interactive
> Affects Versions: 2.23.0
> Environment: Apache Beam 2.25.0.dev0 Jupyter Notebook running on
> Google Cloud Dataflow
> Reporter: Ehab El Badrawi
> Priority: P3
> Labels: Clarified, GCP, MySQL, cross-platform, dataflow, java,
> jdbc, python
> Fix For: Missing
>
>
> Using the JDBC python wrapper to connect to an external server is failing on
> Cloud Dataflow.
> The error produced is;
> RuntimeError:
> /root/apache-beam-custom/packages/beam/sdks/java/extensions/schemaio-expansion-service/build/libs/beam-sdks-java-extensions-schemaio-expansion-service-2.25.0-SNAPSHOT.jar
> not found. Please build the server with cd
> /root/apache-beam-custom/packages/beam; ./gradlew
> :sdks:java:extensions:schemaio-expansion-service:shadowJar
> You can recreate the issue by running the below
> {code:java}
> from apache_beam.io import jdbc
> jdbc.ReadFromJdbc(
> table_name='[tablename]',
> driver_class_name='com.mysql.cj.jdbc.Driver',
> jdbc_url='jdbc:mysql://[host]:3306/[databasename]',
> username='[username]',
> password='[password]'){code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
