Hi,
I am doing the same with a LotusNotes Database.
(If your my_SQL just has one table it will work, the more complicated the database_structure the more dificult the task)
These are the steps I followed:
1. Create a XML Document
2. Parse the Document with SAX (its faster) and write one Data_Row in a java.util.Map with some sort of an id as key. With a Map you'll have lots FieldName---FieldValue Pairs. Put all the Maps in a Vector.
3. Iterate the Vector. Iterate all Map key-Value pairs and write the Database_Code you need (
JDBC).
I did not write it directly from Sax to LotusNotes because programs looks more simple as it is now.
Would apreciate better suggestions
Axel