public Set<String> getKeys(String group) throws Exception {
Set<String> keys=new HashSet<String>();
Connection conn = null;
PreparedStatement smt = null;
for(int db : getDBNumbers(new Fqn(group))) {
try {
conn=createConnection(true,db);
smt=conn.prepareStatement("SELECT CACHE_KEY FROM `"+group+"`");
smt.setFetchSize(1000);
ResultSet rs=smt.executeQuery();
while(rs.next()) {
Fqn fqn=Fqn.fromString(rs.getString(1));
keys.add(fqn.getLastElementAsString());
}
rs.close();
}
catch(Exception ex) {
throw new Exception("couldn't get keys on group "+group+" db number"+db,ex);