Is this Impossible !!

[Vane Lashua]

But also see the messages about Oracle's building of XML from the data set
returned from an SQL query...
 
From: Abhishek Srivastava <mailto:abisheks at india.hp.com>  

 
I tried the Oracle's SQL - XML utility and it does what i want.  Except a
few things.
 
I generated the following XML file as a result to a query to my oracle
database.
 
<ROWSET>
 <ROW num="1">
  <SPNAME>Huntington services Company             </SPNAME>
  <CUSTPERMID>123456789123456     </CUSTPERMID>
  <CUSTLOGINID>jamesb              </CUSTLOGINID>
  <FIRSTNAME>james </FIRSTNAME>
  <LASTNAME>Bond </LASTNAME>
 </ROW>
 </ROW>
</ROWSET>
 
The ROWSET and the ROW tags were introduced by the builder itself. I would
like the document to look like :
 
<CUSTID>
<SPNAME>My Own Business  Services Company  </SPNAME>
  <CUSTPERMID>123456789123456     </CUSTPERMID>
  <CUSTLOGINID>jamesb              </CUSTLOGINID>
  <FIRSTNAME>james               </FIRSTNAME>
  <LASTNAME>Bond                </LASTNAME>
 </CUSTID>

This is very important because this xml file will be sent to the client who
will "validate" it. Since ROWSET and ROW are not a part of standard message
format we use... an exception will be thrown.
Is there any way to customize the output from the builder so that it
conforms to a predefined DTD ?
-----Original Message-----
From: Goyal, Sanjeev [mailto:Sanjeev.Goyal at usa.xerox.com]
Sent: Thursday, October 21, 1999 9:49 AM
To: 'Abhishek Srivastava'
Cc: xml dev mailing list
Subject: RE: Is this Impossible !!



Abhishek,
 
Most of the XML Parser implementations provides mechanism to generate well
formed XML documents from the DOM Tree. I have used sun's XML parser, it
provides APIs to generate well-formed XML from your Document Node.
 
Hope it helps.
Sanjeev
 
 -----Original Message-----
From: Abhishek Srivastava [mailto:abisheks at india.hp.com]
Sent: Wednesday, October 20, 1999 1:29 AM
To: xml dev mailing list
Subject: Is this Immpossible !!



Hi All,
 
I have the following requirement. A client wants to query a database. It
sends out an SQL Query to the Database server. At the server side, instead
of returning a recordset, it returns an XML File.
 
The client on receiving the XML file, parsers it for "Validity" (to be sure
that all elements it had asked for are there).
 
Problem is that at the server side, How to build the xml document.
Presently, I am doing something like this
 
String("<Name>") + rs.getField("auName") + String("</Name>")
 
However, this is a very inelegant approach as the code is full of such
string concatenations.
 
Is there a more elegant solution to this ?  All the material on XML talks
about parsing and reading XML. What about writing them ? Are there DOM / SAX
Api extensions available that would 
create "VALID" XML documents without clutter in the code ?
 
Any help would be greatly appreciated.
 
Thanks & Best Regards,
Abhishek.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    _/               Abhishek Srivastava
   _/                Hewlett Packard ISO       
  _/_/_/   _/_/_/    -------------------   
 _/   /   _/  _/     (Work)   +91-80-2251554 x1190
_/  _/   _/_/_/      (Ip)     15.10.47.37            
        _/           (Url)    http://sites.netscape.net/abhishes/homepage
<http://sites.netscape.net/abhishes/homepage>                         
       _/            You've heard it all by now. Get wired or get whacked. 
                     You're networking or you're not working. Dot-com or die

                     - SUN MICROSYSTEMS 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ic.ac.uk/pipermail/xml-dev/attachments/19991022/6d47be6a/attachment.htm