Intellij embedded H2 database tables do not appear-CodePudding

I'm creating a Spring Boot application and I'm using Intellij's embedded h2 database.

I have added the following lines in my application.properties file:

spring.datasource.url=jdbc:h2:~/testdb;MV_STORE=false;AUTO_SERVER=TRUE

This is my data source configuration

Although the connection is successful and I can query the database using Intellij's query console, the tables do not appear in the Database tab.

Succeeded
DBMS: H2 (ver. 2.1.210 (2022-01-17))
Case sensitivity: plain=upper, delimited=exact
Driver: H2 JDBC Driver (ver. 2.1.210 (2022-01-17), JDBC4.2)
Ping: 16 ms

When I refresh the connection or go to the schemas tab of the data source configuration, I get the following error:

[42S02][42102] org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "INFORMATION_SCHEMA_CATALOG_NAME" not found; SQL statement: select CATALOG_NAME from INFORMATION_SCHEMA.INFORMATION_SCHEMA_CATALOG_NAME [42102-210].

CodePudding user response：

By going to the advanced tab of the data source and clicking on expert options, we are presented with a checkbox labeled "Introspect using JDBC metadata"

By checking that box, the tables successfully appear in the Database tab