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

Expose primary and unique keys in the JDBC driver's Database MetaData

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Critical
    • 2.3.0.Final, 2.2.1.GA
    • 2.2.0.Final
    • Query, Tools
    • None
    • Low

    Description

      In MODE-934 we added support for the "jcr:path" pseudo-column, and in MODE-933 this pseudo-column (and other pseudo-columns) were exposed as additional columns on every table. This "jcr:path" column in JDBC is effectively a primary key, and should be exposed as such in JDBC's Database MetaData.

      Additionally, any table corresponding to a node that that is or (directly or indirectly) extends the "mix:referenceable" mixin node type will have a "jcr:uuid" column, and this column can be exposed as a unique key in JDBC's Database MetaData.

      Attachments

        Issue Links

          is blocked by

          Feature Request - Feature requests from customers and/or users MODE-933 JDBC driver should expose path, name, local name, depth and score

          • Critical - To be worked on immediately following BLOCKER issues.
          • Closed

          Feature Request - Feature requests from customers and/or users MODE-934 Add support for path, name, local name, depth, and score pseudo-column in JCR-SQL2

          • Critical - To be worked on immediately following BLOCKER issues.
          • Closed

          Activity

            People

              rhauch Randall Hauch (Inactive)
              rhauch Randall Hauch (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: