Hi Hugi,

not sure this is related to your issue but i really like the way Cayenne gives me control of the join type inside a path expression as mentioned here:

http://cayenne.apache.org/doc/path-expressions.html

Of course this is not handled on the model level tho.

Cheers,
Daniel

Am 25.10.2011 14:03, schrieb Andrus Adamchik:
I don't think we had a discussion. We can have it now.

In this particular case my thinking is that relationship itself does not have any 
particular "join semantics"... It is always a match between two keys. If you 
just need to find objects related to a given object, using outer join never makes sense. 
Where it does make sense is in qualifiers. But this makes it a property of a qualifier, 
not the relationship.

In generally it is often hard to find such single place for many ORM properties. There's 
always a concern that anything beyond basic DB mapping is really a property of the 
execution context (e.g. it is different per-application, per-session, per-query, etc. - a 
good example is entity callbacks/listeners adding behavior to the mapping). So this often 
becomes a question of whether "one size fits all".

Andrus


On Oct 25, 2011, at 2:40 PM, Hugi Thordarson wrote:
Thank you Andrus.
Has there ever been discussion of adding the ability to specify join types when 
modeling relationships, or would that be at odds with design intentions? It 
seems like a useful feature.

Cheers,
- hugi



On 25.10.2011, at 11:23, Andrus Adamchik wrote:

Yes, in Cayenne join type is a property of a path in expression or query, not a 
relationship. This is by design.

Andrus

On Oct 25, 2011, at 1:54 PM, Hugi Thordarson wrote:

Good morning all.

The subject says it all, really: Cayenne seems to default to inner joins for 
relationships. Is it possible for me to set the join type for relationships in 
the model, so I don't have to specify the join type for every query? (I always 
want outer joins)

Cheers,
- hugi




Reply via email to