Hi,
I am not aware of a dedicated tutorial (and it's been a while since 3.0, so I
don't remember where we stood with the Modeler capabilities), but the general
approach would be the same for any Cayenne version. Consider a "classic"
many-to-many DB schema: two tables, and join table between them: A - AB - B:
1. Model DbEntities for all 3 of them
2. Model two pairs of bi-directional DbRelationships:
"abs" from A to AB ("To Many" and "To Dep PK" checked), "a" from AB to A ("To
One", "To Dep PK" not checked)
"abs" from B to AB ("To Many" and "To Dep PK" checked), "b" from AB to B ("To
One", "To Dep PK" not checked)
3. Model ObjEntities for A and B (but not for AB)
4. Create 2 "flattened" ObjRelationships:
"bs" from A to B, spanning two DbRelationships: "abs.b"
"as" from B to A, spanning two DbRelationships: "abs.a"
Hope this helps.
Andrus
> On Nov 13, 2025, at 10:41 AM, Andre Gustavo Lomonaco
> <[email protected]> wrote:
>
> Hi.
>
> I am still using Cayenne Modeler 3.0 in my application and I need help
> if possible to find some good tutorial for creating Many to Many
> Relationship
> using Modeler 3.0.
>
> I found one-to-many but not many-to-many tutorials.
>
> If someone can indicate me a link I really will appreciate it
>
> Thanks a lot
>
> Andre Gustavo
