mssql-jdbc.jar file installation issue

[RFAM1]

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.

[Anonymous]

Hi

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

[RFAM1]

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.

[gjeremy1617088143]

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

[RFAM1]

@guenneguez jeremy​ Yes. The compliance level is 1.8

[Anonymous]

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

[RFAM1]

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

[gjeremy1617088143]

I'm happy you find a solution @Rekha Padala​