region = new Region();
region.setId(new Integer(resultSet.getInt("ID")));
region.setName(resultSet.getString("NAME"));
}
} catch (SQLException e) {
throw new RegionNotFoundException("Region " + id + " not found",e);
}
finally {
closeConnection(resultSet);
}
return region;