Materialized View

[Sarat Vemuri]

Hello,

I tried to create materialized view in H2 database and after that I am getting below error while load the database file.

Caused by: java.lang.UnsupportedOperationException: not yet implemented
        at org.h2.command.Parser.parseCreateMaterializedView(Parser.java:7680)

Version used h2-2.2.224

I am assuming the db file is corrected. My goal is to read data from the corrupted database file.

Thanks,

Sarat Vemuri.

[Evgenij Ryazanov]

Hello!

Unfortunately, implementation of materialized views in H2 is not ready to be used in production.

To open a database with corrupted metadata you need to implement a dummy database event listener and specify it in JDBC URL:
https://h2database.com/html/commands.html#set_database_event_listener

This listener must be in classpath of H2.

[Sarat Vemuri]

Hello!!!!

Thank you very much. I will try this out and post the results.

Thanks,

Sarat Vemuri.