dbeaver: Oracle MView refresh does not work: class org.jkiss.dbeaver.ext.oracle.model.OracleTable cannot be cast to class org.jkiss.dbeaver.ext.oracle.model.OracleMaterializedView

System information:

  • Operating system (distribution) and version: Mac OS Catalina 10.15.7
  • DBeaver version: 21.0.5.202105160657 (Runtime: 11.0.8+10)
  • Additional extensions: None, pure installation

Connection specification:

  • Database name and version: Oracle 12.1.0.2.0
  • Driver name: ojdbc8:12.2.0.1 (I guess this version was bundled or downloaded from MVN central by default)
  • Do you use tunnels or proxies (SSH, SOCKS, etc)? No

Describe the problem you’re observing:

The following error on attempt to refresh a view:

image

Steps to reproduce, if exist:

Right-click materialized view -> Tools -> Refresh Materialized view -> click ‘Start’

Include any warning/errors/backtraces from the logs

Pasting error details from the screenshot:

Execute tool 'Refresh materialized view'
	Process [SCHEMA_NAME.MVIEW_NAME]
Process error
class org.jkiss.dbeaver.ext.oracle.model.OracleTable cannot be cast to class org.jkiss.dbeaver.ext.oracle.model.OracleMaterializedView (org.jkiss.dbeaver.ext.oracle.model.OracleTable and org.jkiss.dbeaver.ext.oracle.model.OracleMaterializedView are in unnamed module of loader org.eclipse.osgi.internal.loader.EquinoxClassLoader @419ece7a)
Tool execution finished

I also found this problem in comments to other issues, but those issues are already resolved:

About this issue

  • Original URL
  • State: open
  • Created 3 years ago
  • Comments: 16 (6 by maintainers)

Most upvoted comments

Successfully reproduced the issue on Oracle 12c EE.

@akilovich , I already reported above, that the problem was also reproducible on Linux. So far I only did not cover Windows 😃

I cannot reproduce it. Could you please send mview DDL example and logs completely https://github.com/dbeaver/dbeaver/wiki/Log-files?