When I switch back to the original script, I am back to working with database A without having to manually select from the database list or executing a USE statement. Obviously, switching back to the second script will make database B active again. Unfortunately, in DBeaver, there appears to be only one active database for all scripts. Connect this free, multi-platform database tool to an ODBC data source. DBeaver Universal Database Tool Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.
Major changes since 7.1: Portable sai for mac. Maya for mac 2014.
- Simplified database structure view was added
- Database maintenance tools can be saved as tasks now
- Table and schema size statistics were added in the database navigator
- Import from multiple CSV files was added. Files can be imported into new or existing tables
- Many problems with UI freeze on disconnect or query cancel were fixed
- Database navigator rendering was redesigned
- A number of problems with keyboard shortcuts were fixed
- Git integration was improved: now we show file status in the Project Explorer view
- New database drivers were added: YugabyteDB and SQreamDB
Changes since 7.1.5: Hearthstone bot for mac.
- Problem with database list load was fixed (PostgreSQL, Redshift, MySQL, Oracle, SQL Server)
- Metadata editor: edit property form rendering was improved (non-applicable fields are hidden)
- Performance for table statistics reading was improved
- Data viewer:
- Column ordering was fixed (for custom SQL queries)
- UUID transform: version 2 support was added
- Default database name and default user name were added for many database drivers
- Data export: custom data type formatting support was fixed
- PostgreSQL:
- Cursor fetch was fixed
- Native client was upgraded to version 12
- Table OID support was fixed (PG 12)
- PgPass parser was improved (support for escaped characters was added)
- Oracle:
- Materialized view comment editor was fixed
- View definition reading was fixed (for non-DBA users)
- Table reading now uses DBA views (optional)
- Profile resources metadata reading was fixed
- MariaDB/MySQL: table column resolving was fixed
- CockroachDB: connectivity problem was fixed
- Greenplum:
- Metadata search was fixed (for procedures)
- Table metadata reading was fixed
- Dark theme support was improved (tab folders, toolbars)
- A large number of minor UI bugfixes
Posted in Releases
Hi, for only one specific table on a big database (50 schemas, hundreds of tables) I'm not able to execute SQL query.
If i execute a simple SELECT * FROM TABLE_WITH_PROBLEM the query return 'no data' but if i open the table from data tab on table details i see all data in the table, this problem has been appeared after the DBeaver 3.3.0 version, all successive version present this problem.
if i use the 3.3.0 version everything work as expected, I've tested even the latest 3.4.2 but without any result.
Database is ORACLE 11g, below you will find both table DDL (i feel like is a problem with table structure) And the EXCEPTION fired on log file
the fields name has been replaced with generic name but the name length and name composition (symbols like underscore) are exactly the same of the original one.
CREATE TABLE 'TEST'.'TABLE_WITH_PROBLEM'
('FI' NUMBER,
'FIELD01XXX' VARCHAR2(20) NOT NULL ENABLE,
'FIELD02X_XXXXXXXXX' VARCHAR2(100),
'FIELD03XX' VARCHAR2(20) NOT NULL ENABLE,
'FIELD04XXXX' VARCHAR2(100) NOT NULL ENABLE,
'FIELD05' NUMBER NOT NULL ENABLE,
'FIELD06' NUMBER NOT NULL ENABLE,
'FIELD07XXXX' VARCHAR2(100) NOT NULL ENABLE,
'FIELD08XXXX' VARCHAR2(10) NOT NULL ENABLE,
'FIELD09XXXXXXXXXXXXXX' VARCHAR2(100),
'FI10' VARCHAR2(100),
'FIELD11X' VARCHAR2(13),
'FIELD12XXXXXXX' VARCHAR2(13) NOT NULL ENABLE,
'FIELD13XXXXXXXX' VARCHAR2(20), 
'FIELD14XXXXXXXXXXXXXXXXXXXX' VARCHAR2(20),
'FIELD12XXX' NUMBER(*,0),
'FIELD13XXX' DATE,
'FIELD14XXX' DATE,
'FIELD12XXXXXX' VARCHAR2(100)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE 'TEST'
After executing the query i found below error inside the .log file located on dbeaver metadata folder
!SESSION 2015-07-09 09:05:27.795 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.7.0_51
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=it_IT
Command-line arguments: -os win32 -ws win32 -arch x86_64
!ENTRY org.jkiss.dbeaver.core 4 0 2015-07-09 09:06:02.850
!MESSAGE NullPointerException
!STACK 0
java.lang.NullPointerException
at org.jkiss.dbeaver.model.data.DBDAttributeBinding.matches(DBDAttributeBinding.java:141)
at org.jkiss.dbeaver.model.DBUtils.findBinding(DBUtils.java:564)
at org.jkiss.dbeaver.model.data.DBDRowIdentifier.reloadAttributes(DBDRowIdentifier.java:80)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetUtils.findValueLocators(ResultSetUtils.java:151)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetDataReceiver.fetchEnd(ResultSetDataReceiver.java:129)
at org.jkiss.dbeaver.runtime.sql.SQLQueryJob.fetchQueryData(SQLQueryJob.java:589)
at org.jkiss.dbeaver.runtime.sql.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:325)
Dbeaver Sql Error No Database Selected
at org.jkiss.dbeaver.runtime.sql.SQLQueryJob.extractData(SQLQueryJob.java:664)at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:1273)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetDataPumpJob.run(ResultSetDataPumpJob.java:131)
at org.jkiss.dbeaver.runtime.AbstractJob.run(AbstractJob.java:99)
Dbeaver No Database Selected Data
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)