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
28
votes
4 answers

DBeaver ssh tunnel invalid private key

Just want to leave it here, so the link to the solution won't be lost. I have a private 4096-byte RSA key (probably it was generated using this guide https://help.github.com/en/articles/generating-a-new-ssh-key-and-adding-it-to-the-ssh-agent). I've…
zinovyev
  • 2,084
  • 1
  • 22
  • 32
28
votes
1 answer

java.lang.OutOfMemoryError: Java heap space in DBeaver

I have a .sql file with size 1047399KB,I'm trying to run it on Windows10 with 4.00GB RAM on DBeaver program, i got java.lang.OutOfMemoryError: Java heap space error I tried many solutions but didn't work with me. file.sql -Xms128m -Xmx512m, file.sql…
Zeyad Etman
  • 2,250
  • 5
  • 25
  • 42
27
votes
7 answers

Docker MySQL connection DBeaver

I just finished following this Docker tutorial on youtube: https://www.youtube.com/watch?v=SXY0MLHP3hA&lc=Ugzp3vKtSOp0rn2lYyd4AaABAg I was able to create a couple of Docker containers for PHP and MySQL. The file structure is as…
John Beasley
  • 2,577
  • 9
  • 43
  • 89
26
votes
4 answers

DBeaver not showing dbms_output

I'm using dbeaver version 5.1.3. When I use the DBMS_OUTPUT.PUT_LINE method for oracle pl/sql it's output not shown anywhere. It has a output tab. It's also blank.
Indika Rajapaksha
  • 1,056
  • 1
  • 14
  • 36
26
votes
3 answers

Connect to Redis or MongoDB in DBeaver

There is a very good SQL client solution for Linux users DBeaver. In spec, it is said that it supports MongoDB and Redis databases.However, there are no such drivers in "New connection" window. Does anyone know how to connect to Mongo or Redis?
megapixel23
  • 829
  • 1
  • 10
  • 22
23
votes
3 answers

DBeaver how to switch database in sql editor

I'm using DBeaver with Postgres. I can open a new sql editor with ctl+[. But I have multiple databases in my Postgres. How can I have the sql editor run against another database? the following doesn't work use ; select * from
Harry Moreno
  • 10,231
  • 7
  • 64
  • 116
21
votes
4 answers

DBeaver restore SQL Server .bak file

I am just trying to restore a SQL Server .bak file in my DBeaver UI. But I have no idea how to do this - can someone help please? I created a database, but when I right click on it, there are no restore options.
Paul Kruger
  • 2,094
  • 7
  • 22
  • 49
20
votes
1 answer

How can I limit DBeaver Data Editor to limit result set size?

How can I limit DBeaver Data Editor to limit the result set size? I know the default is 200 and we can configure it in settings/preferences for the "Data Editor" section but this filter seems to be applied after all the results are already fetched…
annunarcist
  • 1,637
  • 3
  • 20
  • 42
19
votes
3 answers

where is word wrap in DBeaver 5.2.0?

I've been looking for hours in the options of DBeaver but I can't seem to find a "word wrap" option. Is it available, as this changelog suggests? I'm losing my patience over this issue...
R. Bourgeon
  • 923
  • 1
  • 9
  • 25
19
votes
1 answer

How to create auto incrementing / SERIAL id columns using DBeaver with PostgreSQL?

I am a new user for both PostgreSQL and DBeaver (Community edition ver. 5.1.6) and was looking for a way to create an auto incrementing ID column in a table through the DBeaver GUI. From my research I can see that: You can set this up easily using…
jwwnz
  • 703
  • 2
  • 7
  • 13
19
votes
7 answers

How do I pretty format my SQL query in DBeaver?

I use DBeaver for my main IDE to query multiple databases. When I query a table, it automatically generates a long select statement with all columns in one line. When I am making more complex queries, this gets very cumbersome to work with and…
Albert
  • 267
  • 1
  • 3
  • 6
19
votes
5 answers

DBeaver error resolving maven dependencies

I am trying to connect to a remote MySQL database using DBeaver 3.6.3. But when I try to add the server as a new connection, I need to select a connection type. I select MySQL and as soon as I click on next, it gives me this error I have tried…
Teun van der Wijst
  • 939
  • 1
  • 7
  • 21
18
votes
2 answers

How to restore a PostgreSQL database from dump file in dbeaver?

In our company we have a dump of PostgreSQL database - file db.sql. It weighs 8 Gigabyte. How to restore this database in DBeaver? And we don't have another databases in DBeaver 7.0.5. I have digged all Internet and haven't found anything how to do…
Mary Smith
  • 361
  • 1
  • 2
  • 11
18
votes
4 answers

how to configure the DBeaver and Cassandra

I am very new to DBeaver. From forum i got to know that driver need to update for cassandra 3+ to work with DBeaver. https://github.com/serge-rider/dbeaver/issues/167 I downloaded this new driver but unable to set the class path. Can anyone help me…
samir
  • 345
  • 2
  • 6
  • 15
17
votes
3 answers

Where are the postgres logs?

I'm using DBeaver to connect the postgres db and want to access the logs via DBeaver. I run the command below to find log destination and got stderr as the location. show log_destination ; How can I reach that file on DB app? FYI, I want all logs,…
cosmos-1905-14
  • 783
  • 2
  • 12
  • 23
1
2
3
…
69 70