cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lars Huttar <lars_hut...@sil.org>
Subject Re: Cocoon + XQuery + SQLServer?
Date Wed, 29 Mar 2006 21:40:19 GMT
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message