Exception : ResultSet is closed

[nanimtech]

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

[rico16135]

why are you checking to see if it is null? just close it in a finally clause.

your setting it to null after you close it.

[felixtfelix]

hi,

You have to close the objects in the certain order

1. ResultSet
2. PreparedStatement
3. Connection

Regards
Felix T

[danielstoner]

What line of code throws the exception? Does it happen when you try to use the ResultSet after a query? Can you show the actual code that uses the ResultSet and indicate the problem line?

[sneha1284]

Just to add never check

ResultSet rs;
.
.
.
.
(rs != null)

as the resultset is never null

[RamyaSivakanth]

Close it in order.
-----------------
1.Close the resultset
2.Close the statement
3.Close the Connection

Check whether connection is alive and also check whether Ur connection pooling object size is sufficient.