Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4573

Modeshape query

XMLWordPrintable

    • Hide

      deploy one or more .xmi physical models
      connect to modeshape vdb
      execute query: select a.jcr_path, a.table_name ,b.jcr_name
      from "Relational_Model_View"."Table_Columns" a, "ModeShape"."xmi_model" b
      where a.jcr_path = b.jcr_path

      Show
      deploy one or more .xmi physical models connect to modeshape vdb execute query: select a.jcr_path, a.table_name ,b.jcr_name from "Relational_Model_View"."Table_Columns" a, "ModeShape"."xmi_model" b where a.jcr_path = b.jcr_path

      The following modeshape vdb query fails.

      select a.jcr_path, a.table_name ,b.jcr_name
      from "Relational_Model_View"."Table_Columns" a, "ModeShape"."xmi_model" b
      where a.jcr_path = b.jcr_path

      the error is:

      Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ModeShape: 0 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_1."jcr:path", g_0."mode:localName", g_2."jcr:name" FROM "relational:table" AS g_0 INNER JOIN "relational:column" AS g_1 ON ISCHILDNODE(g_1, g_0) INNER JOIN "xmi:model" AS g_2 ON g_1."jcr:path" = g_2."jcr:path" AND ISCHILDNODE(g_2, g_0)]
      SQLState: 50000
      ErrorCode: 30504

              rhn-engineering-shawkins Steven Hawkins
              tljohnst@gmail.com thomas johnston (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: