Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Suggestions required on mapping data from xml to db

807580Sep 25 2009 — edited Oct 7 2009
Hi all,

I need some suggestion on a mapping that i have been doing for injecting the data into the back end.

The process involved is as follows:

1)Say i have a request in the form of a XML :
           <document>
            <data>
            <row index="0">
              <domainid>233</domainid>   
              <paddr2>gdfgh</paddr2>
              <form_id>newapplicant</form_id>
              <mobile>34567</mobile>
              <title>Mr.</title>
               <firstname>Michael</firstname>
              <emergency_no>911</emergency_no>
              <daytime>34</daytime>
              <rent_max>330</rent_max>
              <rent_min>120</rent_min>
              <entity_type>applicant</entity_type>
              <house_type>2</house_type>
              <surname>henry</surname>
              <paddr1>4</paddr1> 
              <email>abc@mail.com</email>
              <location>11</location>
              <area></area>
              <bedrooms>5</bedrooms>
              <property_alerts>2</property_alerts>
              </row>
           </data>
       </document>
         
Now after parsing the data from this XML using SAX/DOM parsers
I create a Data Structure like a +(Hashtable)+ where the tag names act as the <Keys> and the text content inside them becomes the <Values>.

I then use this Hashtable for populating the matching columns in the database. //Issue

Now as we can this process becomes a huge bottle neck over a period of time as the no of fields in the database
increase can anyone provide any suggestions on how to
handle this issue in a more optimized or generic manner.


--
thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2009
Added on Sep 25 2009
35 comments
227 views