Re: [eclipselink-users] Too big IN-Clause

[Steffen Förster <foerster@xxxxxxxx>]

Hello Tom,
cannot use a sub select because our client software delivers only the list to the server.

Meanwhile I wrote a small method which manipulates the translated sql-statement just before the query.getResultList() call.

Yours Steffen

-----Ursprüngliche Nachricht-----
Von: eclipselink-users-bounces@xxxxxxxxxxx [mailto:eclipselink-users-bounces@xxxxxxxxxxx] Im Auftrag von Tom Ware
Gesendet: Mittwoch, 24. Oktober 2012 17:17
An: EclipseLink User Discussions
Betreff: Re: [eclipselink-users] Too big IN-Clause

Thanks, Steffen.

Is it possible to use a subselect for your in clause?

On 24/10/2012 11:03 AM, Steffen Förster wrote:
> Hello Tom,
> i filed a bug for this issue
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=392762
>
> Our JDO Provider uses an OR clause. It's not fast but such queries are not time-critical.
>
> Yours
> Steffen
>
>
> -----Ursprüngliche Nachricht-----
> Von: eclipselink-users-bounces@xxxxxxxxxxx
> [mailto:eclipselink-users-bounces@xxxxxxxxxxx] Im Auftrag von Tom Ware
> Gesendet: Mittwoch, 24. Oktober 2012 16:43
> An: eclipselink-users@xxxxxxxxxxx
> Betreff: Re: [eclipselink-users] Too big IN-Clause
>
> Hi Steffen,
>
>     Unfortunately, we have currently have no feature that will automatically decompose the list of groups into smaller groups.  What does your JDO provider do to decompose them?  Send multiple queries?  Use an OR clause?
>
>     It would be a good idea to enter a feature request.
>
> -Tom
>
> On 24/10/2012 8:26 AM, Steffen Förster wrote:
>> I have a named query that looks like this:
>>
>> SELECT r FROM RIGHTS r WHERE r.group NOT IN :groups
>>
>> The Parameter is a list of known groups and want to find all orphan rights. I try to find a generic way around this problem without changing every query. Our old JDO solution provided a generic workaround for large in arguments.
>>
>> -----Ursprüngliche Nachricht-----
>> Von: eclipselink-users-bounces@xxxxxxxxxxx
>> [mailto:eclipselink-users-bounces@xxxxxxxxxxx] Im Auftrag von Tom 
>> Ware
>> Gesendet: Mittwoch, 24. Oktober 2012 14:20
>> An: eclipselink-users@xxxxxxxxxxx
>> Betreff: Re: [eclipselink-users] Too big IN-Clause
>>
>> Can you please provide an example?
>>
>> On 24/10/2012 3:59 AM, Steffen Förster wrote:
>>> Hello everyone,
>>>
>>> we are moving from a JDO based persistencesolution to eclipselink
>>> (2.4.1.v20121003-ad44345) but we are faceing a problem with in 
>>> clauses. In some cases the argument list is too long and the oracle 
>>> database throws *"**ORA-01795". Is there a workaround without 
>>> changing our queries? Can I manipulate the SQL-call somewhere to 
>>> split the **arguments**in **smaller****chunks**? I need a generic 
>>> way to do so.*
>>>
>>> Thanks in advance.
>>>
>>> Yours
>>>
>>> Steffen Förster
>>>
>>>
>>>
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>> _______________________________________________
>> eclipselink-users mailing list
>> eclipselink-users@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>> _______________________________________________
>> eclipselink-users mailing list
>> eclipselink-users@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users