Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Bear Bibeault
  • Liutauras Vilda
  • Devaka Cooray
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

Attn: MrAjith Kallambella..There is no reponse to my query in Forum

 
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Techies:
I am a newbie to XML and would like to know whether the records retrieved from the SQL Database can be updated or placed into XML.
Can anyone tell me how to go about solving this problem.
ALSO DO TELL ME WHETHER WE CAN DEVELOP OR HAVE A IMPORT FACILITY WHEREIN A database table-name schema can be populated into a DTD/XSD/XDR and etc.
Looking forward to hear from you.
Plz provide me with some pointers as to how to solve this problem.

Regards
Ritesh
 
Sheriff
Posts: 5782
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ritesh,
I suggest that you sift through some of the old discussions here on this topic. This is quite a popular topic and old threads will give you quite a lot of information to chew.
Bottom line is that many popular database vendors support XML both as a query language and as a way of representing the result set. You will be able to send XML documents to databases and have them convert the document into a query( although support complex queries with multiple joins is quite limited ). Oracle 8i supports XML-based database columns and standard SQLs that can query such columns. It's pretty cool. Using Oracle's XSU and XDK, you can even integrate these capabilities into standard Java applications. Oracle's technet site has a lot of information including white papers and example programs. Ofcourse if you don't use Oracle then you might want to check with your vendor's website for how's and what's of their XML support.
Good luck!


------------------
Ajith Kallambella M.
Sun Certified Programmer for the Java�2 Platform.
IBM Certified Developer - XML and Related Technologies, V1.
 
Ajith Kallambella
Sheriff
Posts: 5782
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Okay, just doing my "Seriff" duties.
Your name Ritesh r does not comply with the JavaRanch naming policy. We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please spare a moment and re-register with a name that meets the requirements.
Thanks!
 
She's out of the country right now, toppling an unauthorized dictatorship. Please leave a message with this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!