The results are in! See what nearly 90,000 developers picked as their most loved, dreaded, and desired coding languages and more in the 2019 Developer Survey.

Questions tagged [dbeaver]

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

-1
votes
0answers
11 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
46 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 ...
-1
votes
0answers
6 views

How to Connect Enterprise GitHub Repo to DBeaver?

I want to push my sql code to enterprise GitHub through DBeaver. I can connect my personal repo which has github.com domain but unable to connect enterprise repo. What should I do? Do I need to ...
1
vote
0answers
53 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
24 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
39 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
8 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
18 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
38 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
14 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
35 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
0answers
28 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 ...
0
votes
1answer
17 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
26 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
46 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 ...
0
votes
0answers
78 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
18 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
115 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
98 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
144 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
48 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
249 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
34 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
60 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
55 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
129 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
83 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
28 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
15 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 ...
0
votes
4answers
53 views

Summarize unique combination of field values found in table

How to summarize how many records are returned from all combinations of 2 fields, where each field has 3 possible values (Y,N,NULL)? The target is a table like the below and a query to quickly ...
0
votes
1answer
669 views

In DBeaver, how can I run an SQL union query from two different connections..?

We recently migrated a large DB2 database to a new server. It got trimmed a lot in the migration, for instance 10 years of data chopped down to 3, to name a few. But now I find that I need certain ...
1
vote
0answers
357 views

SQL Server stored procedure with dbeaver

I need to create a stored procedure in SQL Server using the Dbeaver software and I am wondering if you have any experience with creating one with this software since I am using Mac and I am not able ...
0
votes
1answer
57 views

Problems with setting the dataType in the dBeaver

Whenever I try to choose a data type for any column I get this message. I don't type by myself but choose from drop-down menu instead. Details message as follows, Error setting property 'dataType' ...
0
votes
1answer
243 views

DB2 - Multiple Result-Set Stored Procedure

So first off - I'm not sure if my problem lies with my DB2 code, or with my settings on DBeaver. I have an issue when running the following code where only one result set is being displayed in ...
0
votes
1answer
29 views

Impala - Calculate Percentage From One Table

I have this kind of table, named it as table_A Cust Amount Src_cust A 2000 B A 3000 C A 1000 B C 1000 B ...
1
vote
0answers
76 views

Can't connect to a SAS database from dBeaver

I'm trying to use dBeaver to connect to a SAS database. I've created the connection with the SAS drivers but I get that message when trying to connect: >org.apache.log4j.Logger >Can't create ...
0
votes
0answers
643 views

Create new schema in PostgreSQL using DBeaver

At the beginning of my current job I had limited access to DB but recently my role is changed to superuser, admin, and owner. My colleague who was the previous DB admin is able to create a schema or ...
0
votes
0answers
20 views

Cutting source on procedure

I'm using sybase as connection on DBeaver. When I go to Procedure and choose one, I select View Procedure to see the source code. But don't know why but my procedure it's cut without apparent reason....
-1
votes
1answer
50 views

Invalid identifier error when using RIGHT JOIN inside FROM clause

I want to use within a FROM a subset of 2 tables using RIGHT JOIN (I want from that subset all the rows of ITV2_VEHICULOS whose ID is not in ITV2_HIST_VEHICULOS) so that the SELECT "takes" the data ...
0
votes
0answers
59 views

An error occurred while installing Git for DBeaver

Please, help! How to deal with the following issue? While installing Git from Oxygen - http://download.eclipse.org/releases/oxygen/ An error occurred while collecting items to be installed session ...
1
vote
1answer
41 views

Get data from multiple selects in PostgreSql (using DBeaver)

I have a table like this: 10/10/2018 00:00 | 5 10/10/2018 00:10 | 7 10/10/2018 00:20 | 9 ... 10/10/2018 23:40 | 5 10/10/2018 23:50 | 6 I need to get average number in hour, and return all hour ...
0
votes
2answers
61 views

Move data between different servers

I'm working on a project where I need to automatically run an insert statement to insert a result set - problem is that I need it to go from a SQL Server over to a DB2 server. I can't create a file or ...
0
votes
0answers
142 views

Postgres Kerberos authentication fails from DBeaver with 28000: GSSAPI authentication failed for user

I have setup kerberos/GSSAPI authentication for Postgres 9.6. It works successfully on the Linux DB server, but fails when connecting from my Windows desktop DBeaver application. The error message ...
0
votes
0answers
68 views

How to link Excel with DBeaver?

The data I queried from DBeaver was initially from MySQL, I would like to Link the table from DBeaver directly to my Excel, is there a way to do it? I don't have MySQL downloaded to my computer.
0
votes
3answers
254 views

dBeaver (CE): DB2 LUW Connection with SQL ERROR 42704. Table Schema won't open but able to write SQL queries

After about a year and half, I am finally able to connect to the DB2 database we have through dBeaver. The connection is successful as a LUW (Our db2 is z/os). I was able to get the drivers required ...
2
votes
1answer
89 views

Turn select * into individual field names in DBeaver

I stumbled upon one of the most amazing features in DBeaver, where I had: select * from foo And I hit some key combination that turned * into an individual list of field names: select field1, ...
0
votes
0answers
112 views

Can't run Dbeaver

I want to use Dbeaver, so I make a directory called dbeaver in C:\ directory and then I added it to environment variables and when I run it, it shows this error : !SESSION 2018-10-10 16:43:38.109 ---...
0
votes
0answers
12 views

Error 1215 mysql error duringtable creation

I have two existing tables named as way_bill and payment_reconciliation need to create a join table as 'payment_recon_waybill_mapping' but giving 1215 error on way_bill constraint please help CREATE ...