public Map<String,Integer> loadIdentifierIdPairs(DBTransaction transaction) throws SQLException {
  Map<String,Integer> map=new HashMap<String,Integer>();
  String query="SELECT identifier, id FROM achievement;";
  ResultSet set=transaction.query(query,new HashMap<String,Object>());
  while (set.next()) {
    String identifier=set.getString("identifier");
    Integer id=set.getInt("id");
    map.put(identifier,id);
  }
  return map;
}

public Map < String , Integer > loadIdentifierIdPairs ( DBTransaction transaction ) throws SQLException { Map < String , Integer > map = new HashMap < String , Integer > ( ) ; String query = "SELECT identifier, id FROM achievement;" ; ResultSet set = transaction . query ( query , new HashMap < String , Object > ( ) ) ; while ( set . next ( ) ) { String identifier = set . getString ( "identifier" ) ; Integer id = set . getInt ( "id" ) ; map . put ( identifier , id ) ; } return map ; }
loads a map from achievement identifier to database serial
