java - chunking XML and loading it into relational tables -


i work credit union (roughly 60k accounts). statement process '70s , tightly coupled data layout. in short, run job , produces text file contains statement each account. i've modified mainframe config , instead of getting text out, xml so:

<statements>     <statement account='1'>        ...statement info checking/savings/certificate/visa/loan/heloc shares     </statement>     <statement account='n'>        ...statement info checking/savings/certificate/visa/loan/heloc shares     </statement> </statements>

i wrote java code pull data relational table(s) , build pdfs on fly itext. of data shows on statement calculated data in xml. instance, xml contains transactions on share. on statement, want show number of credits , number of debits. once loaded db, can use view calculate these values on fly , provide data java app.

this xml file ~900mb , going grow add more members.

i want process xml 1 "statement" @ time. http://mrico.eu/entry/parsing_chunks_of_xml_documents

can jaxb parse large xml files in chunks)

once have individual statement, want load it's shares (checking, savings, visa, etc) corresponding db tables.

seems simplest way accomplish bind statement pojo , each complex element (share or transaction or loan) in pojo, insert.

what combination of parser / binder / persistence tools guys recommend?

personally, i'd favor raw jdbc inserts, question of parser , binder more important.

note: create schema xml, might fragile due way mainframe builds xml file. using fiserv's spectrum software feels pain.

have @ stax streaming api xml.


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use
Read more