RE: SQL Generation

[Danny Ayers <danny@panlanka.net>]

You should be able to do this using WebRowSets, an implementation of part of
the Java Database Connectivity (JDBC) API, Optional Package
(http://java.sun.com/jdbc I think).

---
Danny Ayers
http://www.isacat.net

<- -----Original Message-----
<- From: Jurgen [mailto:jurgen.moortgat@oracle.com]
<- Sent: 30 March 2001 18:19
<- To: Phil Ruelle
<- Cc: xml-dev@lists.xml.org
<- Subject: Re: SQL Generation
<-
<-
<-
<- phil,
<-
<- try Oracle's Xml Sql Utility (downloadable from technet), this
<- utility allows you to generate an XML document based on a query.
<- you can also insert/update a table/view based on the content of an
<- XML Document (so you don't need to generate update statements
<- yourself).
<-
<- cheers,
<- Jurgen.
<-
<- Phil Ruelle wrote:
<- >
<- > All,
<- >
<- > Does anyone know of an XML based technology similar to
<- > Microsoft's RecordSets or Sybase's DataWindows?
<- > By that I mean something that creates an XML document by
<- > executing an SQL SELECT statement, allow that document to be
<- > updated and then generate a suitable SQL UPDATE statement
<- > using the primary key and only the rows/columns that have changed.
<- >
<- > TIA,
<- >
<- > Phil Ruelle
<- >
<- > ------------------------------------------------------------------
<- > The xml-dev list is sponsored by XML.org, an initiative of OASIS
<- > <http://www.oasis-open.org>
<- >
<- > The list archives are at http://lists.xml.org/archives/xml-dev/
<- >
<- > To unsubscribe from this elist send a message with the single word
<- > "unsubscribe" in the body to: xml-dev-request@lists.xml.org
<-
<- ------------------------------------------------------------------
<- The xml-dev list is sponsored by XML.org, an initiative of OASIS
<- <http://www.oasis-open.org>
<-
<- The list archives are at http://lists.xml.org/archives/xml-dev/
<-
<- To unsubscribe from this elist send a message with the single word
<- "unsubscribe" in the body to: xml-dev-request@lists.xml.org
<-