topic Re: mssql-jdbc.jar file installation issue in Installing and Upgrading

mssql-jdbc.jar file installation issue

RFAM1 — Fri, 15 Nov 2024 23:41:55 GMT

Hi,

I need to install mssql-jdbc.jar file for tDBCConnection(Microsoft SQL Server). I couldn't install it through the talend studio(7.3.1)

Manually installed and pointed it in the studio to the file. But still getting "List of modules not installed for current operation" error but this time, it is showing Network is unavailable.

I am connected to the network. To repoint the small icon that is used to browse the file under Action is disabled

In the modules, it is showing as installed.

Re: mssql-jdbc.jar file installation issue

Anonymous — Fri, 24 Sep 2021 01:37:20 GMT

About the error, network is unavailable, please take a look at this related topic. If the modules shows the jar as installed, but studio still ask you to install the jar, have a try to remove the jar from <studio installation directory>\configuration\.m2\repository\mssql\ and reinstall manually it from Modules views if the network is unavailable.

Regards

Shong

Re: mssql-jdbc.jar file installation issue

RFAM1 — Fri, 24 Sep 2021 03:50:56 GMT

I reinstalled the jar file. Now when I run the job I am getting this error.

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

The jar file window in the first screenshot in above post required version 6.0.0 and I installed the same.

Can you help me understand which version I should be using.

Re: mssql-jdbc.jar file installation issue

gjeremy1617088143 — Fri, 24 Sep 2021 07:18:31 GMT

Hi @Rekha Padala , could you check this article :

https://help.talend.com/r/en-US/7.2/studio-user-guide-open-studio-for-esb/setting-compiler-compliance-level

and see if your compiler compliance level is 1.8?

Send me love and kudos

Re: mssql-jdbc.jar file installation issue

RFAM1 — Fri, 24 Sep 2021 15:15:52 GMT

@guenneguez jeremy Yes. The compliance level is 1.8

Re: mssql-jdbc.jar file installation issue

Anonymous — Sun, 26 Sep 2021 04:20:42 GMT

Take a look at this topic, if your Java version is 8, you need to downgrade the jar version.

Re: mssql-jdbc.jar file installation issue

RFAM1 — Thu, 30 Sep 2021 14:07:19 GMT

Thank you all. This issue is resolved when I updated the jar file. Initial jar file is newer version which didnt comply

Re: mssql-jdbc.jar file installation issue

gjeremy1617088143 — Thu, 30 Sep 2021 14:55:39 GMT

I'm happy you find a solution @Rekha Padala