I am trying to keep a ResultSet object open across method calls in my bean but when I try to access without creating a new connection, I get the error "Connection handle has been closed and is unusable". Is there a way to keep the Connection open until I'm done with the ResultSet?