Hide Forgot
project_key: SOA Because Jcr sql doesn't fit nicely into the sql world, a pseudo-column had to be added to sql language for ModeShape in order to transform the query into a jcr readable query. And this pseudo-column is exposed when importing metadata from ModeShape. However, because there is no special ModeShape JDBC Importer (yet), the column attributes - 'Selectable', must be manually changed to 'false' on every table that the mode_properties column appears (which should be every table). Otherwise, performing a 'Select *' on a table will result in a query that contains the pseudo-column that is sent to ModeShape, resulting in a invalid query.
Link: Added: This issue is related to TEIIDDES-723
Checked in an updated ModeShape.vdb that has the mode:properties column Selectable attribute set to false.
Changes were committed to change mode:properties to not be selectable upon importing.
Tested and closed.