Databases
StackOverflow2013
Postsdbo
POPerformance issue while reading XML File in Java and storing it in Database
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPerformance issue while reading XML File in Java and storing it in Database
    text
    copied!<p>Hi I have big xml file which has a structure similar to the one I have given below and there are 1 lakh users in each XML file . I am uploading as a zip file and then I am extracting it . Once Extraction is done I am providing a Import link. what import does is it reads the XML file which has 1lakh(100000) users and then inserts into DB . I am using Spring with hibernate and have quartz job scheduler . I am uploading 10 such files and I am starting these 10 jobs which totally consists of 1 million lakh users.the jobs stops in the middle . I am not sure why the job stops and i see no trace of the job stopping . Please help me in resolving this . Is there a better way to read the XML , or anything to do with hibernate transactions or sessions. Please help. I am using java,spring, hibernate,quartz job scheduler.</p> <pre><code>&lt;userlist application="1"&gt; &lt;user&gt; &lt;username&gt; xmluser1 &lt;/username&gt; &lt;userid&gt;1&lt;/userid&gt; &lt;password&gt;xmluser1&lt;/password&gt; &lt;firstname&gt;first1&lt;/firstname&gt; &lt;lastname&gt;last1&lt;/lastname&gt; &lt;phone&gt;2024676868&lt;/phone&gt; &lt;fax&gt;20246868&lt;/fax&gt; &lt;address1&gt;&lt;![CDATA[dghggggh]]&gt;&lt;/address1&gt; &lt;address2&gt;&lt;/address2&gt; &lt;city&gt;ghgdghg&lt;/city&gt; &lt;state&gt;fdghg&lt;/state&gt; &lt;country&gt;UdghgSA&lt;/country&gt; &lt;postal_code&gt;774dghg07&lt;/postal_code&gt; &lt;company&gt;dghggg services&lt;/company&gt; &lt;/user&gt; &lt;/userlist&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload