• 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..




All these statements are enclosed in try/catch block...


I really appreciate for any thoughts...

--Naresh

 
Herman Schelti
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

change resultset first, then statement, then connection.

Herman
 
Naresh Talluri
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
in my code i had put like that only , but while posting
i copy pasted like that...sorry for that one..
No one resource is sharing my application.
but in the normal condition it is working fine but in the peak volume only it is getting trouble...
getDirectoryContents() is the method iam going to call.
the code shown below:



Releasing DB resources :



} catch (SQLException e) {
//new BusinessException("SQLException while trying to closeResultSet in DBAccess: " + e.getMessage(), e.getStackTrace());
}
}

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

-Naresh


[ April 08, 2008: Message edited by: Naresh Talluri ]
 
Naresh Talluri
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
here iam getting this error only on the load test only, not frequently.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic