[jboss-user] [EJB 3.0] - Using SQL IN

What is the proper way to do a query using SQL "IN"? The only reference I found is this: http://www.jofti.com/guide/ch3-1.html#title_3_1_8, which is complaining about the colon for the parameter. unexpected token: : near line 1, column 54 [from com.xxxxx.entity.Listing where id IN :ids] id is the primary key of Listing. My code is as follows: @Entity | @Name("listing") | @Table(name = "LISTING") | public class Listing implements java.io.Serializable { | | @Id | @Column(name = "LISTING_ID", length = 22, nullable = false) | public Long getId() { | return this.id; | } | ... | } | List<Long> glids = new ArrayList<Long>(); | | String queryStr = "from Listing where id IN :ids"; | Query query = em.createQuery(queryStr); | query.setParameter("ids", glids); | Object result = query.getResultList(); View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979687#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...