Hi folks! Help me if you can!

I used createSQLQuery tring a count(*) from a teble but it sent me a


HibernateQueryException:

org.springframework.orm.hibernate.HibernateQueryException: Alias [L] does not correspond to any of the supplied return aliases =

{[{L}]} [ SELECT {L.*} FROM LOG {L} WHERE MATCH({L}.SEVERIDADE,{L}.PALAVRAS_CHAVE,{L}.MENSAGEM_CURTA) AGAINST('WARN + ' ' + contestado , cobilling') AND {L}.DATA BETWEEN '2005-01-01' AND '2005-02-02'];

nested exception is net.sf.hibernate.QueryException: Alias [L] does not correspond to any of the supplied return aliases = {[{L}]}

[ SELECT {L.*}
FROM LOG {L} WHERE MATCH({L}.SEVERIDADE,{L}.PALAVRAS_CHAVE,{L}.MENSAGEM_CURTA)
AGAINST('WARN + ' ' + contestado , cobilling')
AND {L}.DATA BETWEEN '2005-01-01' AND '2005-02-02']

How can it be done?! Thanks!!!

Fernando Cangussu