Hibernate Sql-Query

Pessoal to com um problema que nao estou conseguindo resolver.

Preciso executar seguinte comando sql no hibernate.

select * from tbl_histoescal where dataalte = ( select max(dataalte) from tbl_histoescal where codcolab = ? and codempresa = ?);

Coloquei no hibernate assim

<sql-query name="ProcurarHistoricoEscalaPorColab">
		<return alias="HistoEscal"  class="br.com.controle.db.model.historico.HistoEscal" />
		select
    		h.CODESCALA as {HistoEscal.Escala}    				
		from
			TBL_HISTOESCAL h				
		where
			h.DATAALTE = (select max(DATAALTE) as DATAALTE from TBL_HISTOESCAL where CODCOLAB = :Colaborador and CODEMPRESA = :Empresa)
	</sql-query>

E ele insisti a da esse erro quando faço consulta…

Hibernate: select
h.CODESCALA as CODESCALA474_0_
from
TBL_HISTOESCAL h
where
h.DATAALTE = (select max(DATAALTE) as DATAALTE from TBL_HISTOESCAL where CODCOLAB = ? and CODEMPRESA = ?)
15:42:59,718 INFO TimestampType:182 - could not read column value from result set: DATAALTE474_0_; Nome de coluna inválido
15:42:59,718 WARN JDBCExceptionReporter:77 - SQL Error: 17006, SQLState: null
15:42:59,718 ERROR JDBCExceptionReporter:78 - Nome de coluna inválido

as colunas estao certas pois eu executo no sql e funfa…

Alguem tm uma Ideia? :idea:

Vlw

Topicos relacionados