Stack Overflow
Stack Overflow

Questions tagged [dbeaver]

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

  • Usability is the main goal of this project, program UI is carefully designed and implemented.
  • It is freeware.
  • It is multiplatform.
  • It is based on an open-source framework and allows the writing of various extensions (plugins).
  • It supports any database having a JDBC driver.
  • It may handle any external datasource which may or may not have a JDBC driver.
  • There is a set of plugins for certain databases and different database management utilities (e.g. ERD).
1047 questions
17
votes
2 answers

Error : dbeaver utility 'mysql.exe' not found in client home 'mysql binaries'

When I try to import an SQL file and execute it using dbeaver software, it prompts the following error: I have already installed XAMPP on PC.
Asmoun
  • 1,417
  • 5
  • 20
  • 53
16
votes
2 answers

Dbeaver no active connection

Running Dbeaver 21.3.0 on ubuntu linux 21.1. The problem I have is that when trying to execute a query I get a "no active connection error". However in the Database navigator screen I have an active remote ms-sql-server connection, can see the…
Jim Maas
  • 1,481
  • 2
  • 16
  • 36
16
votes
2 answers

Where is the Excel export option in DBeaver Community Edition

Am using DBeaver 6.3.4 Community Edition and it doesn't show XLSX ( Excel) option when Data Export feature is selected as in the screenshot. This excel option appeared in my Trial version of Enterprise Ed. Please help me enable/install this excel…
LonelyRogue
  • 376
  • 1
  • 2
  • 10
15
votes
13 answers

DBeaver - Column "columns name' is read-only: No corresponding table column

I am using DBeaver on Mac and suddenly can't edit/udpate anything on results cell, I get this message: Column "columns name' is read-only: No corresponding table column. However, when I use UPDATE command it works just fine. The challenge is that…
RedaB
  • 171
  • 1
  • 1
  • 5
15
votes
5 answers

DBeaver: display datetime with milliseconds

This is MySQL 5.7 column: `date` datetime(6) NOT NULL I can see milliseconds using console: mysql> select * from teq_log_1; +----+----------------------------+-------+---------+---------+ | id | date | level | message |…
Alex Gusev
  • 1,526
  • 3
  • 16
  • 35
15
votes
3 answers

DBeaver does not keep primary keys on import/export

I'm using DBeaver to migrate data from Postgres to Derby. When I use the wizard in DBeaver to go directly from one table to another, the primary key in Derby is being generated instead of inserted. This causes issues on foreign keys for subsequent…
Timothy Vogel
  • 1,363
  • 2
  • 21
  • 39
14
votes
2 answers

Analyze SQL query in DBeaver

I would like to get some info about a running query to analyze it. In PgAdmin 3 I could at least use 'Explain Query', while in DBeaver, after clicking 'Explain Execution Plan', nothing happens. How to obtain any information about query in…
Michu93
  • 5,058
  • 7
  • 47
  • 80
14
votes
4 answers

Error while installing dbeaver - Java error code = 13

I am getting the below error when trying to open dbeaver. Java is up to date...any ideas?
The Numbers Man
  • 139
  • 1
  • 2
  • 7
13
votes
3 answers

DBeaver / PostgreSQL: "Error: database already exists", but I can't find it

I want to create database called "President" by rightclicking on PostgreSQL and selecting Create Database. However, I get the error in the screenprint below. I can create databases with other names like SomeOtherDatabase and SomeOtherDatabase2 (see…
Frank
  • 541
  • 1
  • 6
  • 18
13
votes
2 answers

Truncate table in DBeaver right click menu/GUI

I am trying to find an option to truncate table in the right click menu or somewhere in the GUI of DBeaver. The database is SQL Server. Is there any other option rather that explicitly writing the truncate script?
Alok Thampi
  • 161
  • 1
  • 1
  • 7
13
votes
2 answers

How to view queries executed internally from dbeaver

When trying to DELETE, INSERT or UPDATE one more table rows inside Table editor (or by using the add, duplicate and delete buttons), i know that dbeaver executes some queries. Is there a way to view these queries? I tried the "query manager"…
Bill
  • 459
  • 1
  • 3
  • 13
12
votes
2 answers

connect docker postgres from outside (DBeaver)

I am using Airflow through Docker-compose. The same docker-compose.yml has an image of Postgres as well. The config looks like below - postgres: image: postgres:13 ports: - 5432:5432 environment: POSTGRES_USER: airflow …
sandeep
  • 3,061
  • 11
  • 35
  • 54
12
votes
2 answers

Connect to remote db with ssh tunneling in DBeaver

I know this question was already asked before (like here), but still I could not find a solution and those posts are quite old. So I am able to connect to the remote db with an ssh connection and then use the command line like this: // Putty SSH…
link
  • 491
  • 1
  • 4
  • 13
12
votes
4 answers

Cannot connect to local postgresql DB using DBeaver

I'm trying to connect to a postgresql database which is in localhost:5432 but I keep getting the error: FATAL: Ident authentication failed for user "". I installed Postgres11 on virtual machine running Centos7. Created a database through command…
avaros
  • 177
  • 1
  • 1
  • 9
12
votes
1 answer

How to create a database backup in DBeaver and restore it?

I need to create a SQL server database backup in DBeaver and restore it. Is that possible? Using SQL Management Studio would not be a turnaround solution in this case, as we are not allowed to use it here.
Pedro Coelho
  • 1,411
  • 3
  • 18
  • 31
1 2
3
…
69 70