EDIT

import java.util.ArrayList;

import java.util.UUID;

import org.hibernate.Query;

import org.hibernate.Session;

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

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

	@Override

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

	    Session session = getSession();

        Query query = session.createQuery(

                "SELECT new " + SortableTaxonNodeQueryResult.class.getName() + "("

                + " uuid, id, titleCache "

                + ") "

                + " FROM TermNode node "

                + " JOIN DefinedTerm term ON node.term = term "

                + (pattern!=null?" WHERE term.titleCache LIKE :pattern":""));

        if(pattern!=null){

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

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

            pattern = pattern + "%";

            query.setParameter("pattern", pattern);

        }

        if (limit != null){

           query.setMaxResults(limit);

        }

        return getUuidAndTitleCache(query);

	}

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

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

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

	        for(Object obj : result){

	            if (obj instanceof SortableTaxonNodeQueryResult) {

	                SortableTaxonNodeQueryResult stnqr = (SortableTaxonNodeQueryResult) obj;

	                list.add(new UuidAndTitleCache<>(stnqr.getTaxonNodeUuid(),stnqr.getTaxonNodeId(), stnqr.getTaxonTitleCache()));

	            }else{

	                Object[] object = (Object[])obj;

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

	            }

	        }

	        return list;

	    }