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

Fix h2 db browser

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 5.9.4
    • Fix Version/s: QualifiedToSchedule
    • Component/s: Core VCS

      Description

      When I connect to the h2 database with:

      java -jar $NUXEO_HOME/lib/h2-1.4.177-NX01.jar
      

      I get the following error and the table tree (on the left-hand side panel is not visible):

      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
      

      To be able to see the tables, I had to drop all the following aliases:

      DROP ALIAS NXFT_CREATE_INDEX;
      DROP ALIAS NXFT_REINDEX;
      DROP ALIAS NXFT_DROP_ALL;
      DROP ALIAS NXFT_SEARCH;
      DROP ALIAS NX_IN_TREE;
      DROP ALIAS NX_ACCESS_ALLOWED;
      DROP ALIAS nx_upgrade_versions;
      DROP ALIAS nx_upgrade_lastContributor;
      DROP ALIAS NX_ANCESTORS;
      DROP ALIAS NXFT_INIT;
      

      A fix could be to drop these aliases at server shutdown that we can browse the h2 db content.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated: