7.7.2. Connecting with IntelliJ IDEA Ultimate

IntelliJ IDEA Ultimate Edition offers convenient tools for working with databases. To connect to HSQLDB, start IDEA and open the Database panel on the right.

If you cannot find the panel, open View → Tool Windows → Database.

In the appeared window select the hsqldb-x.x.x.jar driver that you can copy from the lib folder of your CUBA Studio installation.

Then you should configure data source properties: database URL, User name and Password. Database URL can be copied from the Project properties properties tab in CUBA Studio or from the modules/core/web/META-INF/context.xml file of the application project. The default user name is "sa", the password is empty.

db hsql idea setDbProperties
Tip

If you are using PostgreSQL as the DBMS and uuid as the identifier, editing data with IntelliJ IDEA may result in an error: ERROR: operator does not exist: uuid = character varying

To solve this problem, go to the Advanced tab in the data source settings and set stringtype to unspecified.