[eclipselink-users] Collection as an argument to IN() statement

[eclipselink-users] Collection as an argument to IN() statement

From: "Ori Dagan" <ori.dagan@xxxxxxxxx>
Date: Sun, 13 Sep 2009 11:00:42 +0300
Delivered-to: eclipselink-users@eclipse.org
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date :message-id:mime-version:content-type:x-mailer:thread-index :content-language; bh=3JG+Eqyqzdl4FE3n3JhCmUMdmC+8w523Ll/7L3jNOOA=; b=kkgZEzbUhR5r2wvyNSIEptZsaru+9sYfiV6Frc5yflJXZwaumznhKpQE0BKp53gY7Y qVg0UU5sYti1fwyr+Jq9y08oyEQ/5VVdQr0DAtRUFmcX29QH4PkDv8muXWW+A+xvpy1C 7CEPfSsriHxyVsSUcNVUAmupNrz+MuX8u5NWE=
Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:message-id:mime-version:content-type:x-mailer :thread-index:content-language; b=mO/gECJnsZPTGRzVhnBJ40VuKlbv0JdAv8peXY5SYD2q8BU3SKlzw8+JE5B9gn8JBo HnIUusG8Vr/9DGBcwxOd4l4rfJzdNvfxAJ5ShGg76fLqE367y2J0wKZu3iuxvyrTAD6S ctewvlBgYYuTJasmRaMQurD9wQVBIwG+YoOQI=
Thread-index: Aco0SEqneHzJ6WZTRoitYZk2OQXntw==

Hi,

I’m trying to pass a collection as an argument to a named query IN statement, and getting an exception:

“You have attempted to set a value of type class java.util.ArrayList for parameter ids with expected type of long from query…”

According to JPA 2.0 spec this should be allowed.

I’m using glassfish v3 latest promoted build which uses eclipselink M7 if I understand correctly.

What am I missing?

Thanks,

Ori

Follow-Ups:
- Re: [eclipselink-users] Collection as an argument to IN() statement
  - From: James Sutherland