Hello, Pascal, 

thx for your answer!

Perhaps I didnt ask well. The problem is that I have a hierarchy like
A M <--> 1 B M< --> 1 C M <--> 1 D 
(where A, B, C, D are the table names and M = many)
and I want to get some Entities from C, but I have to make a JOIN on all tables A, B, 
C, D because decision what records are selected depends on some fields in A, B, C, D. 

So when I write a finder-method for Bean C can I write f.e.:
SELECT OBJECT(c) FROM C c WHERE C.B.A.field = ? AND C.B.field = ?

Would the parser accept that? Would I have to define some new Relations (from C to B, 
from B to A)? 

When I would need A-Entities it would be exactly what you wrote! But in this case I 
dont know. 

anonymous wrote : I did not myself try to navigate in the FROM clause. I just test the 
deployment, it is OK: this means that the EJB-QL parser is OK too. 
  | 
I dont understand that. I always write the finder-method, create the interfaces with 
XDoclet, deploy the beans to JBoss and restart JBoss to show me if it works. This is 
quite unproductive. Is there a better and faster way??

Thx for your help!

Lachdanan

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834589#3834589

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834589


-------------------------------------------------------
This SF.Net email is sponsored by Sleepycat Software
Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to 
deliver higher performing products faster, at low TCO.
http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to