Re: OpenJPA querying on element collections

2011-09-28 Thread Howard Mak
KEY was exactly what I was looking for. Thanks! - Howard - Reply message - From: Rick Curtis curti...@gmail.com To: users@openjpa.apache.org users@openjpa.apache.org Subject: OpenJPA querying on element collections Date: Tue, Sep 27, 2011 8:35 am Howard - Yes, it is possible. I'd

Re: OpenJPA querying on element collections

2011-09-27 Thread Rick Curtis
Howard - Yes, it is possible. I'd recommend reading through the JPA 2.0 spec[1] for a more thorough answer. Try something like this: SELECT x FROM Item x WHERE KEY(m_properties)= 'x' 'h' Thanks, Rick [1] JPA 2.0 -- 4.4.4 Path Expressions -- snippet .. In the following query, photos is a map

OpenJPA querying on element collections

2011-09-26 Thread Howard Mak
Hi, Does anyone know if OpenJPA supports queries on element collections? Given: @Entity @Table(name=items) public class Item implements Serializable { @Id @Column(name=seq_no)