streaming "for xml" to sax xslt-transformation

From: clogwog (tomschuring_at_gmail.com)
Date: 10/19/04

  • Next message: Daryl Monge: "Re: Anybody using java and Ingres?" 
    Date: 18 Oct 2004 18:15:50 -0700

    hello,

    i'm wondering if anybody can point me to an example how to stream the
    resultset (containing XML) to a SAXParser ? the query gets returned
    with: "FOR XML RAW" so the xml is broken up into multiple records.

    for example:

    record1:
    <row UNIQUEID="53380601" a="53" /> (.... heaps more of these records
    ...)<row UNIQUEID="5311111"

    record2:
    a="125" /> <row UNIQUEID="5660101" a="165" />

    and i can't seem to figure out how to combine the records together in
    a streaming way (i know i can just collect the complete xml by
    appending them to a StringBuffer, but that might get realy realy big)

    any idea's are very welcome.
    regards,
    tom

  • Next message: Daryl Monge: "Re: Anybody using java and Ingres?"

    Relevant Pages

    • Re: For XML Problem with IIS6 and W2k3
      ... Can you run the FOR XML query directly on the database? ... > dim adoConn ... > dialect for the command stream to be a SQL query. ...
      (microsoft.public.sqlserver.xml)
    • Re: 8192 character limit in Query Analyser when returning data, how to save result without newline e
      ... You can write a small VB Script using ADO that will use the ADO result ... stream to write the FOR XML result directly to a file. ... The Query Analyzer used ODBC, that had no streaming result support ...
      (microsoft.public.sqlserver.xml)
    • Re: Data table text I/O package?
      ... regular and homogenuous data in mind. ... Given a data format much like in, ... I said XML is good for parsing of data if you cannot tell in advance that the data stream is totally free of errors. ... However, if some data item contains a separator due to an error, you loose the whole stream, or use the wrong data without noticing this, in the worst case. ...
      (comp.lang.ada)
    • RE: Unparsed Interchange
      ... but have you tried setting your stream position back ... from the received one (flat recieved -> xml out with some new parameters). ... // Get the original filename ... string filename = inmsg.Context.Read("ReceivedFileName", ...
      (microsoft.public.biztalk.general)
    • Error message when opening a recordset with a strem containing xml
      ... I have a problem when trying to open a recordset with a stream including xml ... System.String schemaText = null; ...
      (microsoft.public.data.ado)