[BEAM-12027] ReadFromJDBC sql server not working

• Type: Improvement
• Status: Resolved
• Priority: P2
• Resolution: Won't Fix
• Affects Version/s: 2.28.0
• Fix Version/s: Missing
• Component/s: cross-language, io-java-jdbc
• Labels: ClassNotFoundException jdbc python
• 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)
• Assignee: Unassigned
• Reporter: Rebekka Moyson
• Created: 23/Mar/21 10:08
• Updated: 13/Jan/22 21:48
• Resolved: 17/May/21 23:55

Description

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.