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
9
votes
2 answers

Oracle db table data loading is too slow in DBeaver

I'm using DBeaver to connect to an Oracle database. Database connection and table properties view functions are working fine without any delay. But fetching table data is too slow(sometimes around 50 seconds). Any settings to speed up fetching table…
Chethaka Uduwarage
  • 1,527
  • 2
  • 12
  • 12
9
votes
6 answers

SSL connection working in MySQL Workbench, but not in DBeaver

EDIT for present day readers This was a bug in an old version of DBeaver that was subsequently fixed. I am getting an 'access denied' error trying to connect to a Google Cloud SQL MySQL instance with SSL in DBeaver. I am able to: connect to the…
oulenz
  • 1,199
  • 1
  • 15
  • 24
8
votes
1 answer

Increase font size in database navigator

I would like to increase font in database navigator tree. I found an option in Appearance View and Editor folders > Tree and table views nevertheless besides the font the distance between tree items is increasing as well. Is it possible to keep…
Henry
  • 537
  • 1
  • 9
  • 22
8
votes
5 answers

Dbeaver restore unsaved script

I am trying to restore an unsaved dBeaver script. I opened my DBeaver again after my system got shutdown abruptly and I can't find anything. All my SQL script are gone. What can I do to restore or to find these script files? In which folder are SQL…
Aaina Arora
  • 154
  • 1
  • 1
  • 11
8
votes
1 answer

DBeaver SQL Editor: how to search/replace in only the current window?

In the DBeaver SQL Editor, is there a way to search and replace only in the current script window? It seems like this should be simple and obvious, but to me it's not. My search dialog looks like the below. I don't see how I can restrict the scope…
Martin_W
  • 1,582
  • 1
  • 19
  • 24
8
votes
1 answer

How to set the default schema in DBeaver?

I am having trouble with the DBeaver default schema. When I set the default schema and close DBeaver, on next startup Active catalog/schema is N/A. How to fix this?
Mirko Djuric
  • 83
  • 1
  • 1
  • 5
8
votes
5 answers

How to configurate the home client in dbeaver for Postgresql

I'm am tryng to import a database, however i'm getting this message : Client home is not specified for connection I guess that i have to configurate the cliente, however i dont't know how to fill these form, i've already tried, putting in the…
jeanpdt
  • 130
  • 1
  • 1
  • 8
8
votes
3 answers

how to configue a dbeaver proxy connection to a private maven repository

I am using an internal maven/artifactory repository on my network. I am trying to intialize an Oracle Connection with DBeaver 7.1.0. (not the eclipse plugin, the standalone program) Each time it initializes, it fails to download the drivers. with…
Ryu S.
  • 1,538
  • 2
  • 22
  • 41
8
votes
5 answers

Cannot connect to PostgreSQL from client - Error timed out

After many days I am trying to connect to my PostgreSQL instance, I decided time has come to ask for help. I am trying to connect to my PostgreSQL db from a Windows machine. I am trying pgAdmin 4 and dBeaver but both fail to connect. Below is the…
umbe1987
  • 2,894
  • 6
  • 35
  • 63
8
votes
2 answers

Can't query data on pgAdmin 4 but it works using psql and Python

I have created a postgresql database on rds and I can connect and query it using psql on terminal or sqlalchemy on Python. When using pgAdmin4 I can't query or visualize the data but can create/alter tables, import data, ... I have also tried…
ufru
  • 89
  • 1
  • 3
8
votes
2 answers

View primary key in DBeaver

Is there a quick way to view the primary key of a table in DBeaver? Like e.g. in the Eclipse data source explorer, where primary key rows are marked with "PK" and a special symbol.
hunger
  • 413
  • 1
  • 4
  • 12
8
votes
1 answer

Turn select * into individual field names in DBeaver

I stumbled upon one of the most amazing features in DBeaver, where I had: select * from foo And I hit some key combination that turned * into an individual list of field names: select field1, field2, field3, field4 from foo The problem is I cannot…
Hambone
  • 15,600
  • 8
  • 46
  • 69
8
votes
6 answers

dbeaver mysql access denied

Can anyone tell me why I got an alert with the access denied error? I tried to create a mysql database and I confidently sure I entered the correct password for root yet I still got this error. However, based on the mysql documentation for…
Wolver Ing
  • 81
  • 1
  • 1
  • 5
8
votes
4 answers

What is the reason for not working of 'describe' command on oracle?

i am trying to run the 'describe table_name' command on oracle. I am using dbeaver for accessing oracle. But, when i run the command, it shows SQLException and error message "invalid sql statement". How can i perform the operation?
NIDHEESH KRISHNA
  • 147
  • 1
  • 1
  • 10
8
votes
2 answers

Insert BLOB test string bigger than 2000 or 4000 bytes

I have a table in oracle with a BLOB column, that can store XMLs and as well XMLs zipped. These are requirements from the customer and can't be changed. The tables will be created and I have to read and work with some information inside the BLOBs.…
Weslor
  • 22,180
  • 2
  • 20
  • 31