wood burning stoves 2.0*
The moose likes XML and Related Technologies and the fly likes XML data collection 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 "XML data collection" Watch "XML data collection" New topic
Author

XML data collection

pras
Ranch Hand

Joined: Apr 04, 2007
Posts: 188
hi,

i want to retrieve data from database through a XML.

the thing is earlier i had a java file which had a getter method to retrieve data from database.

now i should not use that java file and make it using only the xml.

any ideas?
pras
Ranch Hand

Joined: Apr 04, 2007
Posts: 188
anybody have an idea about this?
Shapra Benglur
Ranch Hand

Joined: Oct 12, 2006
Posts: 32
You might want to look at XQuery:

http://en.wikipedia.org/wiki/XQuery
Rahul Bhattacharjee
Ranch Hand

Joined: Nov 29, 2005
Posts: 2308
I am not very clear about you question.Could you please elaborate it again.

Is the data stored in database in the form of an XML in a CLOB field ,or you want your java program to fetch data from a database and construct a xml out of it and then give it to the invoker.Is that you want ?


Rahul Bhattacharjee
LinkedIn - Blog
pras
Ranch Hand

Joined: Apr 04, 2007
Posts: 188
data in database is in the form of sql tables which has to be retrieved using a xml and displayed.


do i need to write query in the xml??

what if i just write a simple query in xml?
like

<sql>select * from ABC</sql>
Rahul Bhattacharjee
Ranch Hand

Joined: Nov 29, 2005
Posts: 2308
Originally posted by prasanna sheregar:
data in database is in the form of sql tables which has to be retrieved using a xml and displayed.

Sorry , I still could not get your question.
Data is stored in database tables but what is the data type ? Is that CLOB ?
How can you retrieve data from database using XML?
pras
Ranch Hand

Joined: Apr 04, 2007
Posts: 188
i want to retrieve data from a database through XML

ie i can change only XML document


can i write a sql in a xml document itself?
pras
Ranch Hand

Joined: Apr 04, 2007
Posts: 188
data is stored in terms of tables.


which has to be retrieved and displayed


the catch is i have to do it by changing only xml

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: XML data collection
 
Similar Threads
Assignment Log Project
Format for reading special text from database
how to define data types in xml document
Reload XML, before Parsing
formatting data, and saving same to external file