Forums Register Login

HF EJB QL questions.

+Pie Number of slices to send: Send
Folks, could you please comment these questions for me?

Tks in advance!!!

1 - What designates the query domain? WHERE or FROM clause?

2 - What designates the type of objects to be selected? SELECT or FROM clause?

3 - About WHERE clause : "Identification variable can represent a single value or a collection" - Why isn't this statement correct?

Tks!!!
+Pie Number of slices to send: Send
Hi Felipe,

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.

Beno�t
+Pie Number of slices to send: Send
Hi Benoit,

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.

3 - I still dind�t understand this question.

Please let me know if it does not make sense!!!

Tks so much!!!
+Pie Number of slices to send: Send
Hi Felipe,

Thanks for your answer and your corrections...

I think you're right.
I best understand, now, the concept of query domain.
And of course, you're right in the second point !

For the third point, I think I was mistaken.
Can you confirm that the "Identification variable" is the identifier of the entity in the FROM clause: ?

Thanks a lot for your questions and this conversation.
It helps me clarify a lot of things
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
HI Benoit and Gowher !!!

Ok, that's all so folks!!!

Tks sooo much!!!

Have a good studying!!!
I will suppress my every urge. But not this shameless plug:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 688 times.
Similar Threads
Path expression that evaluates to a collection
Hub and Spoke gui design???
someone can tell me about cte?
spec 11.2.7.11 EJB-QL
Qtn Reg EJBQL in HFEJB.
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 04:09:12.