Uploaded image for project: 'JBoss Enterprise SOA Platform'
  1. JBoss Enterprise SOA Platform
  2. SOA-2619

After importing jdbc metadata from ModeShape to build the Teiid model, the mode_properties column in every table must be updated to set 'Selectable' to false

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 5.1.0.ER4
    • Fix Version/s: JBDS
    • Component/s: Documentation, EDS
    • Labels:
      None

      Description

      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  van.halbert Van Halbert
                  Reporter:
                  van.halbert Van Halbert
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: