Retrieving xm from mySQL and sending it through webservice method

[Dushyant Chhetri]

Hi Guys,

I am trying to export an xml outputted from mySQL database onto a mobile client.
The client will then parse the retrieved xml at the client end.

The problem I am facing is when I am trying to store the Query output to a variable which I can return via the service method to the mobile client.

  
String query="SELECT CONCAT('\n<root>\n',GROUP_CONCAT('  <MainSympt>', SYMPT_NAME, '</MainSympt>\n' SEPARATOR ''),'</root>') AS xmldoc FROM symptoms_table" ;                
            System.out.println("xml query::"+query);
            
            rs=st.executeQuery(query);
  

I tried running the query on Toad and got the perfect output. The problem now is simply to send it back through the Webservice.


Please help

[Ivan Krizsan]

Hi!
Sadly, I must say that your code looks really ugly. Why do you mix querying the DB and generating the XML in a SQL query???
What do you do if you one day need to switch to another DB or another way of storing your data?
My advice is as follows:
1. Create an XML schema describing the XML you want to generate.
2. Use XJC and the XML schema to generate JAXB bean classes.

Then you implement code that does the following, step by step:
1. Query the database.
2. Create JAXB bean objects.
3. Insert data into the JAXB bean objects.
4. Use the JAXB bean object(s) to generate a response from the web service.
Best wishes!

[Dushyant Chhetri]

Hi
Request you to direct me to some link about the knowledge you talked about.

I am new to JAXB and would want to learn more

[Ivan Krizsan]

Hi!
Of course!
Since I do not know at which level you are, I will provide several different links to material on JAXB. Please select the one you feel is most suitable to you. The references are in no special order.

JavaEE Tutorial on JAXB

http://java.sun.com/javaee/5/docs/tutorial/doc/bnazf.html

5 Minutes on Java

http://ukumars.wordpress.com/2009/03/18/jaxb-in-5-minutes/

JAXB Example from My SCDJWS 5 Study Notes

See page 155 and forward in this document: http://faq.javaranch.com/content/Exam-Objectives-5.pdf

The JAXB Tutorial

https://jaxb.dev.java.net/tutorial/

Please do not hesitate if you have any questions!

[Deepak Ingwale]

Hi Dush,

I think JibX will be perfect for this.JiBX is a tool for binding XML data to Java objects.



For more information you can Visit

http://jibx.sourceforge.net/index.html