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.

com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:fe383ed8-ddb6-44a7-8d3e-c5f41967b9c0
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3680) ~[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:

encrypt=true;trustServerCertificate=true

Hopefully that is the best solution to my problem.

1 Like