Re: database and XSL
Hai , Here is the link which will help you. You need jdbc driver and setup ODBC in your system. http://saxon.sourceforge.net/saxon7.5/sql-extension.html This extension is available with Saxon-PE which is commercial version. However if you need only basic operations you can use Saxon-B 220.127.116.11 which is a open source. Regards, Ganesh On Tue, Dec 8, 2009 at 12:17 AM, a kusa <akusa8@xxxxxxxxx> wrote: > Thank you Florent. Can you please point me to some examples where I > can see how this is implemented? > > On Mon, Dec 7, 2009 at 9:39 AM, Florent Georges <lists@xxxxxxxxxxxx> wrote: >> a kusa wrote: >> >> Hi, >> >>> I have a requirement to be able to read from a data base and >>> map the data to an xml file. >> >>> Is it possible to write sql statements in XSLT 2.0? My google >>> did not give me good result set. >> >> Not in a standard way, but you can write your own extensions, >> or use existing one. Saxon for instance comes with such an >> extension (not sure it is in 9.2 HE, but normally it is in 9.1 >> B). >> >> But when I have such a requirement (well, that's a bit short as >> requirement, but usually this is the right way) I define a >> document type, write a class that implements XMLReader, and use >> this class as the reader for the source of the transform. >> >> Either you create some objects from SQL, and pass them to the >> reader's ctor, or you eval the SQL statements directly within the >> reader. >> >> Regards, >> >> -- >> Florent Georges >> http://www.fgeorges.org/
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format