Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [dbeaver]

DBeaver is free universal database tool for developers and database administrators.

68 questions
27
votes
1 answer

How do you view PostgreSQL messages (such as RAISE NOTICE) in DBeaver?

I think this is a DBeaver UI/Configuration question, but I cannot see where the messages are when executing a script (Alt-X). In PGAdminIII, I would execute a script and see the NOTICE output: In DBeaver, the same script does not output in…
JC5577
  • 625
  • 3
  • 10
  • 18
12
votes
3 answers

What do the entity-relationship diagram (ERD) symbols used in DBeaver mean?

I don't understand the ERDs used by DBeaver. The diamonds and dots at the ends of the line arent the crow's foot I'm used to. I've googled the subject and checked the docs but can't find a straight-forward answer. Is there a reference for the style…
Dawoodjee
  • 498
  • 1
  • 4
  • 12
11
votes
2 answers

DBeaver launch script from file

I'm trying to find a good alternative to SQL Developer for performing queries and scripts on Oracle instances. I find DBeaver to be an interesting tool, it has a lot of great features, BUT it seems to lack an essential element: The possibility to…
Samuryte
  • 111
  • 1
  • 1
  • 4
10
votes
1 answer

DBeaver: connecting to a PostgreSQL database server through SSH: can't initialize tunnel, auth fail

I am trying to use DBeaver to connect to a PostgreSQL database server through SSH: can't initialize tunnel cannot establish tunnel com.jcraft.jsch.JSchException: auth fail I am sure the SSH server is working fine. I manage to connect to the same…
Franck Dernoncourt
  • 2,083
  • 13
  • 34
  • 52
6
votes
1 answer

Is there a way to automatically upgrade DBeaver?

I am trying to update DBeaver Community Edition 7.0.3 to (currently) newest 7.1.0 edition on Fedora 30. When I start DBeaver a "Version Update" window pops up with buttons as options to Upgrade and Details (manually download installation file). When…
NikolaS
  • 272
  • 1
  • 3
  • 12
6
votes
3 answers

Install DBeaver SQLite driver offline?

I'd like to use DBeaver with SQLite, but the network firewall disallows external connections. So DBeaver cannot download the driver automatically. Where can I download the SQLite driver for it and how can I install it manually in DBeaver?
Gere
  • 181
  • 1
  • 1
  • 3
5
votes
4 answers

how to let dbeaver to highlight sql error for easier development process

I had a sql that had some error. Although the error says SQL Error [42601]: ERROR: syntax error at or near "from" Position: 420 . However, it seems dbeaver didn't highlight exactly where the error is. It tells me it is position 420, but i don't…
hg628193hg
  • 165
  • 1
  • 1
  • 6
4
votes
1 answer

dbeaver check sql for syntax without running

Using the dbeaver tool, I want to check a script for syntax errors without actually running it. Purpose: For a long insert query (postgresql syntax, PostgreSQL 10.15) in the form of: INSERT INTO schema1.table1 (t1_id, fk1_id, fk_2_id, col1, col2) …
JosephDoggie
  • 203
  • 3
  • 10
4
votes
2 answers

DBIO Error: Utility 'mysqldump.exe' not found in MySQL home 'MySQL Connector/Net'

I am using dbeaver 3.6.10 and I would like to export my database (MySQL). I select the database > right mouse click on it > tools > export database > next > start I get the following error: IO Error: Utility 'mysqldump.exe' not found in MySQL home…
BustedSanta
  • 193
  • 1
  • 2
  • 7
3
votes
3 answers

MySQL: How to make Trigger to insert row in another table?

Please read everything, included the notes and edits at the end Problem I have a MySQL DB with 3 different table: To save users mysql> describe users; +-------------+-----------------------------------+------+-----+---------+----------------+ |…
Cromega08
  • 31
  • 5
3
votes
1 answer

"Folder" structure of Postgres database missing in DBeaver

I guess I did a faulty database restoration or the dump did not have this data and the "folder like" structure was lost. This is a capture of Dbeaver showing what I mean with "foler like" structure. I can easily access the functions, tables,…
Gabriel
  • 387
  • 1
  • 4
  • 11
3
votes
1 answer

DBeaver: Access denied for user 'root'@'localhost' (using password: YES)

Context: I am creating a new Schema and looking to import .sql file generated from mysql dump. I have server running: MySQL 8.0.19. I am using DBeaver client Version 7.0.2 and have setup a new MySQL 8+ Database connection. However, when I attempt…
kms
  • 129
  • 2
  • 3
  • 8
3
votes
2 answers

DBEaver Vs PG Admin

When I ran a query in Postgres database using the Pg Admin tool it took only 2 SECS ( I can see the parallel workers being used in the plan) but when I ran the same query in DBeaver, it took around 3 MINS to complete (the plan is different and I…
Krishna
  • 41
  • 1
  • 2
3
votes
1 answer

How to close all query windows in DBeaver?

DBeaver retains all results & sql editor windows when the program is closed. The indicator showing tab overflow is easy to overlook (see pic). A user can accumulate an absurd number of tabs if they aren't paying attention & actively closing tabs…
Don
  • 133
  • 1
  • 10
2
votes
0 answers

Umlauts in DBeaver

I have a Postgres Database set to UTF-8. I am working with DBeaver 3.1.4, and it seems to use a different encoding than UTF-8 (I suppose Latin-1 or something), which leads to 1) wrong display in the views 2) sending queries in the wrong encoding,…
kutschkem
  • 133
  • 4
1
2 3 4 5