openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nino Saturnino Martinez Vazquez Wael <>
Subject JPQL query not working..?
Date Tue, 01 Apr 2008 12:10:21 GMT

Im a newcommer both to JPA and OpenJPA. I've used hibernate previously 
as a provider, but found their error messages lacking a lot (almost 
impossible to work with). OpenJPA are how it's supposed to be:) Now you 
only need a criteria api like hibernates:)

However I have a JPQL query which doesnt seem to work as I want. In my 
project I have a Person which haves some trainingSchemes, these 
trainingSchemes has trainingSets and a trainingSet has a exercise. So I 
want a query which returns only persons with a certain exercise, I've 
tried it a dozen ways now. But the result are always the same I get all 
Persons in the database(I actually got the same result in hibernate 
using their criteria api) even though they do not have the exercise i 
query for. Now heres my 2 latest tries:

    * SELECT DISTINCT p FROM Person p, IN(p.trainingSchemes)
      ts,IN(ts.trainingSets) tset, IN(tset.exercise) ex where IN
    * SELECT DISTINCT p FROM Person as p INNER JOIN p.trainingSchemes as
      tscheme INNER JOIN tscheme.trainingSets as tset where IN(someints)

Are there something visibly wrong with those queries? I have a couple of 
other there are working just fine, but it seems as when I go deeper than 
1 relation it does not work?

-Wicket for love

Nino Martinez Wael
Java Specialist @ Jayway DK
+45 2936 7684

View raw message