Dbeaver

Dbeaver is a free multi-platform database administration tool. For more information about features, see the official homepage.

It supports popular databases such as MySQL, MariaDB, PostgreSQL, SQLite, Oracle database.

It provides a plugin architecture (based on Eclipse plugins architecture) that allows to modify much of the application behavior to provide database-specific functionality or features that are database-independent. This is a desktop application written in Java and based on Eclipse platform.

Installation

Install the dbeaver package.

There are also some plugins available:

• dbeaver-plugin-apache-poi - DBeaver library for Microsoft Office documents
• dbeaver-plugin-batik - DBeaver library for SVG format
• dbeaver-plugin-office - DBeaver plugin to export data to Microsoft Office format
• dbeaver-plugin-svg-format - DBeaver plugin to save diagrams in SVG format

Troubleshooting

JVM terminated error

If you are getting an error like this:

JVM terminated. Exit code=1
/bin/java
-XX:+IgnoreUnrecognizedVMOptions
-Xms64m
-Xmx1024m
-jar /usr/lib/dbeaver//plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
-os linux
-ws gtk
-arch x86_64
-showsplash
-launcher /usr/lib/dbeaver/dbeaver
-name Dbeaver
--launcher.library /usr/lib/dbeaver//plugins/org.eclipse.equinox.launcher.gtk.linux.x86_64_1.1.551.v20171108-1834/eclipse_1630.so
-startup /usr/lib/dbeaver//plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
--launcher.overrideVmargs
-exitdata 5b000e
-vm /bin/java
-vmargs
-XX:+IgnoreUnrecognizedVMOptions
-Xms64m
-Xmx1024m
-jar /usr/lib/dbeaver//plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar

Try adding export _JAVA_OPTIONS="-Dswing.defaultlaf=com.sun.java.swing.plaf.gtk.GTKLookAndFeel" to your xinitrc.

DBeaver configuration location

The location of the DBeaver configuration files are located ~/.local/share/DbeaverData

Java version

DBeaver relies on java 11 or above.

If you get an error message starting like this:

!ENTRY org.eclipse.compare 4 0 2021-02-25 11:11:08.257
!MESSAGE FrameworkEvent ERROR
!STACK 0
org.osgi.framework.BundleException: Could not resolve module: org.eclipse.compare [27]
   Unresolved requirement: Require-Bundle: org.eclipse.ui.navigator; bundle-version="[3.2.0,4.0.0)"; resolution:="optional"

This means that your java version is outdated. You can fix it by installing a newer java version and changing the default java on your system with archlinux-java. For example:

# archlinux-java set java-11-openjdk

GUI elements too big or filled with black rectangles

For HiDPI screens, GUI elements of Dbeaver might appear too big and certain parts of the interface might be filled with black rectangles.

This can be fixed by setting the following environment variables:

GDK_SCALE=2
GDK_DPI_SCALE=0.5

or this enviroment environment variables:

GDK_BACKEND=x11

Obviously the optimal values depend on the resolution of the screen, so a bit of trial and error might be needed. See HiDPI for more information.

Broken clipboard on Plasma Wayland between DBeaver and other applications

Running DBeaver with XWayland seems to fix the problem :

$ GDK_BACKEND=x11 dbeaver

Incompatible JVM

If you get an error message like

Version 1.8.0_345 of the JVM is not suitable for this product. Version 11 or greater is required

See the #Java version section of this document for a solution.