MySQL Query to XML output

Question

Is there a framework current out there that allows you to take MYSQL query output and convert it all into XML?

duffymo · Accepted Answer · 2010-12-28 00:34:24Z

1

Two completely separate problems: querying a database and serializing to XML. Treat them separately and you'll have better luck.

answered Dec 28, 2010 at 0:34

duffymo

310k46 gold badges376 silver badges570 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

facundofarias · Accepted Answer · 2016-09-05 08:57:07Z

1

If you are dealing with plain Java objects, you could use XStream. So you would need to get the JDBC result set into some plain java object and then serialize it to XML using this.

http://x-stream.github.io/

edited Sep 5, 2016 at 8:57

facundofarias

3,04933 silver badges27 bronze badges

answered Dec 28, 2010 at 0:26

jbx

22.3k20 gold badges100 silver badges151 bronze badges

Comments

mhaller · Accepted Answer · 2010-12-28 00:47:38Z

0

Do you mean something like this:

 echo 'SELECT * FROM INFORMATION_SCHEMA.TABLES' | mysql --xml

yields:

 <resultset statement="SELECT ....">
   <row>
     <field name="TABLE_NAME">CHARACTER_SETS</field>
     ...
   </row>
 </resultset>

If you want to do it with Java, you could try javax.sql.rowset.WebRowSet.writeXml(ResultSet, Writer). Unfortunately, i don't know of any other implementations than Sun-specific com.sun.rowset.WebRowSetImpl

answered Dec 28, 2010 at 0:47

mhaller

14.2k2 gold badges44 silver badges62 bronze badges

Collectives™ on Stack Overflow

MySQL Query to XML output

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related