After upgrading to Jmix 1.3, getting build error related to mssql

I just upgraded from Jmix 1.2.4 to 1.3 and now getting the following error:

2022-07-04 19:14:08.946  INFO 18052 --- [           main] i.j.a.u.v.JmixVaadinServletConfiguration : Set servlet init parameter [closeIdleSessions] = [false]
2022-07-04 19:14:09.229  INFO 18052 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2022-07-04 19:14:10.423 ERROR 18052 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization. The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: unable to find valid certification path to requested target". ClientConnectionId:fe383ed8-ddb6-44a7-8d3e-c5f41967b9c0
	at ~[mssql-jdbc-10.2.1.jre8.jar:na]

I am now using java 11 in my Jmix project.
I am assuming my mssql driver is for java 8. If this is what is causing this error, then how do I change/upgrade my MSSQL driver in IntelliJ Idea ?

Thank you in advance

I got my project to run after adding the following to my mssql connection params:


Hopefully that is the best solution to my problem.

1 Like