Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • 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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!