topic Re: Talend Open Studio Data Integration - Invalid TLS error when connecting to Azure Sql Server in Talend Studio

Talend Open Studio Data Integration - Invalid TLS error when connecting to Azure Sql Server

TCullis1602144619 — Thu, 08 Oct 2020 08:33:57 GMT

Hi, I am getting a Java error stating Login Failed with invalid TLS version, I am using Microsoft SQL Server db type, and dbversion Opensource JTDS

Any ideas? any help appreciated

I also tried the Microsoft driver and got another error

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Using Azure Sql Server

Talend 7.3.1

Thanks

Tim

Re: Talend Open Studio Data Integration - Invalid TLS error when connecting to Azure Sql Server

Anonymous — Fri, 09 Oct 2020 08:57:36 GMT

Hello,

Did you use tJDBCConnection or tMSSqlConnection component to access the Sql Server running on azure?

What does your connection url format look like?

jdbc:jtds:sqlserver://<servername>:<port>//<DB name>;appName=<project name>;

MS SQL JDBC driver

jdbc:sqlserver://<servername>:<port>;[<propertyname>=<propertyvalue>;]

Best regards

Sabrina

Re: Talend Open Studio Data Integration - Invalid TLS error when connecting to Azure Sql Server

TCullis1602144619 — Fri, 09 Oct 2020 09:23:59 GMT

Hi, Sabrina,

I used TMSSQLInput, and specified the connection details

When I choose open source JTDS as the jdbc driver I get

Database connection is failed.

java.lang.RuntimeException: java.sql.SQLException: Reason: Login failed with invalid TLS version.

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1146)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:301)

at org.talend.designer.core.ui.editor.properties.controllers.DbTableController.checkConnection(DbTableController.java:782)

at org.talend.designer.core.ui.editor.properties.controllers.DbTableController$6.run(DbTableController.java:564)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

Caused by: java.sql.SQLException: Reason: Login failed with invalid TLS version.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)

at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:632)

at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:371)

at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)

at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:199)

... 6 more

and if I choose Microsoft I get

Database connection is failed.

java.lang.RuntimeException: java.lang.UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more recent version of the Java Runtime (class file version 58.0), this version of the Java Runtime only recognizes class file versions up to 52.0

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1146)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:301)

at org.talend.designer.core.ui.editor.properties.controllers.DbTableController.checkConnection(DbTableController.java:782)

at org.talend.designer.core.ui.editor.properties.controllers.DbTableController$6.run(DbTableController.java:564)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

Caused by: java.lang.UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more recent version of the Java Runtime (class file version 58.0), this version of the Java Runtime only recognizes class file versions up to 52.0

at java.lang.ClassLoader.defineClass1(Native Method)

at java.lang.ClassLoader.defineClass(Unknown Source)

at java.security.SecureClassLoader.defineClass(Unknown Source)

at java.net.URLClassLoader.defineClass(Unknown Source)

at java.net.URLClassLoader.access$100(Unknown Source)

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:124)

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:149)

... 6 more

---

I also tried tjdbcconnection, but I don't know how to set the drivers and driver class

Thanks

Tim

Re: Talend Open Studio Data Integration - Invalid TLS error when connecting to Azure Sql Server

Anonymous — Mon, 12 Oct 2020 07:45:41 GMT

Hello,

What's JDK version are you using? All required external jar files are installed completely in your studio?

Best regards

Sabrina

Re: Talend Open Studio Data Integration - Invalid TLS error when connecting to Azure Sql Server

Anonymous — Mon, 12 Oct 2020 07:46:27 GMT

Hello,

What's JDK version are you using? All required external jar files are installed completely in your studio?

Best regards

Sabrina

Re: Talend Open Studio Data Integration - Invalid TLS error when connecting to Azure Sql Server

TCullis1602144619 — Mon, 12 Oct 2020 07:58:06 GMT

Hi, i have jdk 1.8.0_261, installed, same version as well for jre.

When i install Talend, i clicked for 3rd party drivers to be installed, but not all of them

I downloaded the Microsoft driver sqljdbc_8.4.1.0 & extracted to a local dir

i renamed in turn each of the jar files to mssql-jdbc.jar.14.x to mssql-jdbc.jar but that made no difference

When prompted i selected the mssql-jdbc.jar.

I also went to view modules, filtered on mssql and the drivers were installed

Re: Talend Open Studio Data Integration - Invalid TLS error when connecting to Azure Sql Server

TCullis1602144619 — Mon, 12 Oct 2020 07:59:20 GMT

Re: Talend Open Studio Data Integration - Invalid TLS error when connecting to Azure Sql Server

TCullis1602144619 — Mon, 12 Oct 2020 12:12:02 GMT

I have resolved the issue.

I deleted Java and Talend.
downloaded the LTS Java 11 open version from oracle. Installed into program-files Java. Updated windows path etc
installed Talend 7.3.1
downloaded latest Microsoft Jdbc drivers
expanded into a dir
renamed the Java 11 driver into mssql-jdbc.jar
installed that driver when asked
all worked.

happy days

Re: Talend Open Studio Data Integration - Invalid TLS error when connecting to Azure Sql Server

Anonymous — Tue, 13 Oct 2020 07:41:21 GMT

Hello,

Great it works. Thanks for your feedback and sharing your solution here.

Best regards

Sabrina