Mailing-List: contact ojb-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "OJB Users List" <ojb-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of gcjou-ojb-user@m.gmane.org
 designates 80.91.229.2 as permitted sender)
To: ojb-user@db.apache.org
From: =?ISO-8859-15?Q?Tino_Sch=F6llhorn?=
 <t.schoellhorn@plattform-gmbh.de>
Subject: Re: Optimizing object materialization for 1:N relations
Date: Thu, 07 Feb 2008 10:22:01 +0100
Lines: 54
Message-ID: <foeika$qmr$1@ger.gmane.org>
References: <fo6hkk$8qu$1@ger.gmane.org> <47AA5995.9070700@apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
In-Reply-To: <47AA5995.9070700@apache.org>
Sender: news <news@ger.gmane.org>

Hi Armin,

thanks for your reply. Do you think it would be worth a try to 
materialize our objects with pure SQL - but after initializing them to 
work with them with OJB?

Thanks for your opinion.

Regards
Tino

Armin Waibel schrieb:
> Hi Tino,
> 
> Tino Sch�llhorn wrote:
>> 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.
> 
> The "Prefeteched Relationships" is useful if you search for more than 
> one ACL, then OJB is able to reduce the queries to read the ACLEntries:
> http://db.apache.org/ojb/docu/guides/query.html#prefetched+relationships
> The upcoming version 1.0.5 use "Prefeteched Relationships" for all 1:n 
> relations.
> 
>>
>> Any ideas or even example how I could achieve that?
>>
> 
> Sorry no.
> 
> regards,
> Armin
> 
>> Kind regards
>> Tino
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org