Thanks Ganesh. I will check this link.
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>
--~--