EJB Finder problem

[ericmacau]

Hello,

How can I define the query if I want to define a EJB finder with the signature as following:

signature="java.util.Set findByPlayerAndSeason(Player p, Season s)"
query=" ....???..."

How can I define the Query to get all the Goals of a specific Player and Season ???????

+------+ +----------+
| Goal |-------------| Player |
+------+ * 1+----------+
 *|
 |
 1|
+---------+
| Season |
+---------+


Player 1:N Goal
Season 1:N Goal

[julien.dubois]

Hi Eric,

Didn't I answer you previously on that question?
See :
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=45354

Or is there something I didn't understand?

[ericmacau]

Hi Julien,

Thanks for your answer.

If the signature is "Set findByPlayerAndSeason(int playerId, int seasonId)", your QUERY is worked.

But now, the signature is "Set findByPlayerAndSeason(Player p, Season s)"

Does it also works ????


Eric

[julien.dubois]

Hi Eric,

No it won't work if you just send the EJB. But if you've got the EJB, you can easily use your previous query that way :
findByPlayerAndSeason(p.getPlayerId(), s.getSeasonId());

HTH!