Questions tagged [dbeaver]

DBeaver is free and open source (GPL) universal database tool for developers and database administrators.

0
votes
0answers
4 views

how do I get DBeaver to show a Save button?

I want a save button that I can click with the mouse, but when I focus on a SQL editor page and file and do >Window >Customise Perspective >Edit actions, it's greyed out and says "Save (Ctrl+S' ...
0
votes
0answers
31 views

Export File Name

When I'm exporting data in DBeaver i'm using ${table} and a number is now incrementing on the file name. I have changed every setting out there that I"m aware of. Tried different extensions. I'...
0
votes
0answers
16 views

How to fix 'Missing requirement' error in Maven on Windows

I'm trying to build dbeaver and get the following error when running mvn package: [ERROR] Cannot resolve project dependencies: [ERROR] Software being installed: org.jkiss.dbeaver.slf4j 1.0.0....
0
votes
0answers
16 views

How can I fix dbeaver light theme text display?

I'm using dbeaver 6.0.4 on Manjaro+i3wm 4.14. some text color is similar to background. When I switch dark theme everything is ok. I have tried all the light theme and I don't want to dark theme. what ...
0
votes
1answer
25 views

DBeaver, How to declare variables and use them?

i just want to know if it is possible to declare variables on the DBeaver´s sql editor and use them on a query
0
votes
1answer
8 views

dbeaver: how can I export connection configuration?

I recently got a new macbook pro for work and I'm in the process of migrating a lot of my settings from my old machine. I was hoping that there is a way to export the connection configuration/...
0
votes
0answers
12 views

error 5764, can´t edit data type of a field in DBeaver

im trying to change the type of data of a field in a table on DBeaver but show me and error --> [Vertica]VJDBCROLLBACK: Cannot alter the data type of a table column when a node is down <-- the ...
-1
votes
0answers
12 views

Dbeaver export table as json file

I want to export json data for Dbeaver without whitespaces, already i got format: [ { "var1":"output_var1" } ] Needed format: [{"var1":"output_var1"}]. I got format like this from mysql ...
0
votes
1answer
48 views

DBeaver will not allow me to join tables or run window functions

I'm using DBeaver PostgreSQL and I'm trying to join two CSV files but I get an error stating, "SQL Error: Syntax error: JOIN not supported". In addition, I am unable to run window functions. SQL ...
1
vote
1answer
30 views

Truncate/Drop table in DBeaver right click menu/GUI

I am trying to find an option to truncate table in the right click menu or somewhere in the GUI of DBeaver. The database is SQL Server. Is there any other option rather that explicitly writing the ...
1
vote
0answers
17 views

DBeaver/Oracle wrong datetime pattern includes .0 at end

Using DBeaver and Oracle, select querys shows date in a wrong format, which always includes .0 at the end, like 2019-05-17 16:10:47.0. To update/insert any date column in a table, on DBeaver editor, ...
0
votes
1answer
50 views

How to update records of a database permanently?

I am using DBeaver to connect to a Microsoft SQL Server database. I want to update all users' login count to zero. I have tried running an update command as follow UPDATE app.dbo.users SET ...
0
votes
0answers
18 views

Connecting to MySQL server from dbeaver gives says Check if “useSSL” is set to “true”

I am trying to connect to remote MySQL instace from DBeaver 6.0.4. My connection settings looks like this: Above, the server host is specified as follows: hostxyz.amazonaws.com:443/?...
0
votes
0answers
8 views

How to automatically close DBeaver when I log off Windows

I use DBeaver on Windows Server 2008 R2. But after I log off my Windows session, if I did not close my DBeaver application explicitly before logging off, the DBeaver application would stay running ...
0
votes
1answer
44 views

SQLServer with DBeaver. Login failed for user 'sa'. ClientConnectionId:

I'm trying to connect to SQLServer with DBeaver on MacOS using these settings: And I keep having the same error: "Login failed for user 'sa'. ClientConnectionId:bab6f002-ac7c-4125-b8e8-...
0
votes
0answers
25 views

SQL IDE runtime display format

This may be a dumb question, but my google searches aren't returning much of anything related. At the bottom of multiple SQL IDEs I see the number of returned rows and two timestamps. What do the two ...
0
votes
0answers
31 views

Is it possible to export sql queries in JSON format in Dbeaver?

