Super User Stack Exchange
Super User Stack Exchange

Questions tagged [dbeaver]

24 questions
25
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,098
  • 5
  • 17
  • 27
10
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
  • 101
  • 1
  • 1
  • 4
4
votes
0 answers

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
  • 583
  • 2
  • 7
  • 30
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
  • 71
  • 1
  • 11
4
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
  • 41
  • 1
  • 1
  • 4
3
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…
Dee
  • 641
  • 1
  • 10
  • 20
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
  • 1
  • 7
2
votes
1 answer

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
  • 583
  • 2
  • 7
  • 30
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
  • 1,861
  • 3
  • 21
  • 52
2
votes
1 answer

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 everything in the selection to upper case, therefore it is also not…
questionto42
  • 1,861
  • 3
  • 21
  • 52
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
  • 1
  • 5
2
votes
3 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
  • 201
  • 1
  • 3
  • 12
1
vote
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
  • 279
  • 1
  • 3
  • 11
1
vote
0 answers

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, 1001.02, ...) The number of entries contributing…
Philippe
  • 125
  • 5
1
vote
1 answer

"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
  • 1,861
  • 3
  • 21
  • 52
1
2