"konstantinidis" wrote : 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)? | Yes the query is OK (conform to the spec) and the parser is OK too.
"konstantinidis" wrote : | When I would need A-Entities it would be exactly what you wrote! But in this case I dont know. | I don't know myself : (unspecified in the spec) but the parser is OK too. "konstantinidis" wrote : | 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?? | I just mean that I have tried the syntax in my application (quickly) and redeploy to test. I had no errors, so I can say that the parser is OK. But I don't test the query and look at the results (because I'm not in such a configuration). If you do that, tell me if it works. For testing, I do the same way as you, just don't need to stop and restart JBoss, you can do a hot deployment while running. Pascal View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834593#3834593 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834593 ------------------------------------------------------- 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
