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

[TCullis1602144619]

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

[Anonymous]

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

[TCullis1602144619]

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.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.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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

Hello,

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

Best regards

Sabrina

[TCullis1602144619]

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

[TCullis1602144619]

[TCullis1602144619 · Accepted solution]

I have resolved the issue.

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

happy days

[Anonymous]

Hello,

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

Best regards

Sabrina