HQL Query using the relationary operator "or" --------------------------------------------- Key: HHH-2689 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2689 Project: Hibernate3 Issue Type: Bug Components: query-hql Affects Versions: 3.2.0.cr4 Environment: ORACLE 9I HIBERNATE 3.2 Reporter: Luiz Alberto Priority: Critical ************* EXAMPLE TABLE "REQUERIMENTO" IN THE DATA BASE ROWID | ID(PK) | LABO(FK) | GRADUACAO(FK) --------------------------------------------------------- 1 | 110 | 5302332 | NULL 2 | 120 | NULL | 4002993 3 | 130 | NULL | 5321663 4 | 140 | 3698566 | NULL 5 | 150 | 5699636 | NULL ************* Mapping RequerimentoVO .getMatriculaGraduacao() --> GraduacaoVO .getMatriculaLABO() --> LaboVO ************** I use one query "HQL". Predicate "OR" is used of the following form. " FROM RequerimentoVO r " " where ( r.matriculaGraduacao.id = :codigo or r.matriculaLABO.matricula = :codigo ) " Which is the problem? It is bug of the Hibernate? Query returns "null" which and the problem? I am thankful *************** Exception when: " FROM RequerimentoVO r " " where r.matriculaGraduacao.id = :codigo " it returns a RequerimentoVO or in such a way " FROM RequerimentoVO r " " where r.matriculaLABO.matricula = :codigo = :codigo " it returns a RequerimentoVO which and the problem? I am thankful I am thankful ! -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira