Included MS JDBC driver in Ignition 8.1.33+

Ignition
1

Hello,

I noticed that when installed Ignition 8.1.44 that the included MS SQL JDBC driver is version mssql-jdbc-9.4.0.jre11.jar But I believe since Ignition 8.1.33 that the JRE version is 17. How come a newer version of this driver does not get included with 8.1.33+ Ignition installs that supports JRE17? Is it a licensing issue?

Our SQL servers are running SQL Server 2022 and 9.4 says it doesn't support that, so I think I'll just be upgrading to a newer driver that does support 2022 and JRE17. However, it looks like we have some systems using this old 9.4.0 driver, which is a bit surprising to me that we don't have any issues.

Thanks.

2

9.4.0 still works with JDK 17, the reference to the JRE in its version string is the minimum version required. We aren't aggressively tracking and updating any JDBC drivers.

1 Like
3

Thanks for the reply, Kevin. Any idea why this driver works with SQL Server 2022 when the compatibility matrix explicitly says that it does not?

Maybe this is just saying "eh it might work, good luck".

Screenshot_20241119_113104
Screenshot_20241119_113104890×348 6.26 KB

4

I'd read that matrix as Microsoft not claiming it's supported or works, not claiming it does not work and they have tested/confirmed it does not work.

Not my matrix though :person_shrugging:

5

Err, yeah, this.

6

Thanks for all of your help!