SELECT DISTINCT on collection-desciptor?

[Terrence M Drozdowski <te...@xymox.net>]

Is there a way to have the collection-descriptor select only distinct
records from the indirection-table automatically?

If not - is there a way to do it manually?  I'd hate to have to iterate
through the list and remove all the non-unique rows.

Thx.

-terry

Re: SELECT DISTINCT on collection-desciptor?

[Jakob Braeuchi <jb...@gmx.ch>]

hi terrence,

ojb provides a QueryCustomizer to adapt fkQueries to your needs.
sample can be found in tutorial3.html.

hth
jakob


Terrence M Drozdowski wrote:

>Is there a way to have the collection-descriptor select only distinct
>records from the indirection-table automatically?
>
>If not - is there a way to do it manually?  I'd hate to have to iterate
>through the list and remove all the non-unique rows.
>
>Thx.
>
>-terry
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>  
>

Re: SELECT DISTINCT on collection-desciptor?

[Jakob Braeuchi <jb...@gmx.ch>]

hi steffen,

the usage of query customizer is quite simple:
- the query to fetch a collection is passed as parameter
- modify this query as you like.

simply inherit from the DefaultQueryCustomizer.

hth
jakob

Steffen Haßler wrote:

> hi terrence,
>
> i'm a newbe and i have the same problem. i hope you solve the problem
> with the QueryCustomizer. if you solve the problem, please send me a
> sample that i can use this function too.
>
> i didn't understand the QueryCustomizer description.
>
> thx
>   steffen
>
> Terrence M Drozdowski wrote:
>
>> Is there a way to have the collection-descriptor select only distinct
>> records from the indirection-table automatically?
>>
>> If not - is there a way to do it manually?  I'd hate to have to iterate
>> through the list and remove all the non-unique rows.
>>
>> Thx.
>>
>> -terry
>>
>>
>> ---------------------------------------------------------------------
>> 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
>
>

Re: SELECT DISTINCT on collection-desciptor?

[Steffen Haßler <sh...@visualgroup.de>]

hi terrence,

i'm a newbe and i have the same problem. i hope you solve the problem
with the QueryCustomizer. if you solve the problem, please send me a
sample that i can use this function too.

i didn't understand the QueryCustomizer description.

thx
   steffen

Terrence M Drozdowski wrote:
> Is there a way to have the collection-descriptor select only distinct
> records from the indirection-table automatically?
> 
> If not - is there a way to do it manually?  I'd hate to have to iterate
> through the list and remove all the non-unique rows.
> 
> Thx.
> 
> -terry
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
>