[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [eclipselink-users] Too big IN-Clause
|
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
