Hi Guys
I need to read and parse a xml file and store it's data in the database.
my xml looks like this:
and i need this data in database like this:Code:<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE root SYSTEM "mapping.dtd"> <root> <BU code="0000"> <referenceRates> <TimeStamp>2012-10-25T13:00Z</TimeStamp> </referenceRates> <productGroup type="producttype"> <product> <code>00000</code> <pricing> <term type="years">1</term> <price>0.00%</price> </pricing> <pricing> <term type="years">2</term> <price>0.00%</price> </pricing> <pricing> <term type="years">3</term> <price>0.00price> </pricing> </product> </productGroup> </BU> </root>
BU code term term_v price timestamp
0000 00000 years 1 0.00% 2012-10-25
0000 00000 years 2 0.00% 2012-10-25
0000 00000 years 3 0.00% 2012-10-25
Is this possible in SpringBatch? If yes, which reader and Unmarshaller should i use?
I did this parsing and inserting into the database easy with a pl/sql script... but with SpringBatch i have no clue how to do this...
can you help me plz?
Thanks a lot
Kind Regards


Reply With Quote