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

RE: SQL Generation

• From: Danny Ayers <danny@p...>
• To: Jurgen <jurgen.moortgat@o...>, Phil Ruelle <philr@i...>
• Date: Fri, 30 Mar 2001 22:25:20 +0600

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@o...]
<- Sent: 30 March 2001 18:19
<- To: Phil Ruelle
<- Cc: xml-dev@l...
<- 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@l...
<-
<- ------------------------------------------------------------------
<- 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@l...
<-

• References:
  • Re: SQL Generation
    • From: Jurgen <jurgen.moortgat@o...>

• Prev by Date: Re: attribute order (RE: Syntax Sugar and XML information models)
• Next by Date: Re: CDATA sections in W3C XML Infoset
• Previous by thread: Re: SQL Generation
• Next by thread: [ANN] Idoox WASP (Web Application and Services Platform) - efficientdevelopment, testing and deployment of SOAP Web Services
• Index(es):
  • Date
  • Thread