Questions tagged [dbeaver]

DBeaver is free universal database tool for developers and database administrators.

Filter by
Sorted by
Tagged with
1
vote
1answer
49 views

DBEaver Vs PG Admin

When I ran a query in Postgres database using the Pg Admin tool it took only 2 SECS ( I can see the parallel workers being used in the plan) but when I ran the same query in DBeaver, it took around 3 ...
1
vote
1answer
29 views

IDE Access to Hive without user password?

I'm a DB Developer and in my company we're only able to interact with hive through a technical user who owns the specific write permissions for Hive on HDFS. So in practice this looks like this: I ...
1
vote
0answers
17 views

How do you resize tables in an erd diagram in DBeaver?

When I click on a given table in an erd diagram in DBeaver I simply cant resize it. The table names get cut off. What am I missing ?
3
votes
1answer
296 views

What do the entity-relationship diagram (ERD) symbols used in DBeaver mean?

I don't understand the ERDs used by DBeaver. The diamonds and dots at the ends of the line arent the crow's foot I'm used to. I've googled the subject and checked the docs but can't find a straight-...
0
votes
1answer
105 views

T-SQL is not working on DBeaver on Linux [closed]

I am trying to run a basic T-SQL script DECLARE @temptable TABLE( abilityTypeId BIGINT NOT NULL, companyId BIGINT NOT NULL ); INSERT INTO @temptable(abilityTypeId, companyId) ...
1
vote
1answer
318 views

DBeaver's Auto Increment field max is 2147483647 - why?

In DBeaver, when right-clicking the 'Foreign Keys' to select 'View Foreign Keys', the following informational page is displayed: I would think that the 'Auto Increment' field value would read 1 (or ...
0
votes
0answers
89 views

Query with LVARCHAR performance in Informix DB

In a maintenance project that it's working with IBM Informix Dynamic Server Version 11.50.FC6 we have to improve the performance of some queries. One of this queries to the Informix DB fetches a ...
1
vote
1answer
684 views

how to filter the resulted table in dbeaver?

I have big sqlite table that I filtered one column with IN statement from the GUI. It worked will but I want to filter another second column also based on the first selected. eg full table looks like. ...
1
vote
1answer
252 views

DBeaver 5.3.2 reconnect after db change (CREATE TABLE call)

SQL scripts work on the active object in DBeaver. If you add a new table to your active database via an SQL statement in a script, DBeaver does not automatically update the navigator entries. Even ...
0
votes
1answer
105 views

Natural join output doesn't appear in table [closed]

I used this query: select * into airbnb_parcels from pcpao_res natural join AIRBNB_PARCELS; and got: Error: relation "airbnb_parcels" already exits. In DBeaver I used the following query: ...
1
vote
0answers
2k views

Postgresql 10: Can not establish DB connection

I have created a new database and user in Postgresql 10 named 'reportingdashboardproject' and 'repadmin' respectively. I used the following commands to create and grant privileges: postgres=# create ...
0
votes
2answers
285 views

PgAdmin4 unusable when database has lots of schemas

I have a production database with 60K database schemas. PgAdmin4 is unusable, I cannot even open "Query Tool" window. I suppose that PgAdmin tries to load database metadata, so that's the reason why ...
11
votes
1answer
7k views

How do you view PostgreSQL messages (such as RAISE NOTICE) in DBeaver?

I think this is a DBeaver UI/Configuration question, but I cannot see where the messages are when executing a script (Alt-X). In PGAdminIII, I would execute a script and see the NOTICE output: In ...
0
votes
1answer
431 views

How to configure DBeaver to save files without a BOM for UTF files?

I am looking for the equivalent setting as the PGADMIN setting Write BOM for UTF files which will cause saved files to be saved with/without the BOM. I've found settings in DBeaver when exporting ...
1
vote
1answer
892 views

How to close all query windows in DBeaver?

DBeaver retains all results & sql editor windows when the program is closed. The indicator showing tab overflow is easy to overlook (see pic). A user can accumulate an absurd number of tabs if ...
1
vote
2answers
490 views

How to solve repetitive ORA-2391 error in DBeaver 4.3.3.1

I can't seem to find the way to avoid ORA-2391 "exceeded simultaneous SESSIONS_PER_USER limit" when working with DBeaver 4.3.3.1. Everytime my session goes idle and I need to recconect I'm getting ...
1
vote
1answer
610 views

Issue connecting to remote SQL Server database through VPN

I need to connect to a remote SQL Server database of a client to do some syncing and other stuff. They use a VPN connection and have provided me the VPN address, RDP to SQL Server, username and ...
1
vote
1answer
1k views

Connection reset to SQL Server when using SSH Tunnel

I am trying to connect to an MS SQL Server database through DBeaver via an SSH tunnel but am getting the following error message when I "Test Connection...": I/O Error: Connection reset ...
1
vote
1answer
616 views

DBeaver not showing any Comments/Remarks in MSSQL

Recently, I am immigrating some data from Postgresql to a MSSQL2012 server. In SQLWorkbench, I can see comments on tables and columns in SQLServer. But in DBeaver, I can't see any comment or remarks ...
2
votes
1answer
885 views

Is it possible to run MongoDB javascript scripts in DBeaver

DBeaver's wiki shows a simple query against a Mongo database but what about admin scripts? It would be great to develop these in DBeaver but I've tried a few permutations to no avail. Here's an ...
1
vote
1answer
781 views

DB2: Column-Aliases with Line-Breaks

Using DB2 9.7, is it possible to produce a result set where the column-headers contain line-breaks? Something like: select field_name as "Line1<br>Line2" from table_name I want the column-...
7
votes
1answer
23k views

DBeaver: connecting to a PostgreSQL database server through SSH: can't initialize tunnel, auth fail

I am trying to use DBeaver to connect to a PostgreSQL database server through SSH: can't initialize tunnel cannot establish tunnel com.jcraft.jsch.JSchException: auth fail I am sure the SSH server ...
1
vote
2answers
3k views

DBIO Error: Utility 'mysqldump.exe' not found in MySQL home 'MySQL Connector/Net'

I am using dbeaver 3.6.10 and I would like to export my database (MySQL). I select the database > right mouse click on it > tools > export database > next > start I get the following error: IO ...
5
votes
0answers
5k views

DBeaver launch script from file

I'm trying to find a good alternative to SQL Developer for performing queries and scripts on Oracle instances. I find DBeaver to be an interesting tool, it has a lot of great features, BUT it seems ...
2
votes
2answers
6k views

Install DBeaver SQLite driver offline?

I'd like to use DBeaver with SQLite, but the network firewall disallows external connections. So DBeaver cannot download the driver automatically. Where can I download the SQLite driver for it and ...
2
votes
0answers
781 views

Umlauts in DBeaver

I have a Postgres Database set to UTF-8. I am working with DBeaver 3.1.4, and it seems to use a different encoding than UTF-8 (I suppose Latin-1 or something), which leads to 1) wrong display in the ...