Re: CreateNewInstance" from xml(Schema)

[Jurgen <jurgen.moortgat@oracle.com>]

hi,

Oracle's XSQL Servlet Framework does exactly what you want:

An XML Document containing an SQL Query is send to a 
(servlet enabled) web server to handle the request.

The output is an XML Document containg the result of the
SQL Query.

Learn more about it on http://technet.oracle.com

cheers,
Jurgen.


> sabba wrote:
> 
> hi,
> i'm developing a new application that's heavily based on XML.
> i'm loading and saving xml document instances from and to database
> "without
> prob".
> 
> I'm currently evaluating the best way to implement a "new document"
> feature,
> that is , generate an XML document instance based on some kind of
> definition
> (something like when you make an ado recordset from a "select * from
> mytable
> where 1=2" sql statement)
> i'm considering using an xml-schema document (or a custom XML -schema
> like-
> document) and then pass this schema to an XSL document that would
> output a
> brand new xml instance document based on the schema
> Do u thing it's the right approach ?
> Has someone tryed successfully something similar ?
> ready made code for this ?
> suggestions and comments are welcome
> Enrico Sabbadin: esabbadin@vb2themax.com
> http://www.sabbasoft.com
> MTS/COM+ / VB-COM FAQ: http://www.sabbasoft.com/mts_faq.htm
>