Subject: Re: [xsl] Executing SQL queries - XSLT ?|
From: tim panton <tpanton@xxxxxxxxxxxxx>
Date: Sat, 28 Feb 2004 12:49:55 +0000
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
|<- Previous||Index||Next ->|
|RE: [xsl] Executing SQL queries - X, Andreas L. Delmelle||Thread||[xsl] XSL AddParameter, Bret|
|RE: [xsl] Executing SQL queries - X, Andreas L. Delmelle||Date||Re: [xsl] [XSLT 2.0] Using insert-b, David Carlisle|