Not really sure as I don't use them, but at least one issue with self-joins is solved if you use my outer join patch for 1.2.
https://issues.apache.org/cayenne/browse/CAY-732 On 6/12/07, Fredrik Liden <[EMAIL PROTECTED]> wrote:
What is the status of self joins in v. 1.2.3? From the 2 posts I find in the archive seems like some people are using it. The documentation doesn't mention it. Just wondering if it's ok to use or if there are any limitations that discourages it's use? I'm have a set of nodes. I'm guessing the source node will have Source_node_id NULL or 0. And then the target nodes will refer back to the source nodes Node_id. Would it be worth using self joins here or should I just look up the target nodes based on the source nodes using regular queries and not worry about the relations? NODE Node_id (pk) Text Source_node_id (fk) Thanks! Fredrik
