Re: [eclipselink-users] Query hitting in-clause limit

[Sri Sankaran <Sri.Sankaran@xxxxxxx>]

Thanks for the replies.

Subselect is a possibility.  However chunking did the trick.

Sri

-----Original Message-----
From: eclipselink-users-bounces@xxxxxxxxxxx [mailto:eclipselink-users-bounces@xxxxxxxxxxx] On Behalf Of Tom Ware
Sent: Friday, September 24, 2010 7:58 AM
To: EclipseLink User Discussions
Subject: Re: [eclipselink-users] Query hitting in-clause limit

Hi Sri,

   Can the regIdList be built in a subselect?  Will the DB handle that?

   If the subselect does not help, I recommend you go with the obvious workaround and cut the query into chunks yourself.

   Please feel free to enter and enhancement request.  If there is enough community demand for a feature we will consider it.

-Tom

Sri Sankaran wrote:
> Using Eclipselink 2.0 against Oracle 11g database
>  
> I have a query that is resulting in an ORA-01795 error.  This means 
> that the in-clause has more than 1000 values.
>  
> The logic in Java that triggers this result goes something like this:
>  
> List<Long> regIdList = A large list of IDs Query q = 
> entityManager.createQuery("Select r from Registration r where 
> r.registrationId in :regIds"); q.setParameter("regIds", regIdList); 
> List<Registration> results = q.getResultList();
>  
> I have a business need to be able to pull all that data.
>  
> What is the recommended recourse?  I really like Eclipselink's ability 
> to consume a list to construct the appropriate in-clause.  It would be 
> nice if Eclipselink could recognize that the size of the list exceeds 
> Oracle's limit and then chunks it appropriately.
>  
> Wishful thinking? J
>  
> Sri
>  
> 
> 
> ----------------------------------------------------------------------
> --
> 
> _______________________________________________
> 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