Terry P wrote:
> Tjerk,
> Thanks for the response.  
> In particular, I expect to be using a DB2 database with XML Extenders
> (IBM).  I may need this on different platforms - Linux, ISeries,
> Win2000.
> 
> A Java/SQL solution may be best.  I am hoping for something like a
> Java class that can parse the XPath and create the Where clause of a
> SQL query.  Special SQL functions might be used to emulate the
> standard XPath functions.
> 
> XPath has been around for a while, so I am surprised that I have not
> been able to find "off the shelf" tools to do this.
> 
> Terry
> 
> 
> Tjerk Wolterink <tjerk@w...> wrote in message news:<41adc5e4$0$30715$18b6e80@n...>...
> 
>>Terry P wrote:
>>
>>>Are there any tools (java classes, tag libraries) which can translate
>>>xpath statements into a SQL query?
> 
> ...> 
> 
>>>Terry
>>
>>What sory of database are you talking about?
>>A ordinary relational database? Or an XML-database.
>>Xml-databases are new and not very fast, but there is extensive research in xml-database-system.
>>Those system support xpath and xquery as query languages.
>>
>>I'f you want to map xpath onto sql, then your're right: you need some
>>rules about how xml is mapped onto the relational database.
>>With those rules you could map xpath expression to sql expressions.
>>
>>I don't know wether they exists. I myself have my own mapping rules,
>>rather simplistic rules but it does the job for me.

I've never seen an Xpath to SELECT [] FROM [] WHERE clause translation.
And it is not easy to do that,
because you have to have rules in how you store xml in a relational database.

I think that's also the reason there are no tools to do that.
So can't help you there.