David Nielsen wrote:
> I have some relations:
>
> [...]
To summarize (and verify), you have
DVDProject --1:N--> MasterSet --1:N--> SubtitleLanguage
> now im trying to make a ejb-ql in my SubtitleBean so i can
> select all subtitles with the projectKey, here is my ejb-ql:
You could also create an ejbSelect on DVDProject, but that's an aside. I
believe the EJB-QL you created should work, but I was just reading Sun's
EJB-QL reference and here's an alternative:
SELECT ms.subtitleLanguages FROM DVDProject p, IN(p.masterSets) ms
WHERE p.projectKey = ?1
You didn't say there were any problems, so I assume it is either working
or you're coding it up now. If it doesn't work, you could try putting
the whole query on one line. I don't know how XDoclet (or its underlying
JavaDoc parsing code) works, and it may not handle wrapped strings like
that.
> is this right ?? i have some problems undestanding the
> x-doclet way to do the sql....
AFAIK, XDoclet just puts the query string into your deployment
descriptors, so there is no such concept as "the x-doclet way to do the
sql."
David Harkness
Sr. Software Engineer
Sony Pictures Digital Networks
(310) 482-4756
-------------------------------------------------------
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn
_______________________________________________
xdoclet-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/xdoclet-user
