Browse Corda database tables using H2 web interface shows synonyms errors

Question

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)

Answer 1

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.