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
11
votes
6 answers

Can you help me to fix the connection with my DBeaver?

I don't speak English, sorry. I have this message to my DBeaver Can you help me to fix the problem ? Network error Motif: Network unavailable: javax.net.ssl.SSLHandshakeException:PKIX path building failed:…
Loïc YOLA
  • 111
  • 1
  • 1
  • 3
11
votes
2 answers

How to use DBeaver to connect to SQL Server? The server SQLEXPRESS is not configured to listen with TCP/IP

I am trying to use DBeaver (7.3.2) in Window to connect to my SQL Server 2019 Express in the same machine. In my SQL Server 2019 Express, I have a sample Northwind database loaded successfully. I have tested the connection in SQL Server 2019 using…
Steve
  • 2,963
  • 15
  • 61
  • 133
11
votes
3 answers

Multiple SQL query not working with delimiter on DBeaver

I can't execute MySQL statement when using delimiter (default ';'). I mean, when I run query like: select * from mdw.dim_date dd limit 10; select * from mdw.dim_order do limit 5; I've got such error: SQL Error [1064] [42000]: You have an error in…
user14261502
  • 121
  • 1
  • 1
  • 5
11
votes
1 answer

Unable to connect to MariaDB using DBeaver

I just installed MariaDB 10.1.29 on Ubuntu 18.04. From the command line I can connect using sudo: sudo mysql -u root -p But not without sudo. Also, if I try to connect to the database through DBeaver, I get: Could not connect: Access denied for…
wout
  • 2,477
  • 2
  • 21
  • 32
10
votes
2 answers

can't access db tables from dbeaver ([SQLLITE_BUSY] database file is locked (database is locked))

First of all, I realize similar questions have been asked but none of them seem to have the same problem and I can't find a solution. I can create tables and do write/read operations perfectly well within python accessing my SQLlite database.…
PretendNotToSuck
  • 384
  • 2
  • 10
10
votes
1 answer

How do I connect to Cassandra with Dbeaver Community edition?

Has anyone had any success with connecting to a Cassandra cluster using DBeaver Community Edition? I've tried to follow this post, but haven't had any success. I have to have authentication enabled, and I get an error saying: Authentication error on…
Joel
  • 8,502
  • 11
  • 66
  • 115
10
votes
1 answer

Import SQL file to DBeaver

I'm using the DBeaver to handle with databases. |/MariaDB-mysql |-- /information_schema |-- /mysql |-- /performance_schema |-- /autoparanaiba I want to run some .sql file inside the autoparanaiba but I didn't find the IMPORT.
Vagner Wentz
  • 391
  • 1
  • 7
  • 29
10
votes
0 answers

How to change DBeaver autocompletion key?

Is there a way to change the auto-complete key from return to tab? I don't see it under the "auto-complete" settings, and I'm not finding anything promising under the "keys" setting either.
Chris Curvey
  • 9,738
  • 10
  • 48
  • 70
10
votes
1 answer

Is there a way to define the names of the result tabs names in an SQL Script in DBeaver?

I'm creating a MySQL Script that runs on a record and pulls associated records from a series of other tables, which is super useful but in DBeaver the results come back as tabs that only have the name of the table the results come from, which is…
Dri
  • 492
  • 4
  • 13
9
votes
0 answers

How to open MySQL Workbench ER model in DBeaver

I have made a move from MySQL to MariaDB and the only open source database client/tool is DBeaver. But I have some ER models (.mwb) that I had created in MySql Workbench. I need to know if it is possible at all to somehow import and edit those…
Singam
  • 443
  • 3
  • 12
9
votes
1 answer

DBeaver - Clickhouse - SQL Error [159] .. Read timed out

I'm getting "Read timed out" when running a query on a 1,3b row db. It is not a particular advanced query that groups together hashtags in tweets: SELECT case when match(hashtag, …
questionmark
  • 147
  • 1
  • 2
  • 5
9
votes
1 answer

Dbeaver automatically puts letters behind my queries

Dbeaver automatically puts the starting letters of the table behind the full name, if i select a table with the drop down menue and i need to know how to turn it off. Its like this: select * from kalibrierprotokoll_lx_punkte klp
Jan
  • 93
  • 1
  • 4
9
votes
4 answers

Access denied for user 'root'@'localhost' in dbeaver

When I do a test connection in DBeaver in Ubuntu 18.04, I get an error: Access denied for user 'root'@'localhost' I do not understand how to solve this. I can connect to mysql in terminal by sudo mysql. I have also left the database field empty.
sajgkh
  • 103
  • 1
  • 1
  • 6
9
votes
3 answers

Associate SQL Script with Database

I have been using DBeaver as a replacement for SQL Server Management Studio, and I am loving it. The only thing I cannot figure out is how to associate a script with a database. For example, in SSMS I can right click a database (let's call it A)…
Jason
  • 2,493
  • 2
  • 27
  • 27
9
votes
3 answers

How to create a SQL Server database using dBeaver?

How to create a database in SQL Server 2014 using the dBeaver GUI tool?
koverflow
  • 297
  • 1
  • 3
  • 10
1 2 3
…
69 70