Hi Lars,
The main problem is that there is no standardized method for doing
XQueries, not even amongst the native xml databases. Both
XQueryGenerator's I know of (eXist and X-Hive) use their own
proprietary interfaces, so you would need to write your own for
SQLServer. I think that the only out-of-the-box option you have is to
call the SOAP interface from flowscript.
On Mar 29, 2006, at 11:40 PM, Lars Huttar wrote:
Lars Huttar wrote:
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
No takers?
Anybody using Cocoon + XQuery + any relational database?
Lars
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
