Re: [xsl] database and XSL

Subject: Re: [xsl] database and XSL
From: a kusa <akusa8@xxxxxxxxx>
Date: Tue, 8 Dec 2009 10:45:58 -0600
Thanks Ganesh. I will check this link.

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.
> This extension is available with Saxon-PE which is commercial version.
>  However if you need only basic operations you can use Saxon-B
> 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>
>>> 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

Current Thread