Can you create multiple directories in H2?

Question

When you connect to the embedded H2 local database, for example:

jdbc:h2:./target/data/CATALOGA;

H2 uses the database name (QATAR here) as CATALOG_NAME. This can be seen by querying the INFORMATION_SCHEMA.CATALOGS table.

Is it possible to have more than one directory?

You cannot embed in INFORMATION_SCHEMA, and H2 does not allow statements CREATE CATALOG.

---

The background information is that we have queries that are combined between directories. So, something similar:

select * from CATALOGA.dbo.example e
    inner join CATALOGB.dbo.example2 e2 on e.fk = e2.fk

Requests have a directory / schema in them directly, and I need to be able to execute them on H2.

Answer 1

H2 - . H2 , .

, , , , , . create linked table, .