File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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:
subject: loading very large resultset in xml document
jQuery in Action, 3rd edition