2 questions about EJB-QL

[Edward Chen]

Hi, all. I am confusing the EJB-QL.
1. Function is:
public abstract Collection ejbSelectAllMovies() throws FinderException
QL is:
select OBJECT(m) FROM MovieSchema m WHERE m.genre = ?1
actually, in the method, there is NO any parameter, which one is parameter 1 ?
//-----------
2.
QL is
SELECT DISTINCT OBJECT (m) FROM MovieSchema m
Actually what I am confusing is "DINSTINCT". MovieSchema, a database with primary key, is IMPOSSIBLE to contain a same data in a row because of different primary key value.
so, it is resonable to change to this
SELECT DISTINCT m.title FROM MovieSchema m
if the m.title is not primary key.
Am I right?
//-------
Thanks.
Edward

[Lasse Koskela]

in the method, there is NO any parameter, which one is parameter 1 ?

There has to be a method parameter... In other words, either add a method parameter or hardcode the value of "genre" into the EJB-QL.
[ January 02, 2004: Message edited by: Lasse Koskela ]

[Lasse Koskela]

2.
QL is
SELECT DISTINCT OBJECT (m) FROM MovieSchema m
Actually what I am confusing is "DINSTINCT". MovieSchema, a database with primary key, is IMPOSSIBLE to contain a same data in a row because of different primary key value.
so, it is resonable to change to this
SELECT DISTINCT m.title FROM MovieSchema m
if the m.title is not primary key.
Am I right?

The two EJB-QLs you posted return a different thing (a Movie object versus a String, most likely) so it's really difficult to say whether the change is reasonable or not.