DBeaver常见问题

DBeaver下载地址：https://dbeaver.io/download/

驱动相关

驱动安装时报错Maven artifact xxx no found

问题现象

安装dbeaver数据库连接工具，点“测试连接”的时候出现报错如下：
Error resolving dependencies Maven artifact ‘maven:/mysql:mysql-connector-java:RELEASE’ no found

问题原因

DBeaver无法连接maver库

解决方案

打开“窗口”->“首选项”->“驱动”->“Maven”
点击“添加”阿里云中央仓库地址：http://maven.aliyun.com/nexus/content/groups/public/
保存

连接数据库时报错Error org.postgresql.driver not loaded

问题现象

Can't create driver instance
Error creating driver 'PostgreSQL' instance.
Most likely required jar files are missing.
You should configure jars in driver settings.

Reason: can't load driver class 'org.postgresql.Driver'
Error creating driver 'PostgreSQL' instance.
Most likely required jar files are missing.
You should configure jars in driver settings.

Reason: can't load driver class 'org.postgresql.Driver'
org.postgresql.Driver
org.postgresql.Driver

问题原因

驱动和DBeaver版本不兼容

解决方案

下载最新版本的Postgresql Jdbc Driver，驱动下载地址：https://jdbc.postgresql.org/download.html

然后将postgresql jdbc driver jar添加到SQL client’s driver manager，如下图所示

连接数据库时报错Failed to load driver class org.postgresql.Driver