RE: [xsl] database and XSL

["Michael Kay" <mike@xxxxxxxxxxxx>]

> 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/