EDIT

import org.hibernate.Session;

import eu.etaxonomy.cdm.model.taxon.UuidAndTitleCacheTaxonComparator;

    @Override

    public  List<UuidAndTitleCache<TaxonBase>> getUuidAndTitleCache(Integer limit, String pattern){

        Session session = getSession();

        Query query = null;

        if (pattern != null){

            query = session.createQuery("select taxonBase.uuid, taxonBase.id, taxonBase.titleCache, taxonBase.name.rank from TaxonBase as taxonBase where taxonBase.titleCache like :pattern");

            pattern = pattern.replace("*", "%");

            pattern = pattern.replace("?", "_");

            pattern = pattern + "%";

            query.setParameter("pattern", pattern);

            } else {

            query = session.createQuery("select uuid, id, titleCache, taxonBase.name.rank from TaxonBase "  );

        }

        if (limit != null){

           query.setMaxResults(limit);

        }

        return getUuidAndTitleCache(query);

    }

    @Override

    protected List<UuidAndTitleCache<TaxonBase>> getUuidAndTitleCache(Query query){

        List<UuidAndTitleCache<TaxonBase>> list = new ArrayList<UuidAndTitleCache<TaxonBase>>();

        List<Object[]> result = query.list();

        if (result != null && !result.isEmpty()){

            if (result.iterator().next().length == 4){

                Collections.sort(result, new UuidAndTitleCacheTaxonComparator());

            }

        }

        for(Object[] object : result){

            list.add(new UuidAndTitleCache<TaxonBase>((UUID) object[0],(Integer) object[1], (String) object[2]));

        }

        return list;

    }