mikebai.com

  • Home
  • dev
  • DotNET
  • M365
  • 搞笑
  • 杂七杂八
  • FocusDict
個人BLOG
it developer
  1. Main page
  2. dev
  3. Main content

com.microsoft.sqlserver.jdbc.SQLServerException “trustServerCertificate”属性设置为“false”,但驱动程序无法使用安全套接字层 (SSL) 加密与 SQL Server建立安全连接

2025-04-12 86hotness 0likes 0comments

from: https://support.hcl-software.com/csm?id=kb_article&sysparm_article=KB0100819

 

适用于

HCL Traveler 11.0.x, 12.0.x

问题

使用JDBC 10.2 及以后的版本,当运行travelerUtil命令连接到SQL server时,将遇到如下错误:

Using JDBC jar: C:\Domino\Traveler\lib\mssql-jdbc-10.2.0.jre8.jar
Checking database connection to: jdbc:sqlserver://<sqlserver hostname>:<db port>;databasename=<traveler db name>
Unable to connect to database: Unable to connect to database: 驱动程序无法使用安全套接层 (SSL) 加密建立与 SQL Server 的安全连接。错误: "sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:3271aef9-fd8c-4387-8c3d-250ac909ab3b
Database configuration was not saved.

原因

这是因为从JDBC 10.2开始,缺省启用了TLS加密,请参考下面的说明了解详细信息:

https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#changes-in-102

解决方法

解决方法:
对于 Traveler 11.0.x,使用JDBC driver(mssql-jdbc-8.2.2.jre8.jar),参考帮助文档:
https://help.hcl-software.com/traveler/11.0.0/configurelotusnotestravelerfordb2.html
对于Traveler 12.0.x,  使用JDBC driver(mssql-jdbc-9.2.1.jre8.jar),参考帮助文档:
https://help.hcl-software.com/traveler/12.0.0/configurelotusnotestravelerfordb2.html
也可以在使用travelerUtil命令连接到SQL server时,添加参数 ";encrypt=false" 作为workaround, 举例如下:
travelerUtil db set url=jdbc:sqlserver://<sqlserver hostname>:<db port>;databasename=<traveler db name>;encrypt=false user=<db login user> pw=<db login password>
Tag: Nothing
Last updated:2025-04-12

mikebai

This person is a lazy dog and has left nothing

Like
< Last article

COPYRIGHT © 2025 mikebai.com. ALL RIGHTS RESERVED.

Theme Kratos Made By Seaton Jiang