Database Connection Failied- Having issues with connecting to an SQL source

[paksan32]

Hi Everyone, We are trying to eval the free Studio edition. When we try to connect to an SQL DB we get the following error:

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

we are running the most recent java jre version on our server so not sure what this is complaining about. We would really appreciate any help in this direction as its blocking us from evaluating the product.

[Anonymous]

Hello

This error is telling us that the driver class was compiled at a higher version of Java than the version with which we tried to run it. 

Please provide the following information for us to be more better evaluate the issue:

- Product version (such as Talend-Studio-20200219_1130-V7.3.1)

Talend Cloud Real-Time Big Data Platform (7.3.120200219_1130)

- SQL DB driver version.

- Java version (such as Oracle JDK build 1.8.0_201)

Regards

Shong

[paksan32]

Hi Shong, thanks for the reply. Here is what we are running: TOS_DI-Win32-20200219_1130-V7.3.1 SQL DB Driver version: 1017.172.00.01 SQL Server: 10.00.14393.00.01 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)

[Anonymous]

I would suggest you to downgrade the driver version you have installed or upgrade your java version.

[paksan32]

Hi Shing, I upgraded the java version to C:\Windows\system32>java -version java version "16" 2021-03-16 Java(TM) SE Runtime Environment (build 16+36-2231) Java HotSpot(TM) 64-Bit Server VM (build 16+36-2231, mixed mode, sharing) But still get the error. Any thoughts?

[Anonymous]

Hi

Java 16 is not a compatible Java version for 7.3.1, it might cause other issues. The compatible Java versions, check this documentation.

Do you use 'Open source JTDS' driver or 'Microsoft' driver? Open the module viewer to check what is the driver jar file version? According to this page, it seems you are using a very latest version of driver jar file, you need to downgrade the driver jar version to map the Java version.

Regards

Shong

[KRogahn1618221775]

normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.

OneVanilla.com

[paksan32]

Thanks for the reply. We decided to use the native built in connector that Talend has and it connected with no issues.