[jira] [Commented] (BEAM-12027) ReadFromJDBC sql server not working

["Kenneth Knowles (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/BEAM-12027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17313389#comment-17313389 ] 

Kenneth Knowles commented on BEAM-12027:
----------------------------------------

It seems that you need the MSSQL driver on your classpath for the cross-language transform. [~chamikara] may be able to point to documentation on how this is achieved.

> ReadFromJDBC sql server not working
> -----------------------------------
>
>                 Key: BEAM-12027
>                 URL: https://issues.apache.org/jira/browse/BEAM-12027
>             Project: Beam
>          Issue Type: Bug
>          Components: cross-language, io-java-jdbc
>    Affects Versions: 2.28.0
>         Environment: MacOs, apache-beam python SDK, java version "1.8.0_281"
> Java(TM) SE Runtime Environment (build 1.8.0_281-b09)
> Java HotSpot(TM) 64-Bit Server VM (build 25.281-b09, mixed mode)
>            Reporter: Rebekka Moyson
>            Priority: P2
>              Labels: ClassNotFoundException, jdbc, python
>
> I want to use apache_beam.io.jdbc.ReadFromJdbc to read from a SQL server. When executing locally with the python SDK and driver_class_name='com.microsoft.sqlserver.jdbc.SQLServerDriver', I always get the error java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver.
> Have JDK 8 installed.
> Used beam (on dataflow runner) a lot with python and want to make use of this interesting portability feature to read from jdbc with that Java Expansion service.
> Not sure what is wrong and could not find a lot of documentation about this jdbc io feature and how to use it as python developer. 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)