Hello,
Our web apps require us to get data out of SQLServer databases (in
general, relational db's) as XML and integrate it with other XML data.
So far we've been using XSP/esql/SQLTransformer to get the data out as XML.
I'm pretty interested in trying out XQuery as an alternative, and I'm
trying to find out if that's possible in Cocoon.
I see there is the eXist project with its XQueryGenerator
(http://exist.sourceforge.net/api/org/exist/cocoon/XQueryGenerator.html),
which looks perfect... but as far as I can tell, it will only connect to
an eXist database (or a native XML database). Is that true?
One of the design goals of XQuery, and reasons for its success, is that
it's aimed at integrating data from relational databases as well as from
XML data sources.
Does anybody know whether XQueryGenerator could connect to a SQLServer
instance that supports an XML view of its data, such as SQLServer 2000 +
SQLXML, or SQLServer 2005?
I see also that SQLServer 2005 provides XQuery support via web services
(SOAP); that might be our best bet for the time being. But I'm not sure
how db-vendor-independent that would be.in the long run. (Also,
SQLServer doesn't support all of XQuery, e.g. no "let", I'm told.) It
does seem to make sense to have XQueries run on the db server in terms
of network usage. I think.
My primary question, though, is: is it possible to run XQuery queries
now in Cocoon that connect to a SQLServer database?
Thanks for any info,
Lars
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
