Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-969

Importing metadata via Teiid Designer using ModeShape jdbc driver shows column jcr_name in the tables, but it is not queryable

XMLWordPrintable

      Importing metadata to build the ModeShape vdb, has the column jcr_name (jcr:name) in the tables. However, this column is not queryable. The SqlException returned when executing query thru jdbc driver indicates: Element "jcr_name" is not defined by any relevant group

      Then performed: select * from [ddl:addColumnDefinition] using the jdbc.war to execute directly to modeshape and the jcr:name column is not in the result list of columns:

      ddl:datatypeName ddl:datatypeLength ddl:datatypePrecision ddl:datatypeScale ddl:nullable ddl:defaultOption ddl:defaultValue ddl:defaultPrecision ddl:collationName jcr:primaryType ddl:name

              van.halbert Van Halbert (Inactive)
              van.halbert Van Halbert (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: