[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: database and XSL
> Thanks Ganesh. I will check this link. Here is a more up-to-date version: http://www.saxonica.com/documentation/sql-extension/intro.html Regards, Michael Kay http://www.saxonica.com/ http://twitter.com/michaelhkay > > On Tue, Dec 8, 2009 at 2:51 AM, Ganesh Babu N > <nbabuganesh@xxxxxxxxx> wrote: > > 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 9.1.0.8 > > 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
|