Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

XML data collection

 
pras
Ranch Hand
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
anybody have an idea about this?
 
Shapra Benglur
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You might want to look at XQuery:

http://en.wikipedia.org/wiki/XQuery
 
Rahul Bhattacharjee
Ranch Hand
Posts: 2308
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
pras
Ranch Hand
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2308
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic