Can I use OLH from insideJava code ?
XaviFeb 27 2012 — edited Jun 18 2012Hello I have a first map reduce job which splits a file in <contracts> and each contract is stored in HDFS , but each contract have sub tags like this.
I have this XML..
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<!--contract 1 -->
<contract>
<src_cont_id>312</src_cont_id>
<cont_src>55787-3</cont_src>
<cpny_cd_id>A833</cpny_cd_id>
<sttl_stat>0</sttl_stat>
<start_dt>2011-09-16</start_dt>
<trade_dt>2011-09-16</trade_dt>
<global_pdt>10800</global_pdt>
<pdt_ifrs>10800</pdt_ifrs>
<cpty_l_cpty_id>0755</cpty_l_cpty_id>
<cpty_l_cpty_id_src>55787-3</cpty_l_cpty_id_src>
<booking_l_cpty_id>0755</booking_l_cpty_id>
<booking_l_cpty_id_src>55787-3</booking_l_cpty_id_src>
<ownership_cd>8453</ownership_cd>
<profit_centre>NLSL</profit_centre>
<!--Añado las 2 siguientes lineas para agregar fac_src y src_fac_id -->
<fac_src>55787-3</fac_src>
<src_fac_id>99999</src_fac_id>
<leg>
<leg_id>1</leg_id>
<reset_dt_roll_cnvn>1</reset_dt_roll_cnvn>
<curr_notl_amnt>6666.00000</curr_notl_amnt>
<curr_notl_amnt_ccy>EUR</curr_notl_amnt_ccy>
<leg_ccy>EUR</leg_ccy>
<orig_notl_amnt>6666.00000</orig_notl_amnt>
<orig_notl_amnt_ccy>EUR</orig_notl_amnt_ccy>
<pay_receive_ind>R</pay_receive_ind>
<cash_sttl_ind>N</cash_sttl_ind>
<sttl_ccy>EUR</sttl_ccy>
<sttl_dt>2011-09-20</sttl_dt>
<spot_prc>1.00000</spot_prc>
<spot_prc_ccy>EUR</spot_prc_ccy>
<itrst_rate>0.0000000</itrst_rate>
<itrst_rate_type_src>55787-3</itrst_rate_type_src>
<spread_rate>0.00000</spread_rate>
<ref_rate>0.0000000</ref_rate>
<itrl_funding_rate>0.0000000</itrl_funding_rate>
<itrl_fx_prc>1.00000</itrl_fx_prc>
</leg>
<leg>
<leg_id>2</leg_id>
<reset_dt_roll_cnvn>1</reset_dt_roll_cnvn>
<curr_notl_amnt>3333.00000</curr_notl_amnt>
..........................................................................................
..........................................................................................
</contract>
<!--contract 2 -->
<contract>
<src_cont_id>324</src_cont_id>
<cont_src>55787-3</cont_src>
<cpny_cd_id>A833</cpny_cd_id>
<sttl_stat>0</sttl_stat>
<start_dt>2011-09-19</start_dt>
<trade_dt>2011-09-19</trade_dt>
<global_pdt>10800</global_pdt>
<pdt_ifrs>10800</pdt_ifrs>
<cpty_l_cpty_id>0755</cpty_l_cpty_id>
<cpty_l_cpty_id_src>55787-3</cpty_l_cpty_id_src>
<booking_l_cpty_id>0755</booking_l_cpty_id>
<booking_l_cpty_id_src>55787-3</booking_l_cpty_id_src>
<ownership_cd>8451</ownership_cd>
<profit_centre>NLSL</profit_centre>
<!--Añado las 2 siguientes lineas para agregar fac_src y src_fac_id -->
<fac_src>55787-3</fac_src>
<src_fac_id>100000</src_fac_id>
<leg>
<leg_id>1</leg_id>
<reset_dt_roll_cnvn>1</reset_dt_roll_cnvn>
<curr_notl_amnt>5555.00000</curr_notl_amnt>
<curr_notl_amnt_ccy>EUR</curr_notl_amnt_ccy>
<leg_ccy>EUR</leg_ccy>
<orig_notl_amnt>5555.00000</orig_notl_amnt>
<orig_notl_amnt_ccy>EUR</orig_notl_amnt_ccy>
<pay_receive_ind>R</pay_receive_ind>
.......
Every subtag of the contract tag must be stored in different tables...(oracle database release 11). I'm looking for the best way to do this.Any suggestions?
As OLH only can load one table...I don't know how perform this action....Could I use OLH from inside Java Code sending one XML?