[xquery-talk] XQUERY SQL

David White davidw at kencook.com
Thu Jul 27 12:45:58 PDT 2006


Its so hard to find information of our use XQuery.

Sadly, we are strongly bound to Xalan due to our CMS's publishing contraints.

However, I will try to cook up what you provided in saxon and translate it to xalan as best as possible and come back here for any ideas.

Thanks for the information it points us in the correct direction.

David White

-----Original Message-----
From: talk-bounces at xquery.com [mailto:talk-bounces at xquery.com] On Behalf Of Jonathan Robie
Sent: Thursday, July 27, 2006 11:30 AM
To: David White
Cc: 'Ryan Lubben'; talk at xquery.com
Subject: Re: [xquery-talk] XQUERY SQL

Hi David,

If your queries are very simple, you can embed them in a stylesheet (or 
an XQuery), and you don't need them to create complex XML structures, 
you might consider changing your XSLT processor to Saxon and using the 
SQL extension:


If you want to start using XQuery to create complex XML structures, you 
might want to look at the Stylus Studio XML Enterprise Edition, which 
provides an IDE like XML Spy, with mapping tools and a useful debugger 
for XQuery, as well as debugging for XSLT, etc. The Enterprise Edition 
embeds DataDirect XQuery, and you can use it to open any major 
relational database, write and test XQueries, save the results, etc. You 
can invoke your queries, your stylesheet, and your FO processor from 
within Stylus Studio. You can find a couple of videos on our XQuery 
support here:


I'm potentially biased, since I do work for DataDirect, but I also think 
I'd give you the same advice if I didn't.

Hope this is helpful!


David White wrote:
> Hi Jonathan, thanks for the response.
> * Yes your right on the mark, with what we are trying to do.
> - We are attempting to create a traditional relational database.  Does it create additional complications if we use the XML datatype to store xml chunks?
> - The only real application of XQUERY we are looking for is to SELECT data from our database and output it in XML so we can publish books.  The modification/creation/deletion of data can be handled by other means.
> - We currently use XMLSpy Entrprise edition, and Apache Xalan + XSFormatter by Antenna House.  Are more tools needed to pull data from a SQL database?
> Thanks much for the response!
> David Whtie
> -----Original Message-----
> From: talk-bounces at xquery.com [mailto:talk-bounces at xquery.com] On Behalf Of Jonathan Robie
> Sent: Thursday, July 27, 2006 10:56 AM
> To: David White
> Cc: talk at xquery.com
> Subject: Re: [xquery-talk] XQUERY SQL
> Hi David,
> I assume you are doing data publishing, where much of the document is 
> hand-authored, but some of it is generated from a database. Is this right?
> A few questions:
> - In the database, is the data you want in traditional relational rows 
> and columns, or is it in XML stored in the database?
> - How much of XQuery do you need? Is the limited support found natively 
> in SQL Server 2005 enough for your needs, or do you want to be able to 
> use pretty much the whole language? Or if you could issue SQL from a 
> stylesheet, would that meet your needs?
> - Do you want to do this from within a program, or from within an XML IDE?
> Jonathan
> David White wrote:
>> Thanks for the URLs,
>> I looked them over and they are similar to other information I have 
>> already found.  I will provide more specifics to what I need help on.
>> We use docbook XML and apache xalan to publish our books.
>> Is anyone familiar with this chain and how to get it to talk to 
>> Microsoft SQL 2005?

Read my Blog: http://blogs.datadirect.com/jonathan_robie/
Learn XQuery: http://media.datadirect.com/download/docs/ddxquery/tutorial_query.html
Learn XQJ (the JDBC for XQuery): http://www.datadirect.com/developer/xquery/topics/xqj_tutorial/
Get DataDirect XQuery: http://www.datadirect.com/products/xquery/

talk at xquery.com

More information about the talk mailing list