• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

magic mySQL to XML piece???

 
Chris Snapp
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm about as green as you can get so I'm sorry if this is a well known issue (searching the web and forums hasn't gotten me anywhere).
My goal is to retrieve data from a mySQL database in XML format and allow this XML to be stored in a bean or sent back to the browser either raw or through a stylesheet transformation.
I figured the DB to XML jive was a pretty common issue, but I haven't been able to find any half-way straightforward explanation that I could get to work.
I had stumbled across "DB2XML" but for the life of me I couldn't figure out how to work the durn thing. (like I said....I'm still a newbie to JAVA)
Any help would be greatly appreciated.
-Thanks
Chris
 
cyril vidal
Ranch Hand
Posts: 247
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
you may use mysqldump utilitary to do it automatically. by example:
C :\%mysqldump% -X test transactions > c :\resu.xml
will extract into resu.xml the table transactions from database test.
or you may find this tutorial interesting too:
using JDBC to extract data into XML
And because this forum deals with Servlet, and if you read french , you may want to have look to this article, that extracts data from a database with a servlet and outputs it in XML, HTML and finally SVG.
.Servlets, base de donn´┐Żes et SVG

Regards,
Cyril
[ November 16, 2003: Message edited by: cyril vidal ]
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving from Servlets to... um... JDBC.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic