1 Reply Latest reply on Sep 7, 2018 10:51 AM by shawkins

    Select label are not always read

    gadeyne.bram
    gadeyne.bram Sep 7, 2018 10:33 AM

      Hi,

       

      Has something changed in the JDBC driver?

       

      Since teiid 10.3 (I think) I something encounter problems with software not reading column labels where it used to do this in the past.

       

      e.g.

       

      select c.ICUSessionID, admw.wardname as AdmissionWard, disw.wardname as DischargeWard

      from #tmp_cohort c

      left join kd_matric.md_admissionwards admw on admw.wardid = pa.AdmissionWard

      left join kd_matric.md_dischargewards disw on disw.wardid = pa.DischargeWard;

       

      returns the columns ICUSessionID, wardname, wardname instead of the expected ICUSessionID, AdmissionWard, DischargeWard in Rstudio using RJDBC.

       

      I'm wondering if the is a change in Teiid or rather in RJDBC or some other software component.

        • 1. Re: Select label are not always read
          shawkins
          shawkins Sep 7, 2018 10:51 AM (in response to gadeyne.bram)

          Is this JDBC or ODBC?

           

          With JDBC in the metadata there is both a column name and a label.  The column name is supposed to match the non-aliased column. 

           

          There's a useJDBC4ColumnNameAndLabelSemantics connection property that can be set to false if you want the label to be reported as the column name.

            • Actions