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

Properly escape the column references for Excel based data

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.7, 8.0
    • 7.0
    • JDBC Connector
    • None
    • Hide

      You can try building the VDB in the Designer and fix the metadata, so that this issue does not exist

      Show
      You can try building the VDB in the Designer and fix the metadata, so that this issue does not exist

      Currently when Excel based data is used through Dynamic VDB feature the JDBCODBC Driver reports the metadata in-compatible format thus when the Teiid issues the query to the source it some times sees issues like

      [Prepared Values: [] SQL: SELECT `C:\testing\abcd`.`Sheet1$`.`Name`, `C:\testing\abcd`.`Sheet1$`.`Address`, `C:\testing\abcd`.`Sheet1$`.`Country`, `C:\testing\abcd`.`Sheet1$`.`ZipCode` FROM `C:\testing\abcd`.`Sheet1$`]
      SQLState: -3010

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-rareddy Ramesh Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: