Table check of H2 database in Keycloak

[Ananda Bose]

Hello all,

I am using Keycloak v16 in AWS Ec2 instance with inbuilt H2 database.

I need to check how many tables are present in H2 database. 

I tried to use the below command using :

java -cp ./modules/system/layers/base/com/h2database/h2/main/h2-1.4.193.jar org.h2.tools.Shell -url "jdbc:h2:./standalone/data/keycloak;AUTO_SERVER=TRUE" -user sa -password sa

but getting an error : Error: Could not find or load main class org.h2.tools.Shell

Can you please let me know how to check tables of H2 database of keycloak in AWS EC2 server.

Regards,

Ananda

[Christian Buchegger]

Hi, I just coincidentally came accross this link:

https://www.thrysoee.dk/keycloak-h2/

The classpath in this reference looks differently. Maybe this can be applied to you use case.

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to h2-database...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/860debb0-28bb-4b0c-b6ab-e10164d93357n%40googlegroups.com.