使用H2 Web界面浏览Corda数据库表显示同义词错误 [英] Browse Corda database tables using H2 web interface shows synonyms errors

问题描述

我按照

错误：

 未找到表 SYNONYMS； SQL语句：
 SELECT TABLE_CAT，TABLE_SCHEM，TABLE_NAME，TABLE_TYPE，REMARKS，TYPE_CAT，TYPE_SCHEM，
 TYPE_NAME，SELF_REFERENCING_COL_NAME，REF_GENERATION，SQL FROM（SELECT SYNONYM_CATALOG TABLE_EMA，TABLE_EMA， TYPE_NAME AS TABLE_TYPE，REMARKS，TYPE_NAME TYPE_CAT，
 TYPE_NAME TYPE_SCHEM，TYPE_NAME AS TYPE_NAME，TYPE_NAME SELF_REFERENCING_COL_NAME，TYPE_NAME REF_GENERATION，
 NULL AS INFORMATION_SCHEMA中的SQL SYNONYMS？ b ESCAPE？AND SYNONYM_NAME LIKE？ESCAPE？AND（false）UNION SELECT TABLE_CATALOG TABLE_CAT，TABLE_SCHEMA TABLE_SCHEM，
 TABLE_NAME，TABLE_TYPE，REMARKS，TYPE_NAME TYPE_CAT，TYPE_NAME TYPE_SCHEM，TYPE_NAME，TYPE_NAME，TYPE_NAME，从INFORMATION_SCHEMA.TABLES到TABLE_CATALOG之类的？ESCAPE？和TABLE_SCHEMA之类的
 ESCAPE？AND TABLE_NAME之类的ESCAPE？AND（TABLE_TYPE IN（？ ）））
按TABLE_TYPE，TABLE_SCHEM，TABLE_NAME排序[42102-197] 42S02 / 42102（帮助）
  

解决方案

请使用以下版本：h2-1.4.196或h2-1.4.194。

目前使用的Corda版本 ext.h2_version ='1.4.194'。
最新版本的驱动程序尚不兼容。

更新：

使用Corda 4 ext.h2_version ='1.4.197'，如果使用Corda 4，请使用适当版本的h2 jar。 / p>

I followed the instructions at this link to browse corda database. However, I am getting below errors when I queried for tables.

Error:

Table "SYNONYMS" not found; SQL statement:
SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_CAT, TYPE_SCHEM, 
TYPE_NAME, SELF_REFERENCING_COL_NAME, REF_GENERATION, SQL FROM (SELECT SYNONYM_CATALOG TABLE_CAT, 
SYNONYM_SCHEMA TABLE_SCHEM, SYNONYM_NAME as TABLE_NAME, TYPE_NAME AS TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, 
TYPE_NAME TYPE_SCHEM, TYPE_NAME AS TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION,
NULL AS SQL FROM INFORMATION_SCHEMA.SYNONYMS WHERE SYNONYM_CATALOG LIKE ? ESCAPE ? AND SYNONYM_SCHEMA LIKE ?
ESCAPE ? AND SYNONYM_NAME LIKE ? ESCAPE ? AND (false)  UNION SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, 
TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, 
TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ?
ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ) 
ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME [42102-197] 42S02/42102 (Help)

解决方案

Please use version: h2-1.4.196 or h2-1.4.194.

Corda as of now uses version ext.h2_version = '1.4.194'. The latest version of the driver is not compatible yet.

Update:

With Corda 4 ext.h2_version = '1.4.197' so use appropriate version of h2 jar if using Corda 4.

这篇关于使用H2 Web界面浏览Corda数据库表显示同义词错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！