Hi Milosz, May I know if there is any workaround for this and if there are plans to address it? Thank you for the reference!
On Tue, Dec 15, 2009 at 5:44 AM, Miłosz <mtyle...@o2.pl> wrote: > Hi, > > I guess this is an OpenJPA limitation - only queries over single-valued > elements are supported. There is a section on XML mapping in the user manual > [1]. > > Regards, > Milosz > > [1] > http://openjpa.apache.org/builds/latest/docs/manual/manual.html#ref_guide_xmlmapping > > > > Hi, > > > > I am having trouble executing a JPA named query that uses multi-valued > > elements, within an XML column, as criteria. > > > > I have a table with the following DB2 schema: > > CREATE TABLE SWD.Dummy ( > > dummyId VARCHAR(32) NOT NULL, > > properties XML NOT NULL > > ) > > DATA CAPTURE NONE; > > > > ALTER TABLE SWD.Dummy ADD CONSTRAINT Dummy_PK PRIMARY KEY (dummyId); > > > > and I used JAXB to generate the beans for marshalling & unmarshalling > from > > the XSD schema defined for the "properties" XML column. My XSD schema is > as > > follows: > > > > <?xml version="1.0" encoding="utf-8"?> > > <xsd:schema version="1.0" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> > > <xsd:element name="properties" type="propertiesType" /> > > <xsd:complexType name="propertiesType"> > > <xsd:sequence> > > <xsd:element maxOccurs="unbounded" name="property" > > type="propertyType" /> > > </xsd:sequence> > > </xsd:complexType> > > <xsd:complexType name="propertyType"> > > <xsd:sequence> > > <xsd:element name="keyy" type="xsd:string" /> > > <xsd:element name="valuee" type="xsd:string" /> > > </xsd:sequence> > > </xsd:complexType> > > </xsd:schema> > > > > In summary, the element "properties" is the root element and it contains > > any number of "property" elements which in turn may contain "keyy" and > > "valuee" string elements. An example of an XML compliant with the schema: > > > > <?xml version="1.0" encoding="UTF-16" > > > ?><properties><property><keyy>abc</keyy><valuee>123</valuee></property><property><keyy>def</keyy><valuee>xyz</valuee></property></properties> > > > > > > > > I am able to use JPA to make simple queries on the Dummy entity. However, > I > > get an error if I try to query on the "property" element. > > For example, I get an exception if I execute the following JPQL query: > > SELECT d FROM Dummy d, IN (d.properties.property) p WHERE p.keyy=:keyy > AND > > p.valuee=:valuee > > > > The stack trace that I get is: > > com.example.DAOException: <openjpa-2.0.0-M3-r422266:822833 nonfatal user > > error> org.apache.openjpa.persistence.ArgumentException: > > collection-valued-path > > at com.example.DummyDAO.findDummyByProperty(DummyDAO.java:142) > > at com.example.GetDummyService.invoke(GetDummyService.java:63) > > ... 32 more > > Caused by: > > <openjpa-2.0.0-M3-r422266:822833 nonfatal user error> > > org.apache.openjpa.persistence.ArgumentException: collection-valued-path > > at > > > org.apache.openjpa.kernel.exps.AbstractExpressionBuilder.traverseXPath(AbstractExpressionBuilder.java:269) > > at > > > org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getPath(JPQLExpressionBuilder.java:1921) > > at > > > org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.addJoin(JPQLExpressionBuilder.java:741) > > at > > > org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.evalFromClause(JPQLExpressionBuilder.java:680) > > at > > > org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.evalFromClause(JPQLExpressionBuilder.java:666) > > at > > > org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getQueryExpressions(JPQLExpressionBuilder.java:292) > > at org.apache.openjpa.kernel.jpql.JPQLParser.eval(JPQLParser.java:67) > > at > > > org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.<init>(ExpressionStoreQuery.java:728) > > at > > > org.apache.openjpa.kernel.ExpressionStoreQuery.newDataStoreExecutor(ExpressionStoreQuery.java:170) > > at > > org.apache.openjpa.kernel.QueryImpl.createExecutor(QueryImpl.java:742) > > at > > > org.apache.openjpa.kernel.QueryImpl.compileForDataStore(QueryImpl.java:700) > > at > > > org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:682) > > at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:582) > > at > > > com.ibm.ws.persistence.EntityManagerImpl.createNamedQuery(EntityManagerImpl.java:104) > > at > > > com.ibm.ws.persistence.EntityManagerImpl.createNamedQuery(EntityManagerImpl.java:36) > > at > > > com.ibm.ws.jpa.management.JPATxEmInvocation.createNamedQuery(JPATxEmInvocation.java:116) > > at > > > com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:332) > > at com.example.DummyDAO.findDummyByProperty(DummyDAO.java:137) > > ... 33 more > > > > I've tweaked the query many times, but am unable to get it working. I > > couldn't find resources online regarding this either, so I would greatly > > appreciate any help on this, thank you! > >