[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

XML representation of SQL queries?

• From: "ken_north@c..." <ken_north@c...>
• To: xml-dev@l...
• Date: Mon, 9 Feb 2009 18:58:36 -0500

Richard Tobin wrote
> Is there a standard way of representing SQL queries in XML?

There's a represention of SQL query *results* as XML that's been adapted
for different purposes. Java (JDBC) defines the format of a WebRowset
that's also supported by grid services and the Globus Toolkit.

Representing the SQL query source as XML would require an XML vocabulary
that can accommodate SQL as a moving target (different SQL dialects). Not
every SQL platform implements the SQL:2003 standard and platform providers
often implement extensions to the standard. 

The problem is somewhat analagous to trying to develop a standard XML spec
for office documents. One standard might support Java embedding, whereas
another might support embedded OLE components.





--------------------------------------------------------------------
mail2web.com - Microsoft® Exchange solutions from a leading provider -
http://link.mail2web.com/Business/Exchange

• Follow-Ups:
  • Re: XML representation of SQL queries?
    • From: nico <ndebeiss@g...>