Update 8.1p4 to version 8.2 error in the database

[wendycape (Wendy Campos)]

You have version 8.1 p4 installed and you want to update to 8.2.

The command ./iiq.bat update is executed and the following error is received.

2024-07-19T11:39:19,690 ERROR main sailpoint.server.upgrade.Upgrader:1272 - Cannot load JDBC driver class ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’
sailpoint.tools.GeneralException: Cannot load JDBC driver class ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’

We have placed the driver in the iiq folder but we still have the same error.

Any advice?

Regards.

[sunnyajmera]

have you verified if mssql-jdbc-8.4 jar file is present in WEB-INF/lib folder?

[wendycape (Wendy Campos)]

Hello Sunny,

we have

it needs to be mssql-jdbc-8.4?

Regards.

[enistri_devo (Emanuele Nistri)]

@wendycape

mssql-jdbc-8.4

not necesessary, depends of the mssql db version that you have installed, you can check the compatibility on this table:

this is the page:

Support matrix - JDBC Driver for SQL Server

also, check the permission and owner of the file jar and the entire sailpoint folder and try to use the cmd instead of powershell, I had some problems with powershell in the past

[AdamVentum (Adam Waszak)]

Hi and Hello,

@wendycape what version of java you have?

Java Version Compatibility: Confirm that the JDBC driver version is compatible with the Java version being used. Some drivers might not work with newer or older versions of Java

Regards,
Adam