Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=UEZ9E1nQ2dX4PUAFQc7ZRBEf1dkMukfjOMiiIPuldSDpFLJonKr/5YDxRLD9BegqMoK5lqOlXwFaJAYmX77gIdD6HKMwRtLer/KfjkwlP/fP691uyvEI8pVbmJeWjqXg0he0oBNEy0wFQ2oyDNHEvMnBT+vxexzhHowmb7Y64EQ=;
Message-ID: <892287.91253.qm@web55905.mail.re3.yahoo.com>
References: <4AF6E280.4050309@gmail.com>
Date: Mon, 9 Nov 2009 09:09:04 -0800 (PST)
From: Fay Wang <fyw300@yahoo.com>
Subject: Re: Unexpected ArgumentException using 'IN' operator
To: users@openjpa.apache.org
In-Reply-To: <4AF6E280.4050309@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hi,
        I tried the following using openjpa trunk, and it works fine. I will try it using openjpa 1.2. 

 Query q =
            em.createQuery("Select m from Manager m, IN (m.employees) emps where emps = :emp");
        Employee emp = new Employee();
        emp.setId(1);
        q.setParameter("emp", emp);


-Fay


----- Original Message ----
From: Vivien Barousse <barousse.vivien@gmail.com>
To: users@openjpa.apache.org
Sent: Sun, November 8, 2009 7:23:44 AM
Subject: Unexpected ArgumentException using 'IN' operator

Hi,

I'm having trouble using the IN operator in OpenJPA 1.2.1.

In my application, I have an entity named 'Entry', which has a many to many relationship to itself on a 'parentEntries' field. Here is the (simplified) code for this entity :

@Entity
public class Entry implements Serializable {

   @Id
   private Long id;

   @ManyToMany
   @JoinTable
   private List<Entry> parentEntries;

   /* ... getters and setters ... */

}


I'm trying to retrieve all entities which parentEntries contains any given entry (passed as argument to my query). Here is the query:

SELECT entry FROM Entry AS entry, IN (entry.parentEntries) AS parent WHERE parent = :entry


This query fails on execution, with an ArgumentException :
<openjpa-1.2.1-r752877:753278 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: The parameter "entry" is of type "com.aperigeek.jtentative.entity.Entry", but the declaration in the query is for type "java.util.List"
       at org.apache.openjpa.persistence.QueryImpl.validateParameter(QueryImpl.java:287)
       at org.apache.openjpa.persistence.QueryImpl.validateParameters(QueryImpl.java:274)
       at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:248)
       at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:294)
       ...

This query works fine with other persistence provider (the above code has been successfully tested with Toplink).

Am I missing something here? I saw in an old bug report (#OPENJPA-190) someone having the same difficulties.
Could this be an OpenJPA bug?

Thanks,

--
Vivien Barousse