英文:
08006 idea-key-store KeyStore not available
问题
升级到Intellij 2023.2后，我无法再使用Ultimate版本捆绑的“Database Tools and SQL”插件执行对任何PostgreSQL数据库的查询。执行任何SQL都会导致以下错误：
[08006] 提供的SSLSocketFactory类com.intellij.execution.rmi.ssl.DefaultSslSocketFactory无法实例化。
idea-key-store密钥库不可用
查看调试日志并未提供比这更多的信息。
导致原因: java.security.NoSuchAlgorithmException: idea-key-store密钥库不可用
at java.base/sun.security.jca.GetInstance.getInstance(GetInstance.java:159)
at java.base/java.security.Security.getImpl(Security.java:676)
at java.base/java.security.KeyStore.getInstance(KeyStore.java:868)
... 37 more
奇怪的是，我可以查询Oracle数据库。
英文:
After upgrading to Intellij 2023.2, I can no longer execute queries against any PostgreSQL database using the Database Tools and SQL plugin bundled with Ultimate edition. Executing any SQL results in the following error:
[08006] The SSLSocketFactory class provided com.intellij.execution.rmi.ssl.DefaultSslSocketFactory could not be instantiated.
idea-key-store KeyStore not available
Looking at the debug logs doesn't provide much more information than this.
Caused by: java.security.NoSuchAlgorithmException: idea-key-store KeyStore not available
at java.base/sun.security.jca.GetInstance.getInstance(GetInstance.java:159)
at java.base/java.security.Security.getImpl(Security.java:676)
at java.base/java.security.KeyStore.getInstance(KeyStore.java:868)
... 37 more
I can query Oracle databases, oddly.
答案1
得分: 16
根据此 YouTrack 问题的建议，您可以通过在数据源设置的“高级”选项卡中设置以下内容来解决该错误：
-DsslDeferredKeyLoading=true
这为我解决了问题。
英文:
As suggests by this YouTrack issue, you can work around the error by setting
-DsslDeferredKeyLoading=true
in the VM options in the "advanced" tab of the data source settings.
That fixed the issue for me
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论