Questions tagged [dbeaver]

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

Filter by
Sorted by
Tagged with
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 ...
spjvn's user avatar
  • 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 ...
Offlein's user avatar
  • 101
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 ...
ALiCe P.'s user avatar
  • 113
1 vote
2 answers
465 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 ...
James's user avatar
  • 139
0 votes
0 answers
397 views

PostgreSQL Server Timeout Issue with pgAdmin, pgAdmin Web, and DBeaver

I am using PostgreSQL 15.4 on Ubuntu 22.04. Initially, I used pgAdmin 4 for managing the database. However, I've been facing an issue where pgAdmin stops responding after some time. This issue seems ...
Purushottam Nawale's user avatar
0 votes
1 answer
246 views

DBeaver connection to Postgres server stuck on "Read Data from Container"

I am currently trying to view a postgres database. However, it is stuck on "Read Data from Container" for several hundred seconds. This all happened after I deleted a table and recreated it. ...
boomersooner's user avatar
0 votes
0 answers
337 views

DBeaver database export not exporting foreign keys

I have DBeaver 23.1.0 on Windows. I want to export tables (PostgreSQL) from Database A to Database B, including foreign keys. What I found out was to mark all tables from Database A -> Right click -...
fabpico's user avatar
  • 111
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; +-------------+-----------------------------...
Cromega08's user avatar
0 votes
1 answer
480 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....
大朱雀's user avatar
  • 103
0 votes
0 answers
86 views

I want to simplify my sum query using loop function

I have a query to summerize my data based on month between year 2021 - next years (depend on the real date) i used simple query like this to summerize the amount monthly SUM(IF(pt.description like '%O-...
Yuyu Gaming's user avatar
-1 votes
1 answer
2k views

PostgreSQL CREATE OR REPLACE FUNCTION does not update function body [closed]

I have a function that exists in a PostgreSQL instance. I can say that are several services running on an app server and pages served from a web server that both target the database. Additionally, ...
PhynyxRysyn's user avatar
-1 votes
1 answer
538 views

DBeaver is failing to execute any on SQLite. "[SQLITE_ERROR] SQL error or missing database"

I'm trying to use DBeaver to manipulate an SQLite database and, pretty much any operation I try on the database schema, like creating a table or column, it fails with: SQL Error [1]: [SQLITE_ERROR] ...
andrerpena's user avatar
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 ...
folow's user avatar
  • 325
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 ...
folow's user avatar
  • 325
0 votes
0 answers
33 views

SUM which adds together figures collected on the same date

For example all data collected on 1/1/22 would all added together and outputed as one result and data collected on 2/1/22 would all added together be another result. I will add my query bellow to help ...
HarryButler21's user avatar
0 votes
1 answer
302 views

Access Oracle Database remotely via DBeaver

I have two machines, a windows 10 notebook with oracle database installed, and a Raspberry Pi 4 with DBeaver installed. On the Raspberry I have PostgreSQL which I can access locally via dbeaver, but ...
Caio Vital's user avatar
0 votes
0 answers
582 views

Why multiple statements executed in single run takes more time than when those statement run individually?

I am running following queries from DBeaver app connected to Postgres. Statement1: -- create 1000 rows in table2 do $$ declare begin for r in 1..1000 loop ...
NiTiN's user avatar
  • 1
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, ...
HarryButler21's user avatar
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?
Tuấn Anh's user avatar
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 [...
dokichan's user avatar
  • 121
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 ...
hg628193hg's user avatar
0 votes
2 answers
248 views

MySQL configuration. Query doesnt get returned result (DataGrip, DBeaver, PHP). Something times out [closed]

I am running a simple INSERT INTO ... SELECT ... ON DUPLICATE KEY UPDATE ... query using either DataGrip or DBeaver or PHP and it always doesnt register the result. The SELECT inside takes about 10 ...
honzaik's user avatar
  • 101
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 ...
JosephDoggie's user avatar
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 ...
Badger's user avatar
  • 35
0 votes
0 answers
1k views

Unable to Execute Script files (.sql) in MySQL using DBeaver plugin, in Eclipse CDT with macOS Catalina (Shows, "No Active Connection")

Unable to execute the script files (.sql). It shows "No Active Connections". But, test connection is complete, and localhosr has MySQL Icon with connection check mark, and I refreshed the ...
tom_kp's user avatar
  • 1
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 ...
Bertie's user avatar
  • 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 ...
7up234's user avatar
  • 19
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....
ygoe's user avatar
  • 233
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 ...
Tommy's user avatar
  • 121
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 ...
SweetPotato's user avatar
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 ...
NikolaS's user avatar
  • 232
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 ...
Gabriel's user avatar
  • 347
0 votes
2 answers
10k views

Data truncation: Incorrect datetime value: '7/21/15' for column 'announced_on' at row 1

I am importing a flat file into a table in DBeaver v7.0.2. When I attempt to import, it's throwing an error for date field formatted as mm/dd/yy. The date column in the table is defined with ...
kms's user avatar
  • 129
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 ...
kms's user avatar
  • 129
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 (...
dbeaver-help's user avatar
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?
Saqib Ali's user avatar
  • 121
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'...
Brandon's user avatar
  • 235
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 ...
Krishna's user avatar
  • 41
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 ...
Mayak's user avatar
  • 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 ?
user189533's user avatar
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-...
Dawoodjee's user avatar
  • 498
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) ...
Borisav Živanović's user avatar
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 ...
datsb's user avatar
  • 85
0 votes
0 answers
201 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 ...
Lubco's user avatar
  • 1
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. ...
Omar113's user avatar
  • 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 ...
bejo's user avatar
  • 13
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: ...
gulfy's user avatar
  • 25
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 ...
Sean D's user avatar
  • 129
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 ...
elBastarde's user avatar
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 ...
Jay Cummins's user avatar