Questions tagged [dbeaver]
DBeaver is free universal database tool for developers and database administrators.
63
questions
26
votes
1
answer
33k
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 ...
- 615
12
votes
3
answers
12k
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-...
- 498
11
votes
1
answer
9k
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 ...
- 111
10
votes
1
answer
35k
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 ...
- 2,033
5
votes
3
answers
17k
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 ...
- 171
4
votes
4
answers
14k
views
how to let dbeaver to highlight sql error for easier development process
I had a sql that had some error. Although the error says
SQL Error [42601]: ERROR: syntax error at or near "from"
Position: 420
. However, it seems dbeaver didn't highlight exactly where ...
- 155
4
votes
2
answers
11k
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 ...
- 183
4
votes
1
answer
5k
views
Is there a way to automatically upgrade DBeaver?
I am trying to update DBeaver Community Edition 7.0.3 to (currently) newest 7.1.0 edition on Fedora 30. When I start DBeaver a "Version Update" window pops up with buttons as options to Upgrade and ...
- 232
3
votes
2
answers
4k
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 ...
- 41
3
votes
1
answer
6k
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 ...
- 133
3
votes
1
answer
3k
views
"Folder" structure of Postgres database missing in DBeaver
I guess I did a faulty database restoration or the dump did not have this data and the "folder like" structure was lost. This is a capture of Dbeaver showing what I mean with "foler like" structure. I ...
- 347
3
votes
3
answers
911
views
MySQL: How to make Trigger to insert row in another table?
Please read everything, included the notes and edits at the end
Problem
I have a MySQL DB with 3 different table:
To save users
mysql> describe users;
+-------------+-----------------------------...
- 31
3
votes
1
answer
22k
views
DBeaver: Access denied for user 'root'@'localhost' (using password: YES)
Context: I am creating a new Schema and looking to import .sql file generated from mysql dump. I have server running: MySQL 8.0.19.
I am using DBeaver client Version 7.0.2 and have setup a new MySQL ...
- 129
2
votes
1
answer
2k
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)
...
2
votes
2
answers
3k
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 ...
- 61
2
votes
1
answer
4k
views
dbeaver check sql for syntax without running
Using the dbeaver tool, I want to check a script for syntax errors without actually running it.
Purpose:
For a long insert query (postgresql syntax, PostgreSQL 10.15) in the form of:
INSERT INTO ...
- 147
2
votes
2
answers
2k
views
How to find created mssql schema in DBeaver?
I have created new database and new schema.
CREATE DATABASE banks_db;
CREATE SCHEMA Chains;
Database was created, but not schema, and when I try to create it one more time I get error:
SQL Error [...
- 121
2
votes
1
answer
7k
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
...
- 21
2
votes
0
answers
3k
views
DBeaver connection via SSH tunnel
Using DBeaver, I'm trying to connect to my AWS ec2 instance where I've installed a MariaDB database.
I've created a new connection as:
Connection: AWS / Maria DB
Server Host: localhost (because I'm ...
- 121
2
votes
0
answers
4k
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 ...
- 129
2
votes
1
answer
2k
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 ...
- 131
2
votes
0
answers
1k
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 ...
- 123
2
votes
2
answers
1k
views
push using git integration in DBeaver
I am using the git plugin for DBeaver. While I can commit, I am not seeing an option to push the commit over to master. Am I missing something?
- 121
1
vote
1
answer
113
views
How to get all users that have more than a certain number of messages?
I have a database which ER diagram looks like this:
I struggle to get all the users which have for example more than a five messages. I was able to write a query in python:
q = "SELECT user_id ...
- 113
1
vote
1
answer
1k
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-...
- 133
1
vote
1
answer
10k
views
How to connecto DBeaver with Db2 using SSL self-signed certificate?
On Db2 v11.5.7.0 Linux/x86 server I have configured SSL using self-signed certificate following official IBM documentation https://www.ibm.com/docs/en/db2/11.5?topic=transit-tls-configuration-db2
I ...
- 325
1
vote
1
answer
5k
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 ...
- 85
1
vote
2
answers
466
views
DBeaver does not recognize declared variable when executing SQL script on SQL Server
We are using DBeaver Community Edition (v23.2.0.202309041200) as a client connecting to Microsoft SQL Server 2016 (v13.0.5101.9).
The issue happens when executing the below SQL statements in DBeaver ...
- 139
1
vote
1
answer
10k
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.
...
- 113
1
vote
1
answer
1k
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 ...
- 13
1
vote
1
answer
2k
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 ...
- 11
1
vote
1
answer
1k
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 ...
- 159
1
vote
0
answers
2k
views
Dbeaver restore database Error 1277 you need the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege for this operation
I'm attempting to import a .sql file to restore a database(hosted on AWS RDS) however this error keeps coming up.
ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER, ...
1
vote
0
answers
404
views
How can I share virtual key in DBeaver for other device?
As I know, the virtual key in DBeaver just existed on the client-side (local device), not in real database. I want to share this virtual key for other devices (not only my device). How can I do that?
- 11
1
vote
0
answers
29
views
SQL Editor features usually existing in an IDE? [closed]
I'm a fan of dbeaver user, but i miss the features that are usually existing in a modern java IDE, such as finding references, navigating codes, refactoring:
Autocompletes db view columns
Find ...
- 111
1
vote
2
answers
3k
views
SQL Error [1242] [21000]: Subquery returns more than 1 row (AMATEUR) [closed]
Basically, everything works in the brackets by itself. The statement in the brackets bring back 4 different values all on different rows.
How can I get around the fact that I need to apply the sql ...
- 19
1
vote
1
answer
5k
views
DBeaver Error 1146 (42S02) on SQL database restore- Table 'acumatica.AUNotification' doesn't exist [closed]
I am trying to restore a database dump from a file for an online SQL course I'm taking into DBeaver. When I restore it, however, it runs for a little bit and then I get the error message
ERROR 1146 (...
- 13
1
vote
1
answer
710
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 ...
- 181
1
vote
0
answers
327
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 ?
- 11
1
vote
2
answers
1k
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 ...
- 165
1
vote
1
answer
2k
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 ...
- 615
0
votes
1
answer
4k
views
Connect DBeaver to PostgreSQL 13
I've been using PostgreSQL 10 and 12 on Windows successfully with DBeaver in the past. Now I've set up a new development machine and installed the current PostgreSQL 13.0.1 and the current DBeaver 7.2....
- 233
0
votes
1
answer
481
views
Why is ODBC not available when I try to create a database connection in DBeaver?
I'm following a tutorial to connect to a database using an ODBC driver and DBeaver. But when I try to create a database connection, the ODBC option is not available.
I'm on Ubuntu, using version 22.3....
- 103
0
votes
1
answer
2k
views
DBeaver error returned connecting to Db2 database using SSL/TLS with hostname validation error
I have configured SSL/TLS on Db2/Linux v11.5.7.0. In DBeaver 22.1.5 (Java GUI program to access database) in Driver properties I have configured parameter:
sslConnection to true and DBeaver ...
- 325
0
votes
1
answer
1k
views
How do I get DBeaver to do a DB2 UPDATE via Cursor
The following query works when run from the console via db2 command. But fails when running via DBeaver.
BEGIN NOT ATOMIC
FOR R AS C CURSOR WITH HOLD FOR
SELECT ROW_NUMBER() OVER() AS INDEX, ID
...
- 35
0
votes
1
answer
745
views
Making an Oracle XE instance network wide available
Im fairly new to Oracle so please bear with me.
I want to install an Oracle 18c XE DBMS on a server and access it's databases remotely via DBeaver. First of all there is some confusion on which client ...
- 91
0
votes
1
answer
985
views
How to setup an ssh connection to a postgres 12 db using dbeaver
I am currently in the process of trying to connect to my local postgres 12 db. In the past (9.3/9.6) you were able to edit the .pg_hba file to modify which connections were allowed but that file doesn'...
- 235
0
votes
1
answer
430
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:
...
- 25
0
votes
1
answer
12
views
PostgreSQL create table char error
I just started learning PostgreSQL. I tried to create a table:
create table diagnosis(
mkb10 char(5),
opis varchar(100) not null,
constraint pk_diagnosis primary key (mkb10)
);
But I get ...
- 3
0
votes
1
answer
40
views
Spatial query instantaneous when using GUI client; slow through CLI or PDO application
I'm having a very peculiar instance wherein we recently had to upgrade our database from MySQL 5.7 to 8.0, and I had to rewrite some queries.
If my query is complicated enough, I usually prepare ...
- 101