[quote=von.juliano]Você tem um StatusItem dentro de cada Item, e é nele que está o valor do status de cada Item, é isso mesmo?
Cola o sql gerado pelo hibernate aqui pra facilitar.[/quote]
É isso ai!!! olha o que sai…
Ele gera duas consultas, na primeira ele realmente está fazendo a consulta que quero, porem, na segunda consulta ele de alguma forma perde os dados retornados na consulta antes feita e ai meu dados já não são os que eu espero receber…
11:04:33,828 INFO [STDOUT] Hibernate:
select
this_.ID as ID205_7_,
this_.DATA_HORA_CRIACAO as DATA2_205_7_,
this_.MES_ANO_REFERENCIA as MES3_205_7_,
this_.FK_ESTABELECIMENTO_ID as FK5_205_7_,
this_.FK_STATUS_LOTE_ID as FK4_205_7_,
estabeleci4_.ID as ID204_0_,
estabeleci4_.RAZAO_SOCIAL as RAZAO2_204_0_,
estabeleci4_.INSCRICAO_ESTADUAL as INSCRICAO3_204_0_,
estabeleci4_.EMAIL as EMAIL204_0_,
estabeleci4_.TELEFONE as TELEFONE204_0_,
estabeleci4_.ABREVIATURA as ABREVIAT6_204_0_,
estabeleci4_.FROTA as FROTA204_0_,
statusdolo1_.ID as ID209_1_,
statusdolo1_.DESCRICAO as DESCRICAO209_1_,
itemdelote2_.ID as ID202_2_,
itemdelote2_.FK_CLIENTE_ID as FK7_202_2_,
itemdelote2_.FK_LOTE_ID as FK8_202_2_,
itemdelote2_.NUMERO_NOTA as NUMERO2_202_2_,
itemdelote2_.SERIE_NOTA as SERIE3_202_2_,
itemdelote2_.DATA_EMISSAO_NOTA as DATA4_202_2_,
itemdelote2_.DATA_RECEBTO_NOTA as DATA5_202_2_,
itemdelote2_.FK_STATUS_ITEM_LOTE_ID as FK6_202_2_,
cliente7_.ID as ID201_3_,
cliente7_.CGC_CPF as CGC2_201_3_,
cliente7_.FAVORECIDO as FAVORECIDO201_3_,
cliente7_.CGC_CPF_FAVORECIDO as CGC4_201_3_,
cliente7_.NOME as NOME201_3_,
cliente7_.FANTASIA as FANTASIA201_3_,
cliente7_.INSCRICAO_ESTADUAL as INSCRICAO7_201_3_,
cliente7_.NUMERO_CEI as NUMERO8_201_3_,
cliente7_.EMAIL as EMAIL201_3_,
cliente7_.NRO_FUNCIONARIOS as NRO10_201_3_,
cliente7_.VALOR_DOACAO as VALOR11_201_3_,
cliente7_.CODIGO as CODIGO201_3_,
cliente7_.FILIAL as FILIAL201_3_,
cliente7_.NOTA_FISCAL_FROTA as NOTA14_201_3_,
lote8_.ID as ID205_4_,
lote8_.DATA_HORA_CRIACAO as DATA2_205_4_,
lote8_.MES_ANO_REFERENCIA as MES3_205_4_,
lote8_.FK_ESTABELECIMENTO_ID as FK5_205_4_,
lote8_.FK_STATUS_LOTE_ID as FK4_205_4_,
statuslote9_.ID as ID209_5_,
statuslote9_.DESCRICAO as DESCRICAO209_5_,
statusitem10_.ID as ID208_6_,
statusitem10_.DESCRICAO as DESCRICAO208_6_
from
adeb.CNF_LOTE this_,
adeb.CNFADC_CONVENIADAS estabeleci4_,
adeb.CNF_STATUS_LOTE statusdolo1_,
adeb.CNF_ITEM_LOTE itemdelote2_,
adeb.CNFADC_CLIENTES cliente7_,
adeb.CNF_LOTE lote8_,
adeb.CNF_STATUS_LOTE statuslote9_,
adeb.CNF_STATUS_ITEM_LOTE statusitem10_
where
this_.FK_ESTABELECIMENTO_ID=estabeleci4_.ID
and this_.FK_STATUS_LOTE_ID=statusdolo1_.ID
and this_.ID=itemdelote2_.FK_LOTE_ID
and itemdelote2_.FK_CLIENTE_ID=cliente7_.ID(+)
and itemdelote2_.FK_LOTE_ID=lote8_.ID(+)
and lote8_.FK_STATUS_LOTE_ID=statuslote9_.ID(+)
and itemdelote2_.FK_STATUS_ITEM_LOTE_ID=statusitem10_.ID(+)
and this_.FK_STATUS_LOTE_ID=?
and itemdelote2_.FK_STATUS_ITEM_LOTE_ID=?
11:04:33,843 INFO [STDOUT] Hibernate:
select
itensdelot0_.FK_LOTE_ID as FK8_3_,
itensdelot0_.ID as ID3_,
itensdelot0_.ID as ID202_2_,
itensdelot0_.FK_CLIENTE_ID as FK7_202_2_,
itensdelot0_.FK_LOTE_ID as FK8_202_2_,
itensdelot0_.NUMERO_NOTA as NUMERO2_202_2_,
itensdelot0_.SERIE_NOTA as SERIE3_202_2_,
itensdelot0_.DATA_EMISSAO_NOTA as DATA4_202_2_,
itensdelot0_.DATA_RECEBTO_NOTA as DATA5_202_2_,
itensdelot0_.FK_STATUS_ITEM_LOTE_ID as FK6_202_2_,
cliente1_.ID as ID201_0_,
cliente1_.CGC_CPF as CGC2_201_0_,
cliente1_.FAVORECIDO as FAVORECIDO201_0_,
cliente1_.CGC_CPF_FAVORECIDO as CGC4_201_0_,
cliente1_.NOME as NOME201_0_,
cliente1_.FANTASIA as FANTASIA201_0_,
cliente1_.INSCRICAO_ESTADUAL as INSCRICAO7_201_0_,
cliente1_.NUMERO_CEI as NUMERO8_201_0_,
cliente1_.EMAIL as EMAIL201_0_,
cliente1_.NRO_FUNCIONARIOS as NRO10_201_0_,
cliente1_.VALOR_DOACAO as VALOR11_201_0_,
cliente1_.CODIGO as CODIGO201_0_,
cliente1_.FILIAL as FILIAL201_0_,
cliente1_.NOTA_FISCAL_FROTA as NOTA14_201_0_,
statusitem2_.ID as ID208_1_,
statusitem2_.DESCRICAO as DESCRICAO208_1_
from
adeb.CNF_ITEM_LOTE itensdelot0_,
adeb.CNFADC_CLIENTES cliente1_,
adeb.CNF_STATUS_ITEM_LOTE statusitem2_
where
itensdelot0_.FK_CLIENTE_ID=cliente1_.ID
and itensdelot0_.FK_STATUS_ITEM_LOTE_ID=statusitem2_.ID
and itensdelot0_.FK_LOTE_ID in (
select
this_.ID
from
adeb.CNF_LOTE this_,
adeb.CNFADC_CONVENIADAS estabeleci4_,
adeb.CNF_STATUS_LOTE statusdolo1_,
adeb.CNF_ITEM_LOTE itemdelote2_,
adeb.CNFADC_CLIENTES cliente7_,
adeb.CNF_LOTE lote8_,
adeb.CNF_STATUS_LOTE statuslote9_,
adeb.CNF_STATUS_ITEM_LOTE statusitem10_
where
this_.FK_ESTABELECIMENTO_ID=estabeleci4_.ID
and this_.FK_STATUS_LOTE_ID=statusdolo1_.ID
and this_.ID=itemdelote2_.FK_LOTE_ID
and itemdelote2_.FK_CLIENTE_ID=cliente7_.ID(+)
and itemdelote2_.FK_LOTE_ID=lote8_.ID(+)
and lote8_.FK_STATUS_LOTE_ID=statuslote9_.ID(+)
and itemdelote2_.FK_STATUS_ITEM_LOTE_ID=statusitem10_.ID(+)
and this_.FK_STATUS_LOTE_ID=?
and itemdelote2_.FK_STATUS_ITEM_LOTE_ID=?
)