Folks,

Looking for general guidance re: annotation implemention for large cardinality one to many associations.

Can't locate any explicit examples in the forums, docs, or books.

Trying to add entities to the association w/o loading the entire assoc into memory, etc. Currently experiencing JVM out of memory errors due to same.

Appreciate your assistance.

Don't map the one-to-many association. What would you do with 1 Mio collection elements? Iterate through them?

Exactly, one of the needs is to iterate through such a high cardinality association.

As an example, I need to be able to enumerate all subscribers in a specific geographic region. Thus the one to many (many, many, many...) association. Iterate them all to change a service setting. Query all in the region for a specific setting, etc.

Obviously, such grouping objects (with large associations Sets) are impractical unless the association can be paged.

So now I'm thinking I should implement this as a one to many unidirectional from the child to parent, then use paged queries to enumerate all children of a specific parent group. Avoid the Set on the parent altogether.

Am I on the right track with this?

Cheers