Questions tagged [dbeaver]
DBeaver is free universal database tool for developers and database administrators.
23
questions with no upvoted or accepted answers
11
votes
1
answer
9k
views
DBeaver launch script from file
I'm trying to find a good alternative to SQL Developer for performing queries and scripts on Oracle instances.
I find DBeaver to be an interesting tool, it has a lot of great features, BUT it seems ...
- 111
2
votes
0
answers
3k
views
DBeaver connection via SSH tunnel
Using DBeaver, I'm trying to connect to my AWS ec2 instance where I've installed a MariaDB database.
I've created a new connection as:
Connection: AWS / Maria DB
Server Host: localhost (because I'm ...
- 121
2
votes
0
answers
4k
views
Postgresql 10: Can not establish DB connection
I have created a new database and user in Postgresql 10 named 'reportingdashboardproject' and 'repadmin' respectively. I used the following commands to create and grant privileges:
postgres=# create ...
- 129
2
votes
1
answer
2k
views
Is it possible to run MongoDB javascript scripts in DBeaver
DBeaver's wiki shows a simple query against a Mongo database but what about admin scripts? It would be great to develop these in DBeaver but I've tried a few permutations to no avail.
Here's an ...
- 131
2
votes
0
answers
1k
views
Umlauts in DBeaver
I have a Postgres Database set to UTF-8. I am working with DBeaver 3.1.4, and it seems to use a different encoding than UTF-8 (I suppose Latin-1 or something), which leads to
1) wrong display in the ...
- 123
2
votes
2
answers
1k
views
push using git integration in DBeaver
I am using the git plugin for DBeaver. While I can commit, I am not seeing an option to push the commit over to master. Am I missing something?
- 121
1
vote
0
answers
2k
views
Dbeaver restore database Error 1277 you need the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege for this operation
I'm attempting to import a .sql file to restore a database(hosted on AWS RDS) however this error keeps coming up.
ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER, ...
1
vote
0
answers
405
views
How can I share virtual key in DBeaver for other device?
As I know, the virtual key in DBeaver just existed on the client-side (local device), not in real database. I want to share this virtual key for other devices (not only my device). How can I do that?
- 11
1
vote
1
answer
711
views
IDE Access to Hive without user password?
I'm a DB Developer and in my company we're only able to interact with hive through a technical user who owns the specific write permissions for Hive on HDFS.
So in practice this looks like this:
I ...
- 181
1
vote
0
answers
329
views
How do you resize tables in an erd diagram in DBeaver?
When I click on a given table in an erd diagram in DBeaver I simply cant resize it. The table names get cut off. What am I missing ?
- 11
1
vote
2
answers
1k
views
PgAdmin4 unusable when database has lots of schemas
I have a production database with 60K database schemas. PgAdmin4 is unusable, I cannot even open "Query Tool" window. I suppose that PgAdmin tries to load database metadata, so that's the reason why ...
- 165
1
vote
1
answer
2k
views
How to configure DBeaver to save files without a BOM for UTF files?
I am looking for the equivalent setting as the PGADMIN setting Write BOM for UTF files which will cause saved files to be saved with/without the BOM.
I've found settings in DBeaver when exporting ...
- 615
0
votes
0
answers
426
views
PostgreSQL Server Timeout Issue with pgAdmin, pgAdmin Web, and DBeaver
I am using PostgreSQL 15.4 on Ubuntu 22.04. Initially, I used pgAdmin 4 for managing the database. However, I've been facing an issue where pgAdmin stops responding after some time. This issue seems ...
0
votes
1
answer
261
views
DBeaver connection to Postgres server stuck on "Read Data from Container"
I am currently trying to view a postgres database. However, it is stuck on "Read Data from Container" for several hundred seconds. This all happened after I deleted a table and recreated it. ...
0
votes
0
answers
356
views
DBeaver database export not exporting foreign keys
I have DBeaver 23.1.0 on Windows.
I want to export tables (PostgreSQL) from Database A to Database B, including foreign keys.
What I found out was to mark all tables from Database A -> Right click -...
- 111
0
votes
0
answers
86
views
I want to simplify my sum query using loop function
I have a query to summerize my data based on month between year 2021 - next years (depend on the real date)
i used simple query like this to summerize the amount monthly
SUM(IF(pt.description like '%O-...
0
votes
0
answers
33
views
SUM which adds together figures collected on the same date
For example all data collected on 1/1/22 would all added together and outputed as one result and data collected on 2/1/22 would all added together be another result. I will add my query bellow to help ...
0
votes
1
answer
305
views
Access Oracle Database remotely via DBeaver
I have two machines, a windows 10 notebook with oracle database installed, and a Raspberry Pi 4 with DBeaver installed. On the Raspberry I have PostgreSQL which I can access locally via dbeaver, but ...
0
votes
0
answers
589
views
Why multiple statements executed in single run takes more time than when those statement run individually?
I am running following queries from DBeaver app connected to Postgres.
Statement1:
-- create 1000 rows in table2
do $$
declare
begin
for r in 1..1000 loop
...
- 1
0
votes
0
answers
1k
views
Unable to Execute Script files (.sql) in MySQL using DBeaver plugin, in Eclipse CDT with macOS Catalina (Shows, "No Active Connection")
Unable to execute the script files (.sql).
It shows "No Active Connections".
But, test connection is complete, and localhosr has MySQL Icon with connection check mark, and I refreshed the ...
- 1
0
votes
2
answers
10k
views
Data truncation: Incorrect datetime value: '7/21/15' for column 'announced_on' at row 1
I am importing a flat file into a table in DBeaver v7.0.2. When I attempt to import, it's throwing an error for date field formatted as mm/dd/yy.
The date column in the table is defined with ...
- 129
0
votes
0
answers
201
views
Query with LVARCHAR performance in Informix DB
In a maintenance project that it's working with IBM Informix Dynamic Server Version 11.50.FC6 we have to improve the performance of some queries.
One of this queries to the Informix DB fetches a ...
- 1
-1
votes
1
answer
544
views
DBeaver is failing to execute any on SQLite. "[SQLITE_ERROR] SQL error or missing database"
I'm trying to use DBeaver to manipulate an SQLite database and, pretty much any operation I try on the database schema, like creating a table or column, it fails with:
SQL Error [1]: [SQLITE_ERROR] ...
- 941