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: domain of hsterl@us.ibm.com designates
 32.97.110.152 as permitted sender)
Subject: JPQL issues querying maps with persistent collections
To: users@openjpa.apache.org
Message-ID: 
 <OFCEF559D7.A0DFD236-ON872575CB.0062DC55-852575CB.00640777@us.ibm.com>
From: Heather Sterling <hsterl@us.ibm.com>
Date: Thu, 4 Jun 2009 14:12:36 -0400
MIME-Version: 1.0
Content-type: multipart/alternative;
	Boundary="0__=08BBFF58DFF15AC58f9e8a93df938690918c08BBFF58DFF15AC5"
Content-Disposition: inline

--0__=08BBFF58DFF15AC58f9e8a93df938690918c08BBFF58DFF15AC5
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable


Hi,

I have the following classes, ManagedElement and DynamicProperty, decla=
red
but I am having trouble querying based on the String[] values that are
mapped as a persistent collection.  I also have a question regarding a =
JOIN
that may/may not be required.

The following works to retrieve a ManagedElement with a DynamicProperty=
 of
a given name.
String queryString =3D "SELECT nr FROM NamingRuleTestElement nr JOIN
nr.appliesTo_DynamicProperty dyn WHERE dyn.name =3D 'PROPID_mStringArra=
y'";

However, I would think that removing the extra JOIN would be allowed si=
nce
it's a 1-Many relationship.  But the following does not work:
String queryString =3D "SELECT nr FROM NamingRuleTestElement nr WHERE
nr.appliesTo_DynamicProperty.name =3D 'PROPID_mStringArray'";

I am able to query the values using the MEMBER OF clause:
String queryString =3D "SELECT nr FROM NamingRuleTestElement nr JOIN
nr.appliesTo_DynamicProperty dyn WHERE dyn.name =3D 'PROPID_mStringArra=
y'
AND ?1 MEMBER OF dyn.values";
Query q =3D em.createQuery(queryString);
q.setParameter(1, "a");

but not using the IN clause:
String queryString =3D "SELECT nr FROM NamingRuleTestElement nr JOIN
nr.appliesTo_DynamicProperty dyn WHERE dyn.name =3D 'PROPID_mStringArra=
y' AND
dyn.values IN ('a','b')";

I think I've been looking at this for too long.  Any help is greatly
appreciated.  Thanks!

------------------------------------------------------

@Entity
@Inheritance(strategy=3DInheritanceType.TABLE_PER_CLASS)
@Table(name=3D"ManagedElement")
public abstract class ManagedElement implements IEntity {

    /**
     * Collection of dynamic properties associated with this element.
     */
    @OneToMany(targetEntity=3DDynamicProperty.class, mappedBy=3D
"appliesTo_ManagedElement", cascade=3D{CascadeType.ALL})
    @MapKey(name=3D"name")
    private Map<String, DynamicProperty> appliesTo_DynamicProperty =3D =
new
HashMap<String, DynamicProperty>();
....
}...

@Entity(name=3D"NamingRuleTestElement")
@Table(name =3D "namingrule_test_element")
@DiscriminatorValue("NamingRuleTestElement")
public class NamingRuleTestElement extends ManagedElement {

}


@Entity
@Table(name=3D"DYNAMIC_PROPERTY")
public class DynamicProperty {

    @Basic
    @Column(length=3D255, nullable=3Dfalse)
    String name;

    /** Array values are stored as persistent collections, so they are
queryable */
    @PersistentCollection
    @ContainerTable(name=3D"DYNAMIC_PROPERTY_ARRAY_VALUES")
    @ElementColumn(length=3D4000)
    String[] values;

.....
}....

Heather Sterling
Systems Management Development
Phone:  919-254-7163 T/L: 444-7163
Cell: 919-423-3143
Email: hsterl@us.ibm.com=

--0__=08BBFF58DFF15AC58f9e8a93df938690918c08BBFF58DFF15AC5--