aspose file tools*
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
Author

loading very large resultset in xml document

sumita mukherjee
Greenhorn

Joined: Aug 27, 2007
Posts: 22
Hi,

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!

Regards,
Sumita
 
Consider Paul's rocket mass heater.
 
subject: loading very large resultset in xml document
 
Similar Threads
database to xml
Not recognising names containing underscores [RESOLVED]
Printing & in the XML Document
Java Result Set
return as xml document