org.postgresql.util.PSQLException: This ResultSet is closed.; State=55000; ErrorCode=0

[Rinu Varghese]

org.postgresql.util.PSQLException: This ResultSet is closed.; State=55000; ErrorCode=0 

this error is showing many times anyone know how to resolve it  and why its happening ?

[Flo Boj]

ResultSet closed ...  Your programming your own stuff atm ??

If so, just go "

try {
                              
                                myClassMemberConn=DB.createConnection(true, Connection.TRANSACTION_SERIALIZABLE);
                                myClassMemberStatement=myClassMemberConn.createStatement();
                                myClassMemberResultSet=myClassMemberStatement.executeQuery("select,update,insert something");
}catch (Exception e){}

Every time you finish your sql stuff, close your handles or the entire server will stuck:

something like this:
 public void close() {
               
                try {
                        if(myClassMemberResultSet!=null)
                                myClassMemberResultSet.close();
                        myClassMemberResultSet=null;
                        if(myClassMemberStatement!=null)
                                myClassMemberStatement.close();;
                        myClassMemberStatement=null;
                        if( myClassMemberConn!=null)
                                 myClassMemberConn.close();
                         myClassMemberConn=null;
                }catch (Exception e) {}
               
        }


If you you know what a class member object is AND it is the case your onto programming your own stuff atm , this might help you !
Good luck !

[Rinu Varghese]

Hi

But i'm using default build, is there any issue related to my DB.java class???

Thnaks

[Flo Boj]

Not as far as I can see ( I see little, thu) .
ATM I have in mind you might like to check the status of your db at all,
beginning with the hardware moving thru the configfiles untill checking the tables inside your idempieredb.
Latest mh, dunno maybe setup new, maybe doing vacuum or such things..
Good luck !