-
Type: Bug
-
Status: Open
-
Priority: Minor
-
Resolution: Unresolved
-
Affects Version/s: 5.9.4
-
Fix Version/s: QualifiedToSchedule
-
Component/s: Core VCS
-
Tags:
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.
- is related to
-
NXP-28956 Upgrade H2 driver to version 1.4.200
- Resolved