@Override public Iterator<Key> iterator() { Connection connection = getConnection(); PreparedStatement statement = null; ResultSet rs = null; List<Key> keys = new ArrayList<Key>(); try { statement = connection.prepareStatement("select uri,vary from response"); rs = statement.executeQuery(); while (rs.next()) { String uri = rs.getString(1); String vary = rs.getString(2); keys.add(Key.create(URI.create(uri), mapper.convertToVary(vary))); } } catch (SQLException ignore) { } finally { JdbcUtil.close(rs); JdbcUtil.close(statement); JdbcUtil.close(connection); } return ImmutableList.copyOf(keys).iterator(); }