当前位置：网站首页>Error when idea connects H2 database

Error when idea connects H2 database

2022-07-20 12:41:00 【fendouweiqian】

IDEA link H2 database , Link successful , But I can't see schemas
The command line can be operated again

The main reason for this is , When you connect h2 When it comes to databases ,idea Try to use

SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.CATALOGS

Solution 1

lookup h2 In the table . But unfortunately ,h2 This statement is no longer supported in the new version .
therefore , If that happens , Our means are ：
By adding OLD_INFORMATION_SCHEMA=TRUE To URL To solve .

Insert picture description here

Solution 2

Use 1.4.200 Driver version of

Insert picture description here

原网站

版权声明
本文为[fendouweiqian]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/201/202207190850054019.html

边栏推荐

猜你喜欢

随机推荐