Stack Overflow
Stack Overflow

Questions tagged [dbeaver]

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

  • Usability is the main goal of this project, program UI is carefully designed and implemented.
  • It is freeware.
  • It is multiplatform.
  • It is based on an open-source framework and allows the writing of various extensions (plugins).
  • It supports any database having a JDBC driver.
  • It may handle any external datasource which may or may not have a JDBC driver.
  • There is a set of plugins for certain databases and different database management utilities (e.g. ERD).
1047 questions
0
votes
1 answer

Receiving SyntaxError: line 1:126 missing EOF at 'LIMIT' (... WHERE language = uk; [LIMIT] 200)

Using DBeaver to access a table in Cassandra. I can view the data without any issues, but when I enter my SQL expression to filter results I receive the following error: SyntaxError: line 1:126 missing EOF at 'LIMIT' (... WHERE language = uk;…
AST
  • 11
  • 1
  • 9
0
votes
2 answers

Why is DBeaver trying random ports when trying to connect to Cassandra?

I have Cassandra running on a host that i can assess via SSH. When I want to connect with DBeaver, I am using the following connection settings: Connection: Host/Port: localhost:9042 SSH-Tunnel Host/Port: my.remote.host:37938 On connect, I am…
spike
  • 432
  • 1
  • 6
  • 15
0
votes
0 answers

SQL: Closest timestamp to max(timestamp)

I am looking for the date from one table that is closest to the maximum date of another table. So the closest event.end timestamp to max(timestamp) from another table. Currently i'm trying it in this way: SELECT users.id as userID, …
Stefan Musch
  • 35
  • 1
  • 7
0
votes
1 answer

Converting date format in denodo database

I'm trying to convert value for DIM_DT_ID to MMddYY. I'm successful in doinf that. However, query fails because ultimately I'm comparing a character value to date here. Is there a way by which I can get value for DIM_DT_ID in MMddyy format and its…
Ajaya Rk
  • 5
  • 1
  • 7
0
votes
0 answers

derby server refuse connection to database with boot password

i have derby server with database created with boot password while connecting to it in derby the connection refused. where i write my boot password as connection property. how to write connection URL manually? or where to write boot password?
user3762548
0
votes
0 answers

NoHostAvailableException in DBeaver when connecting to remote Cassandra docker container

I have a Cassandra instance running in a Docker container on an Intel NUC. From my mac, I can ssh onto this and connect to the cqlsh fine. However, when I try to connect using DBeaver Enterprise I…
MeanwhileInHell
  • 6,780
  • 17
  • 57
  • 106
0
votes
0 answers

While-loop end error mysql

I am using DBeaver and here is the code of mysql procedure: drop procedure if exists transfertweets; create procedure transfertweets() BEGIN set @id_lower = 13505; set @id_end = 14118801; set @batch = 6; set @id_upper = 13505; while @id_lower <…
Anonymous
  • 93
  • 2
  • 9
0
votes
0 answers

time taken by normal query vs case containing query?

what amount of time gets increased when we use case statement in MYSQL query vs without case statement in INSERT QUery ?
Vikas Tiwari
  • 23
  • 1
  • 9
0
votes
0 answers

Getting error when converting timestamp column to time

I am getting the following error message, when trying to convert timestamp column to time. Error message: SQL Error [500310] [0A000]: [Amazon](500310) Invalid operation: Specified types or functions (one per INFO message) not supported on Redshift…
RustyShackleford
  • 3,462
  • 9
  • 40
  • 81
0
votes
1 answer

DBCException: SQL Error [50000] [HY000]: General error

i am trying to compile this procedure using Dbeaver editor for H2 databse but it doesnt compile and give errors script is Create Alias InsertDepartment AS $$ int InsertDepartment(Connection conn,String p_eName,String p_aName ,int p_sec_id) throws…
Dunken
  • 1,311
  • 7
  • 18
  • 30
0
votes
1 answer

Dbeaver icon is blurry on MAC

When you run Dbeaver on Mac and the application loads. The ICON in the DOCK becomes blurry. As if its very low quality. Any way to fix it? No! the refresh of the DOCK icons does not help. Its picking up the running ICON from somewhere else in the…
Raven
  • 29
  • 4
0
votes
2 answers

DBeaver simple query ORA-00911 invalid character

I am switching from SQLDeveloper to DBeaver in my work with Oracle 10G database, have the Oracle instantclient for the exact version of the database. I do not make scripts, just a bunch of queries, like select, update. I had a collection of them,…
uldics
  • 117
  • 1
  • 11
0
votes
1 answer

ORA-00907: missing right parenthesis IN DBeaver while setting NOT NULL DEFAULT

when i am executing query in dbeaver I am getting missing right code paranthesis error CREATE TABLE PersonsNotNull ( P_Id int NOT NULL, LastName varchar(255) NOT NULL DEFAULT 'KHATTAR', FirstName varchar(255), Address varchar(255), City…
simba
  • 277
  • 4
  • 19
0
votes
1 answer

How can I alter a table definition in Cassandra using only DBeaver?

I am currently working on a Cassandra (CQL) database and I use a DBeaver as graphical client. How can I do alter a table and insert data into that table using only DBeaver?
Nirali Kavar
  • 956
  • 2
  • 8
  • 17
-1
votes
5 answers

Join two tables with almost the same fields and check when two fields are different

I need your help and I'll try to explain with a simple example. I have Table A: NAME CITY AGE Lucas Dallas 21 John Chicago 30 Tim London 15 and Table B: NAME CITY AGE Lucas Dallas 21 John Chicago 45 Tim London 15 I…
Cristina Biagiotti
  • 9
  • 1
1 2 3
…
69 70