Re: Executing SQL queries - XSLT ?

Hi All,

I have an application written in Java which accepts an XML file (data) as input transforms it using a XSL file. I am using Xalan as my parser to do the transformation. As part of the transforming logic I am grouping the data and also performing some basic math operations to result in sub-totals for each of the grouping categories. Is it possible to execute SQL queries from the XSL file against a database so I can store these values in a table?

I have taken a look at Oracle's xsql utility and standalone (command line/ servlet) Im able to fire select/insert queries using the tool. Is it possible to do this programmatically while performing the transformation.

import oracle.xml.xsql.*;
.....
            URL xsqlsheetURL = this.getClass().getResource(xsqlFile);
            // build an xsql request using it
            XSQLRequest req = new XSQLRequest(xcmf, xsqlsheetURL);
            req.setPostedDocument(rows);
            // invoke xsql
            Document res = req.processToXML();

The problems with this are:
1) it is Oracle only - and they keep changing the spec
2) I don't think it works if you use a DOM produced
by a parser other than oracle's to produce 'rows' above.

Any help is greatly appreciated.
Thanks much
M