Re: [xsl] database and XSL

[a kusa <akusa8@xxxxxxxxx>]

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