[teiid-users] unexpected query results against XML data source

[John Doyle]

Ramesh,  yes I need to look into properties on this binding.


----- "Ramesh Reddy" <rareddy at redhat.com> wrote:

> When I tried this I got an exception during the execution of the
> query.
> The only change I made was instead of using the XML-Relational HTTP
> Connector, I used the XML-Relational File Connector. I am using the
> latest 6.2 M2
> 
> Caused by: java.lang.NullPointerException
> com.metamatrix.connector.xml.base.XMLConnectorStateImpl.isCaching(XMLConnectorStateImpl.java:200)
> 
> Mike: What version you are using? 6.1?
> 
> John: When I checked the Connector Type XML there is no
> "CacheEnabled"
> property and never gets specified on the binding. Thus NPE, shouldn't
> this be defaulting to 'false' in the absence of this flag? Or is
> there
> any other way I can avoid this?
> 
> Thanks.
> 
> Ramesh.. 
> 
> 
> On Tue, 2009-09-01 at 10:22 -0700, Mike Mascari wrote:
> > I've attached both the xml and the xsd used and re-tested the
> > importation and query against them with the same result. Thanks for
> > looking into it! Could it be the same issue as this:
> > 
> > 
> > https://jira.jboss.org/jira/browse/TEIID-93
> > 
> > 
> > ??
> > 
> > 
> > My issue is a much simpler case, however. The query needn't be
> pushed
> > down as apart of the planner over a federated view to cause the
> > irregularity -- one need only query the XML source directly. 
> > 
> > 
> > Thanks again!
> > 
> > 
> > And just for giggles:
> > 
> > 
> > # xmllint --schema clients.xsd clients.xml 
> > <?xml version="1.0" encoding="UTF-8"?>
> > <clients>
> >   <client>
> >     <name>acme</name>
> >     <rate>15</rate>
> >   </client>
> >   <client>
> >     <name>toolwerks</name>
> >     <rate>20</rate>
> >   </client>
> > </clients>
> > clients.xml validates
> > 
> > 
> > :-)
> > 
> > 
> > - Mike
> > 
> > 
> >
> ______________________________________________________________________
> > From: John Doyle <jdoyle at redhat.com>
> > To: Mike Mascari <mascarim at yahoo.com>
> > Cc: teiid-users at lists.jboss.org
> > Sent: Tuesday, September 1, 2009 11:48:24 AM
> > Subject: Re: [teiid-users] unexpected query results against XML
> data
> > source
> > 
> > Hi Mike,
> > 
> > I've tried to reproduce this but get no root elements to select
> from
> > during the import process.  Is it possible that the XSD pasted here
> is
> > different from what you're using?
> > 
> > ~jd
> > ----- "Mike Mascari" <mascarim at yahoo.com> wrote: 
> > > 
> > > 
> > Hello. I've downloaded and installed the snapshot as of today
> > (8/31/2009) and, using the designer:
> > 
> > > 
> > 1. Used Import->XML Schema as Relational Source Model
> > 
> > > 
> > 2. Selected Document over HTTP with no request parameters
> > 
> > > 
> > 3. Selected No Catalog
> > 
> > > 
> > 4. Chose "File System" as source of XML Schema (inlined below)
> > 
> > > 
> > 5. Chose "client" (I've tried w/"clients" as well) as the root
> element
> > and "Finish"
> > 
> > > 
> > 6. Create a "purchasing" View Model and, with "purchasing"
> selected,
> > created an "example" BaseTable. I then drag-and-drop "client" from
> > clients.xmi Source Model into SOURCES pane. (This View abstraction
> > turns out not to be the problem -- I query the Source via the
> > Execute'd VDB with the same outcome.)
> > 
> > > 
> > 7. Created a "billing" vdb, cleaned, built, and synchronized.
> > 
> > > 
> > 8. Then, with this data served up by apache:
> > 
> > > 
> > <?xml version="1.0" encoding="UTF-8"?>
> > <clients>
> >   <client>
> >     <name>acme</name>
> >     <rate>15</rate>
> >   </client>
> >   <client>
> >     <name>toolwerks</name>
> >     <rate>20</rate>
> >   </client>
> > </clients>
> > 
> > > 
> > I issued the following query:
> > 
> > > 
> > select * from clients.client
> > 
> > > 
> > and received the expected result:
> > 
> > > 
> > null;acme;15
> > null;toolwerks;20
> > 
> > > 
> > 9. Then I did this:
> > 
> > > 
> > select * from clients.client where name = 'acme'
> > 
> > > 
> > and received *two rows*:
> > 
> > > 
> > null;acme;15
> > null;toolwerks;20
> > 
> > > 
> > 10. So I did this:
> > 
> > > 
> > select * from clients.client where name != 'acme' 
> > 
> > > 
> > and received the expected one row:
> > 
> > > 
> > null;toolwerks;20
> > 
> > > 
> > ???
> > 
> > > 
> > Is there something goofy with the equality operator against XML
> data?
> > Is there flag that needs flipped on these attributes? I went with
> the
> > "string" mapping on the 'XML Schema as Relational Source Model'
> dialog
> > wizard (pane 4 IIRC). Oughtn't I have? I also changed XML node
> names
> > that might have been SQL keywords ('name' -> 'fullname') but no
> > dice...
> > 
> > > 
> > Thoughts? 
> > 
> > > 
> > - Mike
> > 
> > > 
> > Schema:
> > 
> > > 
> > <?xml version="1.0"?>
> > 
> > 
> > > 
> >   <!-- our client database -->
> > 
> > > 
> >   <xs:element name="clients">
> >   
> >     <xs:complexType>
> >       <xs:sequence>
> > 
> > > 
> >         <!-- the client -->
> >               
> >         <xs:element name="client" minOccurs="1"
> maxOccurs="unbounded">
> >           <xs:complexType>
> >             <xs:sequence>
> > 
> > > 
> >               <!-- client name -->
> > 
> > > 
> >               <xs:element name="name" type="xs:string"
> minOccurs="1"
> > maxOccurs="1"/>
> > 
> > > 
> >               <!-- bill rate -->
> > 
> > > 
> >               <xs:element name="rate" minOccurs="0">
> >                 <xs:simpleType>
> >                   <xs:restriction base="xs:decimal">
> >                     <xs:minInclusive value="50"/>
> >                     <xs:maxInclusive value="250"/>
> >                   </xs:restriction>
> >                 </xs:simpleType>
> >               </xs:element>
> > 
> > > 
> >             </xs:sequence>
> > 
> > > 
> >           </xs:complexType>
> > 
> > > 
> >         </xs:element>
> > 
> > > 
> >       </xs:sequence>
> >     </xs:complexType>
> > 
> > > 
> >   </xs:element>
> > </xs:schema>
> > 
> > > 
> > > 
> > 
> > > 
> > > _______________________________________________ teiid-users
> mailing
> > list teiid-users at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/teiid-users
> > 
> > 
> > _______________________________________________
> > teiid-users mailing list
> > teiid-users at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/teiid-users