Super User
Super User

Questions tagged [dbeaver]

26 questions
27
votes
6 answers

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 icon gets duplicated) Is there a way of achieving the…
Jaroslav Záruba
  • 1,148
12
votes
1 answer

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 the screen with scripts at the top? I've…
Leo Jones
  • 121
7
votes
1 answer

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 would open context menu. The context menu allows…
Dan D
  • 759
7
votes
2 answers

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 one. I am running Windows 10, the latest…
Kayden K
  • 71
6
votes
2 answers

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
  • 723
4
votes
1 answer

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 "execute SQL script" button so that the only remaining options…
Sadegh
  • 723
4
votes
3 answers

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 something in c:\portapps\dbeaver-portable\app\dbeaver.ini
Bodo
  • 81
3
votes
1 answer

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 one huge, unmanageable file with 24 million lines…
jaydel
  • 131
2
votes
1 answer

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 session alive for another query later to gather the…
James
  • 499
2
votes
2 answers

`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 executing row count SQL Error [1064] [42000]: You…
questionto42
  • 2,691
2
votes
1 answer

DBeaver "Format" --> "Format SQL" --> "To Upper Case" applies to all words. How do I 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 everything in the selection to upper case, therefore it is also not…
questionto42
  • 2,691
2
votes
0 answers

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 possibility to copy files to a drive which is…
thothal
  • 121
2
votes
4 answers

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, when I try to open the database in DBeaver I get…
BdR
  • 241
  • 1
  • 7
  • 16
1
vote
0 answers

What field names tweaks the colors for errors background in execution logs

The color is so bright, contrast and toxic It makes my eyes bleed In < Settings < User Interface < Appearance < Colors and fonts I already changed: Error text color Error cell background and some other options but all of them not changed errors…
MosQuan
  • 11
1
vote
1 answer

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. The error appears when I click in test…
Shadowtrooper
  • 19
1
2