1,196 questions
2
votes
0
answers
173
views
Can not mark more then one line in DBeaver
I am facing an issue in DBeaver.
I always update my DBeaver program when it says to update, and I am using a MAC.
The version of DBeaver is 25.2.5.202511161745.
I try to mark via the mouse more than ...
- 1,267
1
vote
1
answer
195
views
Dbeaver error - 'invalid column reference'
I was trying to delete a row from the table by writing the following SQL script in DBeaver
delete from products where id = 11;
select id from products;
in the first line id is showing an error - '...
Advice
0
votes
3
replies
117
views
ucanaccess drivers for DBeaver
I am using DBeaver for my students during SQL exams with a MS Access database. The drivers cannot be updated with the ucanaccess driver because the internet is blocked during exams. How can I update ...
0
votes
1
answer
33
views
DBeaver 'description tooltip' window overlaps autocomple feature
I have search through the preferences menu and have not found a configuration to eliminate this extra 'description tooltip' that appears along with the autocomplete
on the smaller monitor it simply ...
- 1
1
vote
0
answers
44
views
How to get DBeaver to stop saying syntax error to correct SQL code? [duplicate]
I enter correct SQL code into DBeaver, mark it and Ctrl+Enter to run
The separate parts are all OK, but when I run them together, I get a syntax error.
If I say
-- =====================================...
- 2,621
0
votes
0
answers
125
views
DBeaver isn't refreshing the tables in the database navigator. I could see the tables when I view the schema explictly
I'm on dbeaver Version 25.0.5.202505181758. I could see the table being created on this fresh postgres instance, but couldn't see the table in the database navigator.
I have tried to refresh the ...
- 13
0
votes
0
answers
96
views
Getting DBeaver Eclipse Plugin for Older Versions of Eclipse
I noticed on the Eclipse Marketplace DBeaver that the latest versions of DBeaaver require Eclipse 2025-06 to run. I am required to use an older version of Eclipse. Is there somewhere I can download ...
- 1,399
2
votes
0
answers
115
views
pg_dump fails while taking backup from Dbeaver [closed]
I take backup from Dbeaver for my Postgres production database on daily basis. there are three schemas in it: two client and one workflow schema. the size of client databases are larger than that of ...
- 21
0
votes
1
answer
72
views
Creating procedural code for MariaDB in dbeaver
I'm trying to create a script that contains a procedure and then call that procedure. I've done this at work where we use Oracle, but no matter what I try with mariadb, I get an error. So I copied ...
- 1
0
votes
2
answers
197
views
@export in DBeaver to xlsx
While having the following export command for Oracle script
@export {"type": "xlsx", "producer": {"extractType": "SINGLE_QUERY", "segmentSize&...
0
votes
0
answers
57
views
Kotlin + PostgreSQL native query returns inconsistent results compared to DBeaver with same parameters
I'm executing a PostgreSQL query in Kotlin using prepareNativeQuery and passing named parameters like this:
prepareNativeQuery(sbConsulta, Tuple::class.java)
.setParameter("UNIDADE", ...
0
votes
1
answer
172
views
Value pane horizontal instead of vertical
Last week, when I ran a query and clicked on a column, the value button (that shows the value panel) displayed horizontally under the results pane. Previously it was vertical beside the results pane.
...
- 1,297
0
votes
1
answer
44
views
Result panel overlay/takeover SQL code editor
Suddenly I can't restore the default layout where I had the code.
As mentioned here
No context menu option available at that point to minimize the results
panel to undo the results panel "taking ...
- 162
0
votes
0
answers
186
views
In Dbeaver I got error when making Backup file of the docker-sail data
In laravel 12 app I use "laravel/sail": "^1.41" with postgresql and DBeaver 25.0.0
in DBeaver usong "Tools"=>"Backup" I try to get Backup file of the db data,...
- 3,331
0
votes
0
answers
96
views
"Public Key Retrieval is not allowed" on first login
I'm trying to automate a MySQL connection using DBeaver's CLI with the following command:
.\dbeaver.exe -debug -con "driver=mysql|name=TestConn|host=10.18.1.92|port=3306|user=appsupport|password=...
- 13
0
votes
0
answers
34
views
DBeaver auto completion SQL Server and other (Hana), Quotes
I am using DBeaver (25.0.3.202504201842) with a SQL Server database and other, in this case SAP HANA.
The auto completion places quotes (") around the column names when I am using an HANA ...
0
votes
1
answer
95
views
Why is SQL SUM function returning wrong values using SqLite3 and Dbeaver
I have been taking a SQL course and am in the final project, which started to use SQLite3 on DBeaver. Previously the SQL prompts were written in the course using SQLite.
When trying the aggergate ...
-1
votes
1
answer
316
views
Problems with adding custom plugin to dbeaver /plugin folder
I'm trying to develop a custom plugin for DBeaver. I prepared a simple Hello World plugin and can not run it in my local dbeaver instance.
I tried to add it to /plugins directory in my DBeaver folder, ...
- 1
0
votes
1
answer
507
views
Can't find Filter Option during Search Box of Database Navigator Panel in DBeaver
I am trying to search a specific table name or column or view name in my database in DBeaver , but it is by default Filter connections by name only , Database Navigator Only Showing Filter Connections ...
0
votes
0
answers
95
views
Exporting data via multiple SQL statements and @export command in DBeaver not working
I wrote a SQL script containing multiple SQL SELECT statements, and each is prefixed with a @export command block, defining settings for the producer, consumer and processor.
When I run this script in ...
- 1,029
1
vote
1
answer
33
views
How do I remove the menu listing keyboard shortcuts section in DBeaver
I am not sure how this came up and cant find a way to get rid of this section in dbeaver, can some one please help me with removing this section from my dbeaver UI. I have attached an image for ...
- 77
0
votes
2
answers
247
views
Setting up a DBeaver 25.0.1 connection to a Delta Lake v2.4 Parquet table on Hadoop 3.3.4 filesystem
I am trying to create a new connection from DBeaver to a Delta Lake Parquet file which is located on the HDFS filesystem which I successfully created with a Spark/Hadoop/Scala/io.delta application.
(...
- 11
0
votes
1
answer
474
views
use SQL to delete rows from 2 table DBeaver
i have 2 tables:
books b1
price p1
i want to remove rows from both tables using the following query:
DELETE books FROM price p1 JOIN books b1
ON b1.BOOK_ID = p1.ID WHERE p1.ISBN IS NOT NULL AND p1....
- 1
0
votes
1
answer
5k
views
DBeaver returns getsockopt error after importing project
We use DBeaver to connect to various Postgres databases and an Oracle database. All I can say is that the host is localhost at port 6432, forwarded to a specific intranet cluster, in a specific ...
- 863
-1
votes
1
answer
663
views
DBeaver can't connect to snowflake using private key, throws error "JWT token is invalid"
We can connect to snowflake via Java application using our rsa_key.p8, username and private key password without issue.
However, when we try to do this in DBeaver using the pro version "Private ...
- 12.8k
0
votes
0
answers
116
views
Dbeaver says column 'MONTH' cannot be found, however I am clearing not referencing a column for 'MONTH' or 'DAY'
sql script
I don't understand why the following script and screenshot above is showing the 'MONTH' column as not being recognized. This is clearly not a table column and it is an input for the ...
0
votes
0
answers
106
views
Dbeaver Generate SQL function adds unwanted escape characters
Often I want to make copies of a report in my reports table for some small modifications. Then I always query the report I want to copy select * from reports where id = 1 After that I right click on ...
- 693
-2
votes
3
answers
784
views
dBeaver - how to disable table names in column name inserts
After a recent update to 24.3.5 community edition, the auto completed for column names is now including the table name when it inserts the column name. I can not figure out how to disable this in the ...
0
votes
1
answer
172
views
Can I see timestamp in dbeaver in human readable format?
In MySQL 8 app table sessions has date defined as last_activity int NOT NULL.
I see timestamp in dbeaver 24 as an integer value and I wonder if there is a way to format this date in human-readable ...
- 3,331
1
vote
1
answer
273
views
How in dbeaver search columns in table with many columns?
When I use dbeaver Version 24.3.0.202412011650 if there is some kind of search of columns,
when opened table has many columns ?
Thanks!
- 3,331
1
vote
2
answers
167
views
Connect to PostgreSQL database in Docker container using 3rd party application
I'm running a multi-container in Docker Desktop where one of the containers holds a PostgreSQL database. When I print the data in the terminal it's rather difficult to read well since its not ...
- 66
0
votes
1
answer
67
views
Connecting with DBEaver Strange Table appears
I'm Using DBeaver 24.3.2, SpringBoot 3.4.1, Java 21.0.5, flyway 11.2.0. The persistence library are all inherited from spring-data.
I recently switched to SpringBoot 3.4 and, doing an example project, ...
- 787
0
votes
1
answer
347
views
Error connecting to embedded DB with DBeaver
I'm using SpringBoot 3.4.1, Java 21.0.5, H2 database 2.3.232. follow my application.properties:
spring.datasource.url=jdbc:h2:mem:rest;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;AUTO_RECONNECT=TRUE;
...
- 787
0
votes
1
answer
548
views
DBeaver temp table workflow
In SSMS I could create something like the temp table below. I could then run queries, joins, or additional temp table/cte creations off of #apps while only clicking the execute button ONCE.
SELECT
...
0
votes
1
answer
284
views
DBeaver @export command with SQL script
DBeaver Version: 23.2.4.202311051706
Database: Informix
O.S.: Windows 10
I have a script file that I want to export the results of multiple select statements. Below is an example of the script.
-- ...
- 51
2
votes
1
answer
172
views
Insert literal '${value}' without variable substitution into PostgreSQL table from DBeaver
I'm trying to do an insert like this into my PostgreSQL table:
INSERT INTO table (path, regex, replacement_path, uri)
VALUES ('/api/foo/**', '/foo/(?<value>.*)', '/foo/${value}', 'http://...
- 21
0
votes
2
answers
155
views
I can't create a Sql database locally within my custom directory on Linux Mint Cinnamon 22
I'm learning SQL and can't figure how to create my database .mdf and .ldf files in the desired directory.
First, I can't use SQL Microsoft Server on Linux (or it's just thats it is to hard for me to ...
0
votes
0
answers
54
views
How to unnested a nested structure inside another nested structure?
I need to create a view for a database in DBeaver. It has one column with nested structure with another nested structure inside.
Nested(person_id String, person_name String, person_params Nested(key ...
0
votes
1
answer
882
views
DBeaver can't connect to Firebird
I want to register a connection DBeaver 24.3.2 to a Firebird 5.0.0.1306 server but this seems to be an impossible task.
I'm getting the following error message:
Your user name and password are not ...
0
votes
0
answers
296
views
How make DBeaver display nested structures correctly, with all keys and values?
Working with a Clickhouse database through DBeaver, and there are some columns with nested elements.
Nested(item_id String, item_name String, item_brand String,
item_variant String, ...)
But in the ...
2
votes
2
answers
225
views
MariaDB sensivity to accents but not case sensitive
Got a MariaDB version 10.6.18-MariaDB-0ubuntu0.22.04.1-log. I'm using DBeaver to connect.
Got a table with a single text field VARCHAR(50). It can't be null and it cannot contains duplicates.
My ...
-1
votes
1
answer
146
views
Incorrect syntax near semicolon after `MERGE` [closed]
EDIT: I believe the root of the problem is how dbeaver behaves with semicolons and GO. This issue is not reproducible outside of dbeaver, hopefully this is helpful to someone.
I've been handed some ...
- 1,158
9
votes
5
answers
22k
views
Error fix : Dbeaver driver error : Maven artifact:org.postgresql:postgresql:RELEASE' can't be resolved in External Repositories
I have been using Dbeaver for many days but for the past few days while I am connecting to my Staging server through PostgreSQL, I am getting these driver errors
Dbeaver driver error : Maven artifact:...
0
votes
0
answers
95
views
Dbeaver customizing column and table name colors
I've been customizing my environment in Dbeaver, however I noticed that when using BEGIN statements the colors of the column and table names are lost and become the color of the plain text
Does anyone ...
- 1
0
votes
0
answers
70
views
Executing queries in dbeaver with variables doens't allow any other statement written next
I have a table called tb_person with two fields: id (numeric(22)) and name (varchar(255).
Using dbeaver version 24.0.4.202405051837, when I try to set a variable, use it as a where statement and order ...
1
vote
0
answers
40
views
How to see Cassandra UDTs in dBeaver
I think the title is clear. I followed the instructions to connect to a Cassandra DB in dBeaver successfully but UDTs (a frozen List<Media>) is not showing.
Copying the column value returns this:...
0
votes
0
answers
1k
views
Cannot connect ClickHouse to DBeaver
I'm trying to connect my ClickHouse Server to DBeaver and I'm getting this error:
We didn't encountered this problem when we're trying to connect other database such as mariadb and vertica.
How could ...
- 1
0
votes
0
answers
32
views
does not import data into the operations table
i want to do trigger code with import updates and inserts (table doctors to table logs(all operations when i update or delete)
DROP database IF EXISTS vk;
CREATE database vk;
USE vk;
DROP table IF ...
0
votes
0
answers
799
views
Only an ET or null statement is legal after a DDL Statement
I'm trying to run a statement in Teradata, using DBeaver 24.2.
When I run my statement in Teradata SQL Assistant, it runs perfectly, but when I run it using DBeaver, I'm getting the following error:
...
0
votes
1
answer
785
views
DBEAVER Table not found
The table in question exists and my query works fine, I can see the data.
But there is a red line under the table name, when I hover it says "Table XYZ not found".
I tried looking for the ...
- 1