Caches and H2 tables

[Kurt Semba <ks...@extremenetworks.com>]

Hi all,

is there a way to associate already existing caches that were not defined with the SQL DML commands/Spring configuration with the meta tables in H2? My understanding is that if “CREATE TABLE…” is created, some meta information is defined in H2 and is backed by the Ignite cache. If I define a cache programmatically using createCache in Ignite, the cache is created, but it is not exposed in the H2 tables.

--

Is the H2 diagnostic console still available in native persistence mode? I attempted to access this with the appropriate flags, but I only see the browser client page with no table information.

Thanks
Kurt

Re: Caches and H2 tables

[Ilya Kasnacheev <il...@gmail.com>]

Hello!

You can define SQL table as front for your cache, as per the following docs
page:
https://apacheignite.readme.io/docs/indexes

H2 diagnostic console is broken in recent releases, so I have heard, and
its use is discouraged. Better just use sqlline.

Regards,
-- 
Ilya Kasnacheev


пн, 14 окт. 2019 г. в 13:19, Kurt Semba <ks...@extremenetworks.com>:

> Hi all,
>
>
>
> is there a way to associate already existing caches that were not defined
> with the SQL DML commands/Spring configuration with the meta tables in H2?
> My understanding is that if “CREATE TABLE…” is created, some meta
> information is defined in H2 and is backed by the Ignite cache. If I define
> a cache programmatically using createCache in Ignite, the cache is created,
> but it is not exposed in the H2 tables.
>
>
>
> --
>
>
>
> Is the H2 diagnostic console still available in native persistence mode? I
> attempted to access this with the appropriate flags, but I only see the
> browser client page with no table information.
>
>
>
> Thanks
>
> Kurt
>
>
>