Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.2.3

Mapping documents:

Code between sessionFactory.openSession() and session.close(): YES

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html


How to write this SQL code in Criteria code?
select * from requisicao.solicitacao as so
where
so.idstatus = 5 and

(
EXISTS(
select so1.id as ppp1 from
requisicao.solicitacao as so1,
portal.clienteportal as cli,
portal.agencia as agn,
portal.emissores_agencia as emi,
requisicao.usuariorequisicao as func
where
so1.id = so.id and
so1.idcliente = cli.id and
cli.idagencia = agn.id and
agn.id = emi.idagencia and
emi.idusuariorequisicao = func.id and
func.id = 1
)

or

EXISTS(
select so2.id from
requisicao.solicitacao as so2,
requisicao.centrocusto as cc,
requisicao.regional as rg,
portal.parametrizaragencia pa,
portal.agencia as agn,
portal.emissores_agencia as emi,
requisicao.usuariorequisicao as func

where
so2.id = so.id and

so2.idcentrocusto = cc.id and

cc.idregional = rg.id and

rg.id = pa.idregional AND

pa.idagencia = agn.id and

agn.id = emi.idagencia and

emi.idusuariorequisicao = func.id and

func.id = 1
)
)