I was facing a wired problem that is I'm constructing Hibernate criteria and I have added some constraints to it and then called the criteria.uniqueResult(); it sometimes return results and sometimes return null, however if you take the generated query and execute it against the database it will return result to you.