JDBC connection via MS SQL does not work after upgrade to WebOffice 10.9 R3

For security reasons the Microsoft (MS) SQL JDBC driver has been updated for WebOffice version 10.9 R3. The update only affects MS SQL Server.

An action is necessary if the following error message is displayed in the log file:

FATAL [main ] 2281 
UM_NO_CONNECTION - Failed to connect to the authorization database
caused by sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at java.base/sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:141)
at java.base/sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:126)
at java.base/java.security.cert.CertPathBuilder.build(CertPathBuilder.java:297)
at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:434)
at java.base/sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:306)
at java.base/sun.security.validator.Validator.validate(Validator.java:264)

FATAL [main ] 2094 E1250499735T5717224 
APPLI_CAN_NOT_START - Failed to start WebOffice
caused by Failed to connect to the authorization database
UM_NO_CONNECTION - # E1250499735T5717172

ERROR [ajp-nio-127.0.0.1-8009-exec-5 ] A8D86FDBEC06CE7FB411630011FE1CFD 64912 E796101278T5780030 
Failed to get the anonymous login
caused by java.lang.NullPointerException
java.lang.NullPointerException
at com.mysynergis.core.controller.jsp.JspUtilAuth.isAnonymousLogin(JspUtilAuth.java:107)

Starting with this WebOffice version it will be necessary to make changes in the application and project configuration.

Changes in database connection parameter:
With the additional configuration of the ;trustServerCertificate=true parameter, the certificate of the addressed server will be verified for the database connection.

The parameter must be set in two places.

1.) WebOffice author standalone > Application configuration > Configuration of web application > Common > User Management > DB connection information for read and write access

2.) WebOffice author standalone > Project configuration > Edit Project > Database connections > DB connections