[jdom-interest] SAXBuilder

[Mujahid Ali]

Hi.
 
I have an xml document that contains sql queries in form of processing
instructions. I want to read in the document, run the queries contained
by the PIs and replace the PI with data returned by the queries. 
 
So if we have this:
<interface>
    <filter_criteria>
        <field name="test">
        <?query sql="SELECT * from x"?>
        </field>
        <field name="test2">
        <?query sql="SELECT * FROM y"?>
        </field>
      </filter_criteria>
</interface>
 
after processing the above document we would have 
 
<interface>
    <filter_criteria>
        <field name="test">
        <values>
            <value>1</value>
            <value>2</value>
        </values>
        </field>
        <field name="test2">
        <values>
            <value>1</value>
            <value>2</value>
        </values>
        </field>
      </filter_criteria>
</interface>
 
I can accomplish this by building my own Content Handler and capturing
the callbacks using SAX. So as I start to read the file using SAX, I can
write another one out. So this way the new file will contain the
original xml structure + the new data fetched by the sql queries.
 
Alternatively,  I can use the SAXBuilder to build a JDOM document,
traverse through each element looking for PIs and handling them
appropriately.
 
My question is if the xml file is really big, like let’s say 1 MB, which
way would be more efficient? I don’t really understand what a JDOM
Document is so hoping that maybe some one can help me out.
 
 
Regards,
 
Mujahid Ali
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://jdom.org/pipermail/jdom-interest/attachments/20010809/938d4ccb/attachment.htm