how can i handle postgres out-of-range integer as a 2-byte value using ofbiz entity conditions code?

[Anchit Jindal]

Hi All,

I want to fetch some data from a table for this i made a query using following code

EntityCondition exprList = EntityCondition.makeCondition(UtilMisc.toList(
                EntityCondition.makeCondition("partyId", EntityOperator.NOT_EQUAL, null),
                EntityCondition.makeCondition("productId", EntityOperator.IN, productIdsList),
                EntityCondition.makeCondition("availableThruDate", EntityOperator.EQUALS, null)), EntityOperator.AND);

List<GenericValue> supplierProductList = delegator.findList("SupplierProduct", exprList, null, null, null, false);

Now the issue is i have huge amout of data so in  EntityCondition.makeCondition("productId", EntityOperator.IN, productIdsList), condition my query give me Tried to send an out-of-range integer as a 2-byte value: 38298 message. because productIdsList size is very big so now the question is can i handle productIdsList list data in entity condition which send some specific amount of data in seacrh query using some ofbiz base code or i have so write some other logic to send productIdsList in small chunks?

Thanks
Anchit Jindal