Optimizing object materialization for 1:N relations

Tino Schöllhorn <[email protected]> Mon, 04 Feb 2008 09:16:20 +0100
Newsgroups gmane.comp.jakarta.ojb.user
Message-ID <[email protected]>
Hi,

we are using OJB-1.0.1 and evertything works fine. Now I have the 
following situation:

We have a security-mechanism which uses the classes ACL 
(AccessControlList) and ACLEntry. One ACL has many ACLEntries. Now  when 
using the standard OJB-Materialization methods OJB uses 2 SQLs to 
materialize on ACL. One for the ACL and one for the ACLEntry.

Because we have MANY of those ACLs I am curious if it is possible to 
overwrite the materialization-method so that just one SQL is used. I 
thought about using "Prefeteched Relationships" but I noticed that there 
are also 2 SQLs.

Any ideas or even example how I could achieve that?

Kind regards
Tino