Our functional requirement is to fetch around 50,000 records from the Database, form an xml of these records and flush it through an outputstream using the servlet. The data is then displayed in an Excel sheet.
We are using Websphere 5.0 .In the server side we have a session bean which fetch the records and holds them in a value object. This works fine for around 15000 records.
But if the data exceeeds,
But while returning from the EJB , we get the following exception. [10/7/04 15:41:07:969 IST] 732afa74 SystemErr R java.rmi.RemoteException: CORBA NO_MEMORY 0x4942f984 No; nested exception is: org.omg.CORBA.NO_MEMORY: Unable to write value : null minor code: 4942F984 completed: No
We are aware of the fact that this is because of huge data.We tried retrieving chunks of data, instead of retrieving full, at a time.But this doen't help.
Any idea, regarding the above problem would be of great help.
we cannot say anything: use Tivoli performance viewer or launch your server with -verbosegc and analyze the log. If you have a stack overflow error in your trace, try increasing max thread stack size with -Xss=1 or 2M Mouloud