Upgrade H2 driver to version 1.4.200

To view the H2 console with JDK8 and Nuxeo 8.10, one knows:

• set up and start a Nuxeo with JDK 8 and H2 as a database (default)
• REM set JAVA HOME and NUXEO_HOME and PATH=%JAVA_HOME%\bin;%PATH%
• cd %NUXEO_HOME%

• java -Xbootclasspath/a:nxserver\lib\nuxeo-core-storage-sql-extensions-8.10-HF15.jar;%JAVA_HOME%\jre\lib\rt.jar -cp nxserver\lib\h2-1.4.177-NX01.jar org.h2.tools.Server

  Then, enter the correct URL for the H2 driver in the H2 console, e.g.

  jdbc:h2:c:/CASES/nuxeo-server-8.10-tomcat/nxserver/data/h2/nuxeo

  then hit "Connect"
  => this works

Do more or less the same with JDK11 and Nuxeo 10.10:

• java -cp nxserver\lib\nuxeo-core-storage-sql-extensions-10.10.jar;nxserver\lib\h2-1.4.177-NX01.jar org.h2.tools.Server

• correct URL:

  jdbc:h2:c:/CASES/nuxeo-server-10.10-tomcat/nxserver/data/h2/nuxeo

  => this fails after connecting with

  Class "org.nuxeo.ecm.core.storage.sql.db.H2Fulltext" not found; SQL statement:
  SELECT ALIAS_CATALOG PROCEDURE_CAT, ALIAS_SCHEMA PROCEDURE_SCHEM, ALIAS_NAME PROCEDURE_NAME, COLUMN_COUNT NUM_INPUT_PARAMS, ZERO() NUM_OUTPUT_PARAMS, ZERO() NUM_RESULT_SETS, REMARKS, RETURNS_RESULT PROCEDURE_TYPE, ALIAS_NAME SPECIFIC_NAME FROM INFORMATION_SCHEMA.FUNCTION_ALIASES WHERE ALIAS_CATALOG LIKE ? ESCAPE ? AND ALIAS_SCHEMA LIKE ? ESCAPE ? AND ALIAS_NAME LIKE ? ESCAPE ? ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, NUM_INPUT_PARAMS [90086-177] 90086/90086

  with looks like NXP-14710

However, on the same Nuxeo 10.10 setup, booting the H2 console with JDK11 and H2 driver H2-1.4.199 works fine (can connect with no error):

java -cp nxserver\lib\nuxeo-core-storage-sql-extensions-10.10.jar;\cases\h2-1.4.199.jar org.h2.tools.Server

correct URL:

jdbc:h2:c:/CASES/nuxeo-server-10.10-tomcat/nxserver/data/h2/nuxeo

=> using Driver H2-1.4.199 works fine with the same Nuxeo 10.10 setup and fails with H2-1.4.177-NX01.jar

=> It seems H2 1.4.199 is compatible with JDK11 AND JDK8 while H2-1.4.177-NX01 is NOT compatible with JDK11

The request is to QA and eventually upgrade H2 driver from 1.4.177-NX01 to 1.4.199 (latest H2 Driver stable release, knowing that H2-1.4.200 chokes in a different way)

Another outcome might be to update somehow the documentation to state the H2 console works only with driver H2-1.4.199 and not the driver Nuxeo 10.10 ships