Uploaded image for project: 'JDBC'
  1. JDBC
  2. JDBC-21

JDBC Driver cannot access CSV,XML files

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Not specified
    • Resolution: Invalid
    • None
    • None
    • Driver
    • None

    Description

      rpastrana commented on Sep 6, 2013

      The Driver depends on WSDFU/DFUInfo for information regarding all available files.
      The JDBC Driver depends on the reported data file format, which it retrieves from DFUInfo. As it turns out the Format field is actually an data file encoding indicator.
      https://track.hpccsystems.com/browse/HPCC-8867 will populate the @kind attribute with "FLAT|CSV|XML|KEY" information.

      Also, one of the most important bits of information is the DFU File's reported record definition. Without the record definition, the driver cannot generate correct ECL to read/fetch from the given file. It appears that DFUInfo is currently not reporting the record definition for non-flat files:
      https://track.hpccsystems.com/browse/HPCC-9955
      @rpastrana rpastrana was assigned on Sep 6, 2013
      @rpastrana
      Collaborator
      rpastrana commented on Sep 18, 2013

      JDBC driver should look for contentType=CSV|FLAT|XML|KEY once https://track.hpccsystems.com/browse/HPCC-9961is available (targeted for 4.2).

      Attachments

        Activity

          People

            rpastrana Rodrigo Pastrana
            rpastrana Rodrigo Pastrana
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: