1- The WHERE clause reduces the scope of the query and limit the number of items selected. I think we can say that's the query domain but i'm interested too in a confirmation.
2- The FROM clause determines the entity bean types that will be included in the SELECT statement. (it provides the "scope" of the SELECT)
3- It's illegal to navigate cross a collection-based relashionship field. This makes sense: you can't use a navigation operator (.) in Java to access elements of a Collection.
The Chapter 9 of O'reilly EJB3 books is very good in EJBQL.
First of all, tks for providing me this information!! ;-) "The Chapter 9 of O'reilly EJB3 books is very good in EJBQL."
As far my questions/your asnwers....here is what I�ve found later:
1 - The FROM clause designates the query domain. And the "query domain" means "the deploy descriptor - ejb-jar.xml" i mean..all those entity beans which have been declared inside some specific ejb.-jar.xml and that can have a relationship.
2 - What designates the type of objects to be selected? SELECT clause.
SELECT OBJECT (m) FROM MovieSchema AS m In above query A SELECT clause determines the type of the objects or values to be selected FROM clause defines Domain and also identification variable. m is identification variable.