I'm running the following query and it is returning the same value althought I have diferent values in the database.
I executed the SQL generated from hibernate in SQLStudio and It executed OK

Hibernate version: 2.1.6

Mapping documents:
<class name="com.br.resource.csu.lembranca.dao.hibernate.persisted.Documento" table="SSC_documento">
<id name="inxDoc" column="INX_DOC" type="integer">
<generator class="increment"/>
</id>
<set name="regras" inverse="true" lazy="true" cascade="all">
<key column="inx_doc"/>
<one-to-many class="com.br.resource.csu.lembranca.dao.hibernate.persisted.DocumentoRegra"/>
</set>
<many-to-one name="codCli" column="COD_CLI"/>
<property name="codClasse" column="COD_CLASSE"/>
<property name="codInstalacao" column="COD_INSTALACAO"/>
<property name="codLivroLeitura" column="COD_LIVRO_LEITURA"/>
<property name="codLocalidade" column="COD_LOCALIDADE"/>
<property name="codLoteFaturamento" column="COD_LOTE_FATURAMENTO"/>
<property name="codMotivoExc" column="COD_MOTIVO_EXC"/>
<property name="codTipoDoc" column="COD_TIPO_DOC"/>
<property name="codUnidOper" column="COD_UNID_OPER"/>
<property name="datCriacaoFatura" column="DAT_CRIACAO_FATURA"/>
<property name="datEmissaoFatura" column="DAT_EMISSAO_FATURA"/>
<property name="datExc" column="DAT_EXC"/>
<property name="datFimCob" column="DAT_FIM_COB"/>
<property name="datInclusaoReg" column="DAT_INCLUSAO_REG"/>
<property name="datIniCob" column="DAT_INI_COB"/>
<property name="datPrevCorte" column="DAT_PREV_CORTE"/>
<property name="datProcArqOrg" column="DAT_PROC_ARQ_ORG"/>
<property name="datVenctoFatura" column="DAT_VENCTO_FATURA"/>
<property name="flgDebAut" column="FLG_DEB_AUT"/>
<property name="indContencioso" column="IND_CONTENCIOSO"/>
<property name="mesRefFatura" column="MES_REF_FATURA"/>
<property name="numFatura" column="NUM_FATURA"/>
<property name="qtdTentativa" column="QTD_TENTATIVA"/>
<property name="totFaturaAvisoDeb" column="TOT_FATURA_AVISO_DEB"/>
<property name="vlrFatura" column="VLR_FATURA"/>
</class>


Code between sessionFactory.openSession() and session.close():
public String testConnection () {
HibernateDaoFactory hibernateDaoFactory = null;
String retorno;

try {
hibernateDaoFactory = new HibernateDaoFactory();
hibernateDaoFactory.openSession();

Iterator iter = hibernateDaoFactory.session.find("from Documento doc where doc.vlrFatura > 400").iterator();
while ( iter.hasNext() ) {
Documento doc2 = (Documento) iter.next();
System.err.println(doc2.getNumFatura()+" - "+doc2.getVlrFatura());
}
System.err.println("finish");
hibernateDaoFactory.commitSession();
hibernateDaoFactory.closeSession();
retorno = "<BR><B><font face='times new roman' size='3'>Conectado com sucesso</font></B>";
} catch (Exception e) {
System.out.println(e);
retorno = "<BR><B><font face='times new roman' size='3'>Erro ao conectar ao JNDI."+e+"</font></B>";
} finally {
}
return retorno;
}


Name and version of the database you are using: oracle 8i



log :

22:31:55,138 ERROR [STDERR] 000192756833 - 715.1
22:31:55,138 ERROR [STDERR] 000192756833 - 715.1
22:31:55,139 ERROR [STDERR] 000192756833 - 715.1
22:31:55,139 ERROR [STDERR] 000192756833 - 715.1
22:31:55,139 ERROR [STDERR] 000192756833 - 715.1
22:31:55,139 ERROR [STDERR] 000192756833 - 715.1
22:31:55,139 ERROR [STDERR] 000192756833 - 715.1
22:31:55,139 ERROR [STDERR] 000192756833 - 715.1
22:31:55,139 ERROR [STDERR] 000192756833 - 715.1
22:31:55,139 ERROR [STDERR] 000192756833 - 715.1
22:31:55,139 ERROR [STDERR] 000192756833 - 715.1
22:31:55,140 ERROR [STDERR] finish

are you sure of your id?

in fact I was using just inxDoc as PK, but the primary key is composed of
inxDoc and codCli

Now, I'm having problems setting the relationship

here is a image of the Database


and my mappings

solved