[
https://issues.apache.org/jira/browse/BEAM-5045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16664594#comment-16664594
]
Shashank Agarwal commented on BEAM-5045:
----------------------------------------
+1
I am too facing the same issue. Using driver :
[https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc/7.0.0.jre8]
When my beam job is deployed on dataflow, it gives errors as below.
Although from local runner it runs fine.
Caused by: org.apache.beam.sdk.util.UserCodeException: java.sql.SQLException:
Cannot create PoolableConnectionFactory (The driver could not establish a
secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.
Error: "Socket is closed".
ClientConnectionId:42913aac-0552-46f9-8eb8-36567c45f865)
at
org.apache.beam.sdk.util.UserCodeException.wrap(UserCodeException.java:34)
at
org.apache.beam.sdk.io.jdbc.JdbcIO$ReadFn$DoFnInvoker.invokeSetup(Unknown
Source)
at
com.google.cloud.dataflow.worker.DoFnInstanceManagers$ConcurrentQueueInstanceManager.deserializeCopy(DoFnInstanceManagers.java:63)
at
com.google.cloud.dataflow.worker.DoFnInstanceManagers$ConcurrentQueueInstanceManager.peek(DoFnInstanceManagers.java:45)
at
com.google.cloud.dataflow.worker.UserParDoFnFactory.create(UserParDoFnFactory.java:94)
at
com.google.cloud.dataflow.worker.DefaultParDoFnFactory.create(DefaultParDoFnFactory.java:74)
at
com.google.cloud.dataflow.worker.IntrinsicMapTaskExecutorFactory.createParDoOperation(IntrinsicMapTaskExecutorFactory.java:262)
at
com.google.cloud.dataflow.worker.IntrinsicMapTaskExecutorFactory.access$000(IntrinsicMapTaskExecutorFactory.java:84)
at
com.google.cloud.dataflow.worker.IntrinsicMapTaskExecutorFactory$1.typedApply(IntrinsicMapTaskExecutorFactory.java:181)
... 14 more
> JdbcIO connection issue on version 2.5.0
> ----------------------------------------
>
> Key: BEAM-5045
> URL: https://issues.apache.org/jira/browse/BEAM-5045
> Project: Beam
> Issue Type: Bug
> Components: io-java-jdbc
> Affects Versions: 2.5.0
> Reporter: Liran Agami
> Assignee: Jean-Baptiste Onofré
> Priority: Minor
>
> I have ran into this error: "Cannot create PoolableConnectionFactory (The
> driver could not establish a secure connection to SQL Server by using Secure
> Sockets Layer (SSL) encryption. Error: "Socket is closed". "
> When I try to run the following:
> pipeline.apply(BQTable, JdbcIO.<List<String>>read()
> .withDataSourceConfiguration(JdbcIO.DataSourceConfiguration.create(options.getDriverName(),
> options.getConnectionUrl())
> .withUsername(options.getUserName()).withPassword(options.getPassword())
> .withConnectionProperties("encrypt=false"))
> I have updated the JDBC driver on both the server(6.4 for a Microsoft Server)
> and have updated the beams-sdk-java-io-jdbc to 2.5 as well.
> This error only occurs when I run the pipeline on apache beam 2.5 but not on
> 2.4
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
