The error i m getting is
{"Le flux du protocole RPC (Remote Procedure Call) du flux de données
tabulaires (TDS) entrant est incorrect. Trop de paramètres ont été
fournis dans cette demande RPC. Le nombre maximal est 2100."}
Which translates with something like
"The array of RPC (Remote Procedure Call) data is incorrect. Too many
parameters. The maximal number of parameter is 2100"
Using multi query and splitting the query with smaller lists does not
solve the problem.
On 7 avr, 12:21, similitude2009 <similitude2...@gmail.com> wrote:
> Given a list of id's i want to retrieve all my objects.
>
> i try
> IList<int> oListPersonId = GetAllInterestingPersonId();
> ISession oSession = Factory.GetSession();
> IQuery oQuery.CreateQuery("Select Person from Person p where p.id
> in :pListId");
> oQuery.AddParameterList("pListId",oListPersonId);
> oQuery.List<Person>();
>
> This fails as soon as pListId oListPersonId is big, ie more than ~1000
> ~2000.
>
> Is there a good practice to pass Collections or List as parameters,
> either in Criterias or HQL ?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to nhusers@googlegroups.com
To unsubscribe from this group, send email to
nhusers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
