-
I execute a Statement which i get from a hibernate Sesssion using connection(). In my servlet I close the hibernate session after every unit of work. Is there any reason for me to close the ResultSet and if not what are the effects. I havent seen any performance hits by not closing the ResultSet or Statement
-
It will take time to reach Memory leaks which is not has immidiate effect.
-
Not closed ResultSet is basically cursor in DB. So, unless you or framework you using close it explicitly it will stay open until ResultSet object will be garbage collected = good chances run out of cursors.
