• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exception : ResultSet is closed

 
Naresh Talluri
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi folks
I have a problem while closing the ResultSet in JDBC.
iam using Postgre DB, here for normal execution it is working fine,
but while we are doing load test at the rate of 30 or 40 hits to the
application on a peak volume it is throwing the error like
"PSQLException:This ResultSet is closed."
can you please let me know what are all the possibilities....
here is my DB releasing code..


can you please let me know the possibilities to overcome this.

-Naresh







 
Bindesh Nair
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You have 2 methods where the data pull is happening. It would be difficult for anyone looking at these 2 methods only to point out the issue.

In general the error means that you have an issue with the code logic. However, a stack trace of the error would help explain more about the issue.

Moreover, I see that you have the logger turned on, so you can look into the flow of the logger output in conjunction with the stack trace.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic