EDIT

    private static final ICdmDataSource defaultSource = CdmDestinations.cdm_test_local_mysql_euromed();

//    private static final ICdmDataSource defaultSource = CdmDestinations.cdm_pesi2019_final();

    boolean doReferences = false;

    boolean doTaxa = true;

        boolean success = true;

        ResultSet srcRS = source.getResultSet("SELECT CAST(tn.id as char(20)) tid, tb.uuid as GUID, pt.id parentId, "

                + "      tn.rank_id, rank.titleCache rank_name, "

                + "      tn.genusOrUninomial, tn.infraGenericEpithet, tn.specificEpithet, tn.infraSpecificEpithet, "

                + "      tn.nameCache, tn.authorshipCache, tn.titleCache nameTitleCache, tn.fullTitleCache nameFullTitleCache, "

                + "      tb.DTYPE taxStatus, tb.titleCache, tb.appendedPhrase tbAppendedPhrase, tb.sec_id secId, "

                + "     LEFT JOIN TaxonName tn on tb.name_id = tn.id "

                + "     LEFT JOIN DefinedTermBase rank ON rank.id = tn.rank_id "

                + "     LEFT JOIN Reference sec ON sec.id = tb.sec_id "

                + "     LEFT JOIN TaxonName_NomenclaturalStatus nsMN ON tn.id = nsMN.TaxonName_id "

                + "     LEFT JOIN NomenclaturalStatus ns ON ns.id = nsMN.status_id "

                + "     LEFT JOIN DefinedTermBase nsType ON nsType.id = ns.type_id "

        success &= equals("Taxon GUID", srcRS.getString("GUID"), destRS.getString("GUID"), id);

        success &= equals("Taxon DerivedFromGuid", srcRS.getString("GUID"), destRS.getString("DerivedFromGuid"), id); //according to SQL script GUID and DerivedFromGuid are always the same, according to 2014DB this is even true for all databases

        success &= isNull("ExpertGUID", destRS, id);  //according to SQL + PESI2014

//FIXME !!        success &= equals("Taxon cache citation", srcRS.getString("secTitle"), destRS.getString("CacheCitation"), id);

        success &= equals("Taxon Last Action", srcRS.getString("lastAction"),  destRS.getString("LastAction"), id);

        success &= equals("Taxon Last Action Date", srcRS.getTimestamp("lastActionDate"),  destRS.getTimestamp("LastActionDate"), id);

        return success;

    }

    private String makeSource(ResultSet srcRs) throws SQLException {

        String secStr = srcRs.getString("secTitle");

        if (secStr == null){

        success &= equals("CommonName name ", srcRs.getString("vername"), destRs.getString("CommonName"), id);

        success &= equals("Common name languageFk ", srcRs.getString("iso"), getLanguageIso(destRs), id);

        success = equals("CommonName LanguageCache ", normalizeLang(srcRs.getString("LanName")), destRs.getString("LanguageCache"), id);

        success &= isNull("Region", destRs, id);  //region does not seem to exist in ERMS

//        success &= isNull("SourceFk", destRs);  //sources should be moved to extra table, check with PESI 2014

//        success &= isNull("SourceNameCache", destRs);  //sources should be moved to extra table, check with PESI 2014

        success &= isNull("SpeciesExpertGUID", destRs, id);  //SpeciesExpertGUID does not exist in ERMS

        success &= equals("Reference abstract ", srcRS.getString("referenceAbstract"), destRS.getString("Abstract"), id);

        success &= equals("Reference title ", srcRS.getString("title"), destRS.getString("Title"), id);

        success &= equals("Reference author string ", srcRS.getString("author"), destRS.getString("AuthorString"), id);

        success &= equals("Reference year ", normalizeYear(srcRS), destRS.getString("RefYear"), id);

//        success &= equals("Reference NomRefCache ", srcRS.getString("abbrevTitleCache"), destRS.getString("NomRefCache"), id);

        success &= equals("Reference DOI ", srcRS.getString("doi"), destRS.getString("Doi"), id);

        success &= equals("Reference link ", srcRS.getString("uri"), destRS.getString("Link"), id);

//        success &= equals("Reference note ", srcRS.getString("source_note"), destRS.getString("Notes"), id);

        //complete

        return success;