Hi All,
In my operation I am having 11 threads that have their own Result Set object to process. When I access my these Result Set objects after some time I get
SQLException: Exhausted Resultset from all the 11 threads.
Then I tried executing only a single
thread. It functions properly and my operation was successful.
Searching through the Internet for this exception I found some articles that said that this exception can occur if you are not accessing your Result Set properly (i.e. not using resultset.next() or closing the result set etc). But as my single thread operation was successful I dont think any of these as cause of my issue.
I found one post on this forum where it was said that this error might occur if lots of Result Sets are open at the same time. This seems to be the possible cause of the issue I am facing. Apart from the 11 threads that their own Result Set object there would be some other operations as well going on on my system as this is a large application.
Also when I execute a single thread then my operation executes successfully, this strongs suggests me that lots of Result Sets being open at the same time to be the cause of issue I am facing.
Could you please let me know your ideas on this?
Also is there any way I can overcome this issue?
One way I read is by closing the Result Set object as soon as after being used. But that we are already doing in the application. Is there any other way to overcome this?
Please let me know.
Thanks and regards,
Kaustubh Kane