JDBC SQL Server driver jar file name

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hi all,
The post [[Required JDBC Driver JAR Files - Compass]] specifies the details on how JDBC for SQL Server should be configured.

It mentions that the Driver File Name should be sqljdbc4.jar
The resulting download from the included Microsoft link results in a zip file having 3 jar files:

  1. mssql-jdbc-9.4.0.jre8.jar
  2. mssql-jdbc-9.4.0.jre11.jar
  3. mssql-jdbc-9.4.0.jre16.jar

I have 2 questions:

  1. What is the version of Java that comes with the VA: is it Java 8, 11 or 16 ?
  2. Should we rename the downloaded jar file to sqljdbc4.jar before uploading it to the VA ?

Thanks for your feedback,
Wim

2

Hi @wim_deswerts - welcome to the community!

The documentation here indicates Java 8

3

Hi Wes,
You need not rename the jar file to sqljdbc4.jar before uploading to VA. The source only requires the classes inside the jar file to be uploaded. The jar file name does not matter.

-Seema

4

Thanks for your feedback. I’ll use the version 8 jar.