[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
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