Friday, May 22, 2020

Install and Configure DBeaver on Debian/Ubuntu

DBeaver  CE is a free and open-source multi-platform database management tool/SQL client designed for Developers,  SQL programmers, Analysts, and Database administrators. It supports any database which has JDBC driver – MySQL/MariaDB, PostgreSQL, Oracle, DB2 LUW, Google BigQuery, Exasol, SQL Server, Sybase/SAP ASE, SQLite, Firebird, H2, HSQLDB, Derby, Teradata, Vertica, Netezza, Informix, etc. DBeaver is based on the Eclipse platform and is a good workbench tool for building SQL queries, editing, and transferring data, viewing trees of objects, completing database administration tasks, monitoring database connection sessions, and a lot more.

Install Java on Ubuntu 16.04/18.04/20.04

Run the following commands to have Java installed and set as default Java on your Ubuntu 20.04/18.04/16.04.

sudo apt -y  install openjdk-11-jdk openjdk-11-jre

To set as default Java in Ubuntu

sudo update-alternatives --config java

Confirm version:

java -version

Install OpenJDK on Debian 10/9

OpenJDK is the default Java development and runtime available on Debian 10/9 repository. Install it by running the command below:

sudo apt -y install default-jdk

Check Java Version:

java -version

Add DBeaver repository to your Debian  by running the commands below:

sudo wget -O - | sudo apt-key add -
sudo echo "deb /" | sudo tee /etc/apt/sources.list.d/dbeaver.list

sudo apt update
sudo apt -y  install dbeaver-ce

Add DBeaver repository to your Ubuntu  by running the commands below:
sudo add-apt-repository ppa:serge-rider/dbeaver-ce
sudo apt-get update
sudo apt-get install -y dbeaver-ce
Install DBeaver version can be checked using:

sudo apt policy  dbeaver-ce
How to fix – DBeaver MySQL/MariaDB Native client is not specified for connection


No comments:

Post a Comment