• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

how to fetch values from sql server to jsp file using xml

 
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hello ranchers,

i am very new to xml.

i got a task to fetch some values stored in the database (sql server) and display in jsp page using xml.


any ideas how to connect , fetch and store..


Links are welcome

thanks in advance

TUHIN
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


any ideas how to connect , fetch and store..


These particular operations are nothing to do with XML. Have a read of the JDBC tutorial at Sun to get you going.

One extra bit of help: SQL Server has the ability to return results as an XML String. You might find this useful - check the documentation for "FOR XML RAW".
 
Tuhin Ghosh
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Paul for the reply


I got the resultset in a xml format.

Is there anyway i can store this resultset into a xml File


Is there anyway (dom writer which takes parameter as resultset) so that i can parse w3.document object






regards
tuhin

[ January 17, 2007: Message edited by: Tuhin Ghosh ]
[ January 17, 2007: Message edited by: Tuhin Ghosh ]
 
WHAT is your favorite color? Blue, no yellow, ahhhhhhh! Tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic