Use H2 database

Hi!
I want to use a H2 Database in my Cuba project, but I see no H2 in database types list. There is a HSQL (similar database), but I wan to know, is it real to use exactly H2. What steps should be performed to attach it? Should I write some kind of plugin or connector/adapter? Would be enough to edit some config file and restart studio?

Thanks.

Hi,

The full support for arbitrary databases in Studio is scheduled for release 6.8 (January 2018), see https://youtrack.cuba-platform.com/issue/STUDIO-3939

Now you can try to use HSQL in Studio, and just switch the JDBC driver and connection string in test and production environment to H2.

Also, you could use Studio with HSQL for initial project configuration and scaffolding, and then switch to development in an IDE and use this recommendations for working with H2.

1 Like