Export table from DB to an XML file with Java

Question

I need to read every row of a particular table stored in a mysql DB, then i have to write an xml file extracted from each row. Which is the best practice for obtaining this target? I should use some java libraries, but i don't know how to choose the exact ones.

jMounir · Accepted Answer · 2015-11-20 12:01:34Z

1

look at this:

http://examples.javacodegeeks.com/core-java/xml/bind/jaxb-marshal-example/

From the DB if you use an ORM like hibernate or other you will get your rows as objects and then you can transforme them using JAXB.

answered Nov 20, 2015 at 12:01

jMounir

4952 silver badges11 bronze badges

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

3 Comments

jMounir Over a year ago

you have many possibilities, either create a JPA entities that describe your DB or use a hibernate ResultTransformer look at this issue stackoverflow.com/questions/3266492/…

FDC Over a year ago

Thank you jMounir, so now i install hibernate and with ResultTransformer I turn my row in objects, and then i have to marshall this objects in xml file. Is it right?

jMounir Over a year ago

Yes, that's right. if you mean by "install hibernate" that you're going to configurate it (add depndency and create persistence.xml file)

Collectives™ on Stack Overflow

Export table from DB to an XML file with Java

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related