Re: [JBoss-user] CMP2 in JBoss3: accessing second level relationsusing ejb-ql

2003-01-13 Thread Jim Clayson
Alex Loubyansky wrote: Jim, the finder returns the local/remote interface[s] corresponding to the type of the home interface in which it is defined. I.e. to get guns, you need to define the finder in the gun's home interface. In your case, you get organizations. alex Monday, January 13, 2003,

Re: [JBoss-user] CMP2 in JBoss3: accessing second level relationsusing ejb-ql

2003-01-13 Thread Jim Clayson
Alex Loubyansky wrote: Hello Jim, I don't remember the right bean/field names but something like this, assuming you pass in organization's id SELECT OBJECT(gun) FROM Organization AS org, IN(org.gangsters) AS gang, IN(gang.guns) AS gun WHERE org.id=?1 As the result you'll get all guns used in t