2 Replies Latest reply on Jul 31, 2012 9:19 AM by Akshay Harale

    Getting data from xml datasource which having xmlns defination.

    Akshay Harale Newbie

      Hi everyone,

      I am trying to read the xml datasource in teiid 8.1.0 Alph2

      My xml file as bellow

      <employees bldg="10"

           xmlns="http://www.w3.org/TR/REC-xml-names/">

           <employee id="901">

                <name>

                     <first>John</first>

                     <last>Doe</last>

                </name>

                <office>344</office>

                <salary currency="USD">55000</salary>                     

                            <department>1</department>

           </employee>

           <employee id="902">

                <name>

                     <first>Peter</first>

                     <last>Pan</last>

                </name>

                <office>216</office>

                <phone>905-416-5004</phone>                     

                              <department>2</department>

           </employee>

      </employees>

       

      but it fails. If I remove this    xmlns="http://www.w3.org/TR/REC-xml-names/"   from file then it works fine.

      Is there any way to read the xml file which having the xmlns defination in it.