Questions tagged [dbeaver]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
193 views

Error installing oracle drivers using dbeaver in ubuntu

I have installed DBeaver in Ubuntu version 22.04.3 through the ubuntu software store and also via apt install. When I create a oracle connection I have this error: I have java installed in the system....
Shadowtrooper's user avatar
0 votes
0 answers
87 views

How do I navigate with the dBeaver suggestion blocks?

I always use the shortcut for selects (ctrl+shift+space) but then I need to click to edit thing like the where clause. Is there a keyboard shortcut for me to go from the table block to the column ...
Eduardo Azzolin's user avatar
0 votes
1 answer
2k views

Where is dbeaver.ini located if DBeaver is installed via windows store?

Where is dbeaver.ini located if DBeaver is installed via windows store as an app? Background of my question: I want to use a different VM
Kai's user avatar
  • 103
0 votes
0 answers
136 views

Auto add query results as comments in Dbeaver

In Dbeaver, is there a way to get the query result into your SQL file? This feature is handy when you have lots of queries and don't want to copy/paste their result one by one by hand. An example of ...
Sadegh's user avatar
  • 653
2 votes
1 answer
821 views

With DBeaver connecting to MariaDB, how to keep the session alive?

DBeaver uses MariaDB Connector/J, and the driver disconnects after completing the query. We are trying to use a MariaDB feature that depends on the session, so we need to run the query and keep the ...
James's user avatar
  • 349
1 vote
0 answers
281 views

PostgreSQL sum function resurns different result when run multiple of times with psql

I have this query : SELECT SUM(median) FROM my_table WHERE id = 100 -- median is of type float4 When I run from psql, it returns slightly different result for multiple of runs (For example 1000.08, ...
Philippe's user avatar
  • 125
0 votes
0 answers
2k views

null, message from server: Host '172.17.0.1' is not allowed to connect to this MySQL server

I am on Acer Aspire 5738 with 8GB ram, swap 16GB installed with Pop!_OS. I am using DBeaver as a RDBMS client and have created 3 containers and 3 separate volumes (to persist data) for 3 database ...
sifar's user avatar
  • 111
0 votes
0 answers
1k views

How to fix "Warning : Unprotected Private Key File" on Windows 10

I am attempting to do a simple connection to a SSH server using OpenSSH for Windows using a private key, and it shows this. I can't permit pem file and I keep getting this error message "Warning ...
dc56's user avatar
  • 1
4 votes
0 answers
2k views

Make Dbeaver always execute queries in newtab

In dbeaver, it happens sometimes that I execute new queries and overwrite the previous results. In order to fix the issue, I ask if there is any way to remove "Execute SQL statement" and &...
Sadegh's user avatar
  • 653
4 votes
2 answers
2k views

Set Word-wrap on as default in DBeaver

I want to have word-wrap on by default in Dbeaver. There is an answer showing how to toggle word-wrap, but I don't want to do it each time I open Dbeaver :-)
Sadegh's user avatar
  • 653
2 votes
2 answers
3k views

`Calculate total row count` (icon of two green circled arrows) in DBeaver throws "Error executing error count", but manual choice of >200 rows works

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') FROM MY_TABLE1 ...' at line 1 And in the details: Error ...
questionto42's user avatar
  • 2,267
1 vote
1 answer
662 views

"Advanced Copy" greyed out in DBeaver menu when trying to copy SQL table output as TXT

I often copy some sample rows and the frame in DBeaver as text for a quick markdown chat note. Now the "advanced copy" is greyed out. How can I get it back?
questionto42's user avatar
  • 2,267
2 votes
1 answer
5k views

DBeaver "Format" --> "Format SQL" --> "To Upper Case" applies to all words. How to format only the SQL command words reserved by the system?

When I right-click on a selected SQL query and choose "Format SQL" it changes the SQL to lower case. The other command "To upper case" is not SQL-intelligent, meaning it changes ...
questionto42's user avatar
  • 2,267
-1 votes
1 answer
559 views

ERROR dbeaver on manjaro

i downloaded dbeaver from the aur but it failed to open . it gives : " version 1.8 of JVM is not suitable for this product . Version 11 or greater is required" but in the aur there is only ...
Charbel Eid's user avatar
4 votes
1 answer
6k views

How to drop a table using mouse and context menu or main menu on DBeaver?

DBeaver is rather good with all the necessary features. However, something is missing. I'm using DBeaver to connect to PostgreSQL. The UI shows databases, table list, etc., right-clicking on a table ...
Dan D.'s user avatar
  • 701
4 votes
3 answers
4k views

How to switch DBeaver language from german to english?

i installed DBeaver as a portable app from portapps I choosed german but want to switch to english. I am aware that its a parameter, but how to do in Windows10? Thanks, Anton I guess its ...
Bodo's user avatar
  • 71
2 votes
0 answers
4k views

Install git Plugin for DBeaver

Problem I have DBeaver 6.3.3 installed on one of our remote servers. This remote server has no connection to the internet. Thus, I need to install drivers / plugins from a local file (I have the ...
thothal's user avatar
  • 121
0 votes
1 answer
5k views

How to specify JRE path for dbeaver on MacOS

I'm trying to setup dbeaver with prestosql driver on MacOS, and it shows me the following error unable to find valid certification path to requested target I think it's because dbeaver is using a ...
zyxue's user avatar
  • 101
10 votes
1 answer
14k views

DBeaver how to get back results window

DBeaver used to be able to show SQL scripts in the top window and results in the bottom window on the same screen. But now it won't show results at all. How do I get results to show at the bottom of ...
Leo Jones's user avatar
  • 101
1 vote
1 answer
6k views

dbeaver: Kerberos-auth PostgreSQL connection fails with "No LoginModules configured"

I'm trying to connect to a PostgreSQL server using GSSAPI (Kerberos) authentication using dbeaver. The command line psql client works nicely, and yet, the dbeaver connection fails, returning an error ...
Latanius's user avatar
  • 712
4 votes
2 answers
17k views

I am using DBeaver and go the error 'FATAL: database "postgres" does not exist'

I was using DBeaver and all of the sudden, I could no longer access my previous PostgreSQL databases or create new ones. I got the error 'FATAL: database "postgres" does not exist' when trying to open ...
Kayden K's user avatar
2 votes
3 answers
22k views

Connecting DBeaver to a Firebird file, gives error code 335544721

I'm trying to make DBeaver database manager connect to a Firebird *.FDB file. It is a local file database and I want to inspect the tables etc and perform some queries for data reporting. However, ...
BdR's user avatar
  • 201
3 votes
1 answer
11k views

Dbeaver export result set to multiple CSV files

I'm using the latest version of DBeaver on Mac, querying against a remote MSSQL database and I've got a query that results in 24 million rows. I need to get this data into CSV format, but rather than ...
jaydel's user avatar
  • 131
26 votes
6 answers
50k views

How to point to JRE home in DBeaver.ini

Is there a way of pointing to the proper Java/JRE in dbeaver.ini? This works: dbeaver.exe -vm "C:\Program Files\Java\jre1.8.0_131\bin\server" ...but this way I can't pin DBeaver to taskbar (its ...
Jaroslav Záruba's user avatar