jQuery in Action, 3rd edition
The moose likes XML and Related Technologies and the fly likes loading very large resultset in xml document Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "loading very large resultset in xml document" Watch "loading very large resultset in xml document" New topic

loading very large resultset in xml document

sumita mukherjee

Joined: Aug 27, 2007
Posts: 22

I want to load a mySql resultset in memory as xml document, using JDBC, so that I can display the values in a jsp, as well as filter the document for display, as and when required.

I am using JAXP to load a mysql result set into a xml document, in memory. This works fine when there are smaller resultsets(aound 500, or 1000). However, I have around 28000 rows returned from the db, and when I try to load that, the log shows that the loading process just stops in the middle, without any error.
The code snippet is provided below:

my question:

Could somebody let me know what could be the reason of the loading process stopping midway?(I am tring to load the document at the servlet init)
Is this an efficient way of loading a large db resultset in xml?
Can anyone suggest any better alternate approach?

Thanks for your help as always!

I agree. Here's the link: http://aspose.com/file-tools
subject: loading very large resultset in xml document
It's not a secret anymore!