Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-28956

Upgrade H2 driver to version 1.4.200

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.10
    • Fix Version/s: 11.1, 2021.0
    • Component/s: Core VCS, H2
    • Tags:
    • Team:
      FG
    • Sprint:
      nxFG 11.1.13

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day, 2 hours, 50 minutes
                  1d 2h 50m

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.