I am trying to figure out a way to get Dbeaver and matillion redshift in sync using github. Matillion doesn't accept sql files as input, so I want to convert my dbeaver queries into JSON format which ...
0
votes
1answer
159 views

Docker MySQL connection DBeaver

I just finished following this Docker tutorial on youtube: https://www.youtube.com/watch?v=SXY0MLHP3hA&lc=Ugzp3vKtSOp0rn2lYyd4AaABAg I was able to create a couple of Docker containers for PHP ...
0
votes
1answer
16 views

How to filter table name not a database name in Navigator. It seems there's no option for filtering

As you see, it's Database name to filter. There's just few databases. So no need to filter 'Database name`. I need to change it to 'Table name to filter'. But it seems there's no option for it. Weird ...
0
votes
1answer
30 views

cannot pass a list of int as a variable

I am using DBeaber 6.0.3 and trying to make this query declare @samplesList table (id int); insert @samplesList(id) values(1121),(2121),(3121); SELECT * FROM samples where samplesId in (select id ...
-1
votes
1answer
29 views

How to connect to database via VPN?

I have installed OPENVPN client on linux mint. I am able to connect to it and access the client's jekins server, etc. via browser, however I am not able to connect to their database through dbeaver or ...
0
votes
0answers
71 views

Cannot transliterate character between character sets

I'm updating data in column [S.STATUS] and get an error: SQL Error [335544565] [22018]: arithmetic exception, numeric overflow, or string truncation; Cannot transliterate character between ...
2
votes
0answers
419 views

How to create a database backup in DBeaver and restore it?

I need to create a SQL server database backup in DBeaver and restore it. Is that possible? Using SQL Management Studio would not be a turnaround solution in this case, as we are not allowed to use it ...
0
votes
0answers
35 views

Dbeaver doesn't delete columns in gui

I choose some rows, then tap to delete rows and then tap on Save. But it's don't delete rows from table. What am I doing wrong? My table haven't primary key. When I try to delete sime rows at the ...
0
votes
1answer
86 views

64-bit DBeaver can't connect to ODBC source - “Parameter number out of range.”

I have a program on a server running Pervasive SQL. I can connect to it via an ODBC connection running the Pervasive ODBC connector. In the Windows ODBC Manager(s) I can create sources and connect ...
0
votes
1answer
16 views

How to sort databases alphabetically in DBeaver Database Navigator

In the Database Navigator the databases are not sorted alphabetically. This is a pain to use when you have many databases on a server.
0
votes
0answers
54 views

DBeaver SSL is disabled

I am trying to access elasticsearch instance through DBeaver, and getting the error SSL is disabled when trying to access the connection string. the connection properties interestingly, the SSL tab /...
0
votes
3answers
41 views

How can I pinpoint a syntax error in MySQL

I can't pinpoint the syntax error in this simple procedure and it's driving me mad by this point. DELIMITER $$ DROP PROCEDURE IF EXISTS address_insert$$ CREATE PROCEDURE address_insert() BEGIN ...
0
votes
0answers
20 views

Change dbeaver autoassign table mappings

I am trying to turn a sql server database into a mysql database using dbeaver. However, I when a value in my sqlserver is of type nvarchar(-1) I want it to map to type TEXT in mysql. but the auto ...
0
votes
0answers
38 views

clickHouse insert faild,it no data in table

I deleted specified data by Alter delete grammar. Then, I want to insert data by Insert into format CSV grammar in myself program, but I find no data in the table(first photo), now, It is successful ...
0
votes
1answer
98 views

How to find execution time instead of execution + fetch in DBeaver

Is there any way to see actual query execution time in DBeaver while running SELECT statements in PostgreSQL? I'm only seeing X row(s) fetched - XXms in the Results window and what I'm interested in ...
1
vote
1answer
25 views

does the file extension matter to DBeaver?

I have a SQL script file with the extension.pgsql When I open it in DBeaver, it does not seem to recognise it as a SQL script and removes all options such as execute, etc... If I change the ...
0
votes
0answers
48 views

How to add a unique id column to imported csv table in DBeaver (PostgreSQL)

In DBeaver I have a table that I create by importing an CSV file. However this csv file does not have a unique identifier/column associated with it. I tried adding in a new id column to the table but ...
0
votes
1answer
163 views

DBeaver how to switch database in sql editor

I'm using DBeaver with Postgres. I can open a new sql editor with ctl+[. But I have multiple databases in my Postgres. How can I have the sql editor run against another database? the following doesn'...
0
votes
0answers
10 views

IN filter can't keep track of the marked values when another text is typed

I am using IN filter on dbeaver, however when I type on the search box, all the previously selected values are reset; when I type another value, the previous one is deleted and so on. Is there is ...
1
vote
0answers
162 views

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.
1
vote
1answer
19 views

How to sum multiple rows based on the id filter criteria?

I have table with record_id and record_value. Query should return all id's and values but at the same time I need to return sum for specific group of id's. Here is example of my data: record_id ...
0
votes
1answer
268 views

DBeaver DB2 variable usage

I'm currently trying to add some dbeaver parameters to my script. The simple SQL Looks like this: SELECT * FROM CONTRACT WHERE CONTRACT_NUMER = :CONTRACTNUMBER; Now, when I run the Statement, ...
0
votes
0answers
17 views

Ability to add paths as variables

Is it possible to add Private Key paths or paths in general as variables? I think DBeaver is using Eclipse in the background.
0
votes
0answers
193 views

How to setup Cassandra driver in DBeaver 5.3.3

Can someone help me setup the Cassandra driver in DBeaver 5.3.3. I have DataStax installed on my laptop. I think it comes with Cassandra 3.0.x Need the name of the Driver class name as well the ...
1
vote
2answers
257 views

how to calculate date difference and get the output in days?

I am trying to calculate difference between two dates in dbeaver connected to apache drill. ex: date 1 1/27/2019 date 2 2/01/2019 output 1 in terms of days output 2 in terms of weeks
0
votes
1answer
75 views

how to get day of week from date in apche drill sql?

I am using dbeaver connected to apache drill sql , trying to get day of week. For example for '1/27/2019' the day of week is 1, considering sunday as the first day of week. Example 2 : '1/28/2019',...
0
votes
0answers
595 views

DBeaver will not display certain schemas correctly in the Database Navigator

I'm using DBeaver 5.2.5.201811181655 with IBM DB2/400 v7r3. I'm trying to see a schema called WRKCERTO, but Database Navigator will not show it. The schema is there and I have rights to it, and I'm ...
0
votes
1answer
54 views

How to calculate date difference in apache drill sql to get the output in minutes?

I am using dbeaver client connecting to Apache drill hadoop db. Trying to calculate date difference and get the output in minutes. For Ex: Date 1 is 2015-05-17 22:00:00.000 Date 2 is 2015-05-...
0
votes
1answer
99 views

what is the difference between executing a batch and executing a bunch of statements in dbeaver

Is there a fundamental difference in DBeaver between executing a script and executing the same statements as "Execute Statement" instead? With the following PostgreSQL script SELECT TXID_CURRENT(); ...
0
votes
0answers
114 views

MySQL access denied when restoring database

I have sql file and I need to restore that data from another database. When I'm trying to use 'Restore database' and start to restore suddenly a message ERROR 1044 (42000): Access denied for user '...
0
votes
1answer
269 views

DBeaver can only see default PostgreSQL database in connection

I use DBeaver v 5.2.5 on Windows and use it to connect to PostgreSQL databases. To create a connection, I must specify the database and I have no mean to see other databases on the same server. A ...
-3
votes
3answers
98 views

Incorrect syntax near ')'. SQL query is wrong while running on both DBeaver and on java mapper files?

DECLARE @source as NVARCHAR(MAX) = (SELECT md.[source] FROM sports_service.meet.meet_detail md WHERE md.meet_id = #{meetId}) WHERE reg.is_waitlist = 0 AND reg.cancelled_dt IS NULL AND ...
1
vote
0answers
36 views

Why can't I change column properties of derby db using dbeaver?

I am trying to customize the Floreant POS to meet local regulations. I need to change the check numeration and make it start at 0200000001. I found the ID column in the TICKET table, and in the ...
0
votes
0answers
17 views

Does DBeaver have an inline bookmark feature for script editing windows..?

I'm using Dbeaver 5.2.5.201811181655. Does DBeaver have an "inline" bookmark feature for the text (SQL queries) of a script editing window..? I'm aware of the db object bookmarks feature, and I'm ...