@katzyn :)
Recover add else and add test case TestRecovery.testRecoverJson()

why rs.getMetaData().getColumnType(2) is 1111 , but H2Type.JSON.getVendorTypeNumber() is 38?

before fix rs.getString(2) is "{\"value\":[]}"
after fix: {"value":[]} is correct.

JDBC type codes and vendor-specific type codes may be entirely unrelated to each other.

In case of H2 you shouldn't try to use result from H2Type.getVendorTypeNumber(). H2Type can only be passed as is to PreparedStatement.setObject(column, Object, SQLType, …) or to ResultSet.updateObject(column, Object, SQLType, …). It can be useful for data types unknown by JDBC or for complex data types such as as array data types or ROW value data types.