Hi, I have a pretty simple case. I am having a person class having an object of address class. So, there is a OneToOne unidirectional mapping between the two. Now, after persisting 3 person objects in database, I fire this query "select p from person p having p.age > 30" where age is a integer field in person class. To my surprise, I was not getting the expected result and it returned all the person's irrespective of their age. The query that was fired on console was "Select ----- from person p" and there was no having clause in that query. I fired the same query directly on database client and it worked there. Is there some mistake in my jpql syntax ? I even tried with slice and without slice. The code I am using is 2.0.0 snapshot version. Please help me understand this issue. May be somewhere I have made a trivial mistake.
thanks and regards -- Ashish Paliwal Mobile : 9305128367 IIT Kanpur India
