fixed a bug in getRenterID helper - was closing ResultSet too early