topic Re: Database Connection Failied- Having issues with connecting to an SQL source in Installing and Upgrading

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

paksan32 — Sat, 16 Nov 2024 00:20:52 GMT

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)

java.net

.URLClassLoader.defineClass(Unknown Source)

java.net

.URLClassLoader.access$100(Unknown Source)

java.net

.URLClassLoader$1.run(Unknown Source)

java.net

.URLClassLoader$1.run(Unknown Source)

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

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)

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.

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

Anonymous — Tue, 30 Mar 2021 08:41:13 GMT

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

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

paksan32 — Tue, 30 Mar 2021 18:12:44 GMT

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)

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

Anonymous — Wed, 31 Mar 2021 07:36:05 GMT

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

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

paksan32 — Wed, 31 Mar 2021 15:39:07 GMT

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?

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

Anonymous — Thu, 01 Apr 2021 01:11:15 GMT

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

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

KRogahn1618221775 — Mon, 12 Apr 2021 10:05:20 GMT

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

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

paksan32 — Mon, 12 Apr 2021 18:11:18 GMT

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