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/