项目场景：

win11
graalvm17
mssql-jdbc

问题描述

om.microsoft.sqlserver.jdbc.SQLServerException: 驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接。错误:“PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target”。 ClientConnectionId:fe40951b-54a9-438f-bd0e-853177cf3934at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3806)at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1906)at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3329)at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2950)at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2790)at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1663)at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1064)at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81)
Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

原因分析：

依赖自动引入版本号为 11.2.1.jre17<dependency><groupId>com.microsoft.sqlserver</groupId><artifactId>mssql-jdbc</artifactId></dependecy>

解决方案：

提示：graalvm环境下没有jre
指定版本

<dependency><groupId>com.microsoft.sqlserver</groupId><artifactId>mssql-jdbc</artifactId><version>9.4.1.jre8</version></dependency>