EDIT

import org.hibernate.Query;

import org.hibernate.Session;

import eu.etaxonomy.cdm.model.common.TermType;

import eu.etaxonomy.cdm.persistence.dto.UuidAndTitleCache;

    @Override

    public <S extends FeatureTree> List<UuidAndTitleCache<S>> getUuidAndTitleCacheByTermType(Class<S> clazz, TermType termType, Integer limit,

            String pattern) {

        Session session = getSession();

        Query query = session.createQuery(

                " SELECT uuid, id, titleCache "

                        + " FROM " + clazz.getSimpleName()

                        + (pattern!=null?" WHERE titleCache LIKE :pattern":" WHERE 1 = 1 ")

                        + (termType!=null?" AND termType = :termType ":"")

                );

        if(pattern!=null){

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

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

            pattern = pattern + "%";

            query.setParameter("pattern", pattern);

        }

        if(termType!=null){

            query.setParameter("termType", termType);

        }

        if (limit != null){

           query.setMaxResults(limit);

        }

        return getUuidAndTitleCache(query);

    }