View Single Post
  #1 (permalink)  
Old 04-08-2008, 02:26 PM
nanimtech nanimtech is offline
Member
 
Join Date: Apr 2008
Posts: 5
nanimtech is on a distinguished road
Exception : ResultSet is closed
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..



if (pConnection != null) {
pConnection.close();
pConnection = null;

if (pStatement != null) {
pStatement.close();
pStatement = null;

if(pResultSet != null) {
pResultSet.close();
pResultSet = null;




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


I really appreciate for any thoughts...

--Naresh
Reply With Quote
Sponsored Links