For those who are running DB on different machine, you can do the following: First, from where the container is, run docker ps to get the containers details including the Container ID [root@test-001 ~]# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 1b02333fb3b9 tutum/nginx “/usr/sbin/nginx” 6 weeks ago Up 7 days 0.0.0.0:80->80/tcp docker_nginx_1 … Read more
I encountered same issue: every time you get it, you have to allocate more space and run DBeaver itself first with additional flags -vmargs -Xmx*m. Replace * with 2048 or 4096. It doesn’t look like DBeaver takes garbage out when closing the script, so I had to restart application many times to check right amount … Read more
I have faced the same issue, when added a column from script and tried to update data on table from UI. it can solved by disconnecting and connecting to database as DBeaver currently don’t refresh the DDLs.
see capture file below for a detailed explanation. Hope this helps (if still relevant)…
And 30 seconds after posting I found the answer. There is an SQL Editor menu appeared at the top of the screen (not in the Database Navigator). Selecting SQL Editor from that brings up a query window I can type SQL into.
Change the settings on Dbeaver: Right click your connection, choose Edit Connection On the Connection settings screen (main screen) click on Edit Driver Settings Click on Connection properties Right click the User Properties area and choose Add new property Add two properties: useSSL and allowPublicKeyRetrieval Set their values to false and true respectively by double … Read more
For larger files, the more optimally it is edit the .sql file in an external editor and then in DBeaver: right-click on your DB chose Tools / Execute script load your .sql file click Start. This approach is generally more convenient and faster for large files. To do this without an external editor, you must: … Read more
Try to set your database active which you choose to open the schema:
You have to enable variable processing in the “SQL Processing” settings of DBeaver -> Window -> Preferences -> Database -> Editors -> SQL Editor -> SQL Processing. There is a block on Parameters with settings you can change. See the Dynamic Parameter binding section on the wiki. You should then be able to do: @set … Read more
I found another solution: Setting dbeaver.ini file in DBeaver root directory. Open the file: -startup plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar –launcher.library plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.551.v20171108-1834 -showsplash # START: change jre version, not using the one in %JAVA_HOME% -vm D:\ArPortable\Java\jdk1.8.0_171\jre\bin\server\jvm.dll # END # JVM settings -vmargs -XX:+IgnoreUnrecognizedVMOptions –add-modules=ALL-SYSTEM -Xms64m -Xmx1024m # time zone -Duser.timezone=UTC # language -Duser.language=en