Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes XML and Related Technologies and the fly likes SQL Statements in XML document Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "SQL Statements in XML document" Watch "SQL Statements in XML document" New topic

SQL Statements in XML document

Sandeep Shahane

Joined: Nov 16, 2005
Posts: 8
I'm new to XML. I wish to store all my application SQL statements in an XML file. Can anybody please guide me where can I find XML strucutre for the same and XML parsers also.
Is using XML for storing SQL statements is a good practice ?

Sandeep L. Shahane<br />SCJP 1.4, SCWCD J2EE 1.4, <br />SCBCD J2EE 1.3 ...
Paul Clapham

Joined: Oct 14, 2005
Posts: 18135

For beginners, just use the XML parser (and other tools) built into Java (1.4 or later). There are many ways to store SQL statements in XML. The simplest is like this:

<SQL>Select name, address from supplier</SQL>

Or you could break the statement up into its parts and store them in separate elements. I would suggest learning the basics of XML before you make any decisions on how to use it.
I agree. Here's the link:
subject: SQL Statements in XML document
Similar Threads
complex sql statements questions in interview, need info for job, please help!
XML reporting and look query
Trigger Function Problem
How to trace SQL statements ?
Running .sql File in java