java xml parsing a large file and db relation

Angus

New Member
I have a 10+ MB xml file with consists of node(about 10K to 20K) with relations. \[code\]<.....><Emplyoyee> <name>Jack</name> <age>35</age> <supervisor></supervisor> <....></Emplyoyee><.....><.....><.....><Emplyoyee> <name>Smith</name> <age>20</age> <supervisor>Jack</supervisor> <....></Emplyoyee><.....>\[/code\]Now, I want to parse this file and store all the details in DB with "Employee" table which has a field(ID) called "supervisorID". Until now I have tried to make a List of all the employees and then iterating the List for finding supervisor relation.Please suggest me a memory efficient and faster way to do this. What libraries can I use to handle this type of problems.
 
Back
Top