Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6256

Move the XmlVTI into the product.

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.11.1.1
    • None
    • SQL, Tools
    • Normal

    Description

      The XmlVTI under derbyDemo has been useful to me for many years. It has become even more useful now that Derby supports varargs. That is because varargs make it very easy to declare an XmlVTI. At this point, I think it is worth re-phrasing the XmlVTI in terms of varargs and moving it into the product so that we can use it for internal table functions. There is no rush to expose XmlVTI as part of Derby's public api, but we could consider doing that if other people find this table function to be useful.

      The XmlVTI is a table function which turns an xml file into a tabular data set which you can query via sql. When you declare an XmlVTI, you state the following arguments:

      1) The url of an xml file.

      2) The name of the element in the xml file which you want to treat as a record or row.

      3) The names of the attributes and subelements of that record which you want to treat as columns. Now that we have varargs, it is possible to represent this trailing argument as a variable length argument list.

      Attachments

        1. derby-6256-01-aa-move-XmlVTI-into-product.diff
          10 kB
          Richard N. Hillegas
        2. derby-6256-02-aa-allowParentTags.diff
          10 kB
          Richard N. Hillegas
        3. derby-6256-03-aa-useFileNotURL.diff
          2 kB
          Richard N. Hillegas
        4. derby-6256-04-aa-addURLFactoryMethodAndTests.diff
          105 kB
          Richard N. Hillegas
        5. derby-6256-05-aa-javadocTypo.diff
          0.5 kB
          Richard N. Hillegas
        6. derby-6256-06-aa-revampVTIdemos.diff
          124 kB
          Richard N. Hillegas
        7. derby-6256-07-aa-constructorJavadoc.diff
          1 kB
          Richard N. Hillegas

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            rhillegas Richard N. Hillegas
            rhillegas Richard N. Hillegas
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment