Export to Excel problem for data size more than 2 MB

[shivamadagani]

Hi,

We are using  jasperreports-3.0.0.

Exporting data into excel who's size less than 2MB of xml data is ok, managable.

But when we are try to export the data into excel file who's xml data size is more than 2 MB, we are getting the below error.

Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request

when we pass that xml data to JRXmlDataSource class  somtimes its failing in production environment.

Some how its working in my local system.

Do we have any limitations on JRXmlDataSource class with xml data size?

Can u plz suggest the solution for this problem.

Thanks

Shiva

 

 

Code:

InputStream in = new ByteArrayInputStream(finalResp.getBytes());		JRDataSource jSource = null;		try {			jSource = new JRXmlDataSource(in,"/listResponse/item");		}catch(Exception ex){			logger.error(ex);		}finally {			//Release resource			if(in!=null){				in.close();			}		}

[hozawa]

Have you tried using JRSwapFileVirtualizer to chunk out to virtual memory?

[shivamadagani]

Can u explain more on this?

What are the changes I can make in the given code.

If you can provide me some sample code on this, i ll be very thankful to you.