aspose file tools*
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


Win a copy of Soft Skills this week in the Jobs Discussion forum!
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