I have small task where i need to retrieve all the data from XML file and insert into Oracle table. I have two xml file one for XETRA which is attached with this project as [login to view URL] and another for EUREX which is attached with this project as [login to view URL] which is loading into my server daily at once. I want to retrieve data from this xml file in java and insert into Oracle table acordingly. So if the xml file is [login to view URL] then insert the data in XETRA_IMPORT table.
I already have xsd files and i have been provided Class files as well as seen in the attached project.
I have created [login to view URL] class and we have to use JAXB to retrive data from xml which is working now if we have to retrieve one element from xml file and we need to modify this and provide loop so that it can retrieve all the elements from xml file and also insert into Oracle table. Before insert we want to delete the table completely everytime and then insert the data.
We have to use Spring framework.
I have also attached table DDL for xetra and eurex.
Just for referance i have attached [login to view URL] file for my previous project where it can give idea of how we want to truncated and insert into oracle table but here we are retrieving data from csv files instead of that we want to retrieve data from xml file now.