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(_at_)gmail(_dot_)com> 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(_at_)gmail(_dot_)com> 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(_at_)fgeorges(_dot_)org> 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/
--~-----------------------------------------------------------------
- XSL-List info and archive:
http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive:
http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--