[研究]DbVisualizer 25.1.4資料庫系統免費管理工具
2025-05-27
DbVisualizer：一個跨平台的資料庫管理工具，支持 Windows、macOS 和 Linux 等多個操作系統，可以用於管理多種資料庫，包括 Microsoft SQL Server。
SQL Client and Editor - DbVisualizer
https://www.dbvis.com/
Purchase a DbVisualizer License - DbVisualizer
https://www.dbvis.com/pricing/
Installing a JDBC Driver - DbVisualizer 25.1 Users Guide - DbVisualizer Users Guide
https://www.dbvis.com/docs/25.1/reference-material/installing-a-jdbc-driver/
Users Guide - DbVisualizer 25.1 Users Guide - DbVisualizer Users Guide
https://www.dbvis.com/docs/25.1/
Supported DB"s, JDBC Drivers and OS"s - SQL client
https://www.dbvis.com/features/database-drivers/
下載得到 dbvis_windows-x64_25_1_4_jre.exe，它已經包含 Java JRE
安裝環境 Windows 10 x64，已經先安裝 MS SQL Server 2019 繁體中文標準版和 SSMS 20.2
[研究] DbVisualizer 25.1.4安裝出現 You are trying to load the workspace "Default Workspace"
前面安裝過程，按下【Finish】按鈕就已經啟動一份 DbVisualizer，不該再去點桌面的 DbVisualizer，或去點「開始」功能表的 DbVisualizer，就不會出現下面對話盒視窗 (敝人還原 VM 快照，重新測試一次安裝就不會問)
錯誤訊息
********************************************************************************
An error occurred while establishing the connection:
It looks like there may be a problem with the SSL certificates. This will help you solve the most common problems:
Long Message:
"encrypt" 屬性設定為 "true" 且 "trustServerCertificate" 屬性設為 "false"，但驅動程式無法使用安全通訊端層 (SSL) 加密建立 SQL Server 的安全連線: 錯誤: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target。 ClientConnectionId:138833f1-c253-4263-97f3-fc898f2cfeaa
Details:
Type: com.microsoft.sqlserver.jdbc.SQLServerException
SQL State: 08S01
Stack Trace:
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:148)
at java.base/sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:129)
at java.base/java.security.cert.CertPathBuilder.build(CertPathBuilder.java:297)
at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:383)
[wrapped] sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:388)
at java.base/sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:271)
at java.base/sun.security.validator.Validator.validate(Validator.java:256)
at java.base/sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:241)
at java.base/sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:113)
at com.microsoft.sqlserver.jdbc.HostNameOverrideX509TrustManager.checkServerTrusted(SQLServerTrustManager.java:88)
at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1430)
at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:631)
[wrapped] javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:130)
at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:383)
at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:326)
at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:321)
at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:647)
at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(CertificateMessage.java:467)
at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(CertificateMessage.java:363)
at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:393)
at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:476)
at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:447)
at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:206)
at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:172)
at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1506)
at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1421)
at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:455)
at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:426)
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1854)
[wrapped] com.microsoft.sqlserver.jdbc.SQLServerException: "encrypt" 屬性設定為 "true" 且 "trustServerCertificate" 屬性設為 "false"，但驅動程式無法使用安全通訊端層 (SSL) 加密建立 SQL Server 的安全連線: 錯誤: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target。 ClientConnectionId:138833f1-c253-4263-97f3-fc898f2cfeaa
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:4580)
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1965)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:4102)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3690)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:3499)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:2207)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1320)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at com.onseven.dbvis.jdbc.b.e.b(Z:525)
at com.onseven.dbvis.jdbc.b.g$_b.call(Z:1481)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
********************************************************************************
SQL Server: PKIX path building failed Print
Modified on: Thu, 13 Jun, 2024 at 9:42 AM
https://support.dbvis.com/support/solutions/articles/1000321432-sql-server-pkix-path-building-failed
********************************************************************************
解決
(完)
相關
[研究]HeidiSQL 12.10.0.7000 x64免費、免安裝版資料庫管理工具安裝、試用(Win10)
https://shaurong.blogspot.com/2025/05/heidisql-121007000-x64win10.html
[研究]DBeaver Community 25.0.5 資料庫管理工具(安裝版)安裝、試用(Win10)
https://shaurong.blogspot.com/2025/05/dbeaver-community-2505-win10.html
[研究]DbVisualizer 25.1.4資料庫系統免費管理工具
https://shaurong.blogspot.com/2025/05/dbvisualizer-2514.html
[研究]SQuirreL - Universal SQL Client Version 4.8.0 免費資料庫管理工具
https://shaurong.blogspot.com/2025/05/squirrel-universal-sql-client-version.html
沒有留言:
張貼留言