[ https://issues.apache.org/jira/browse/BEAM-5045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kenneth Knowles resolved BEAM-5045. ----------------------------------- Resolution: Fixed Assignee: Ahmet Altay (was: Jean-Baptiste Onofré) Fix Version/s: 2.9.0 > JdbcIO connection issue with MS SQL > ----------------------------------- > > 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: Ahmet Altay > Priority: Minor > Fix For: 2.9.0 > > > 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)