Originally posted by Adam Kreiss:
The request takes no parameters. � When I make the request, the server hangs while eating up my processor. Originally I was also getting java.lang.OutOfMemory exceptions. Increasing the heap size solved this (for now). It looks like somehow Axis never stops sending information back to the client.
�
Does anyone have any idea what might be causing this?
Sheer Volume?
A database server and client can deal with this by exchanging the information in batches (and it's usually binary data) - you seem to be attempting to send all of it in a
single massive HTTP response of bloated XML text - so transmission could take a while.
However it's probably the result set to XML marshalling that's killing your server. If the result set is large enough the
SOAP message creation process could cause the server to thrash because large parts of the virtual memory have to be repeatedly saved to and retrieved from disc - at which point the server might be sending no or only a trickle of data to the client.
Constrain your result set to a few rows, so that it can get it to work. Then make the result set bigger and bigger by varying your selection constraints until you are running into problems. What was the largest result set you could successfully send? How big was the resulting SOAP message?
Ultimately you may have to rethink your approach.