6:45 p.m.
Suquery not working correctly with <framework:restrictions>
-----------------------------------------------------------
Key: JBSEAM-3302
URL: https://jira.jboss.org/jira/browse/JBSEAM-3302
Project: Seam
Issue Type: Feature Request
Components: Framework
Environment: Windows XP
Reporter: Tim Timson
I have created a query in components xml and added a restriction using the
<framework:restrictions> tag. The restriction should add a where clause, but
instead it is adding an "and", thinking the "where" is already in
place. I assume this is because there is a "where" statement in a subquery
contained in the ejbql.
Here is the entry in components.xml which causes the error.
<framework:entity-query name="eventPricedItemsQuery"
ejbql="select pricedItem,
(select sum(cartEntries.amountCharged)
from Cart as cart
join cart.entries as cartEntries
join cartEntries.item as item
where pricedItem.id = item.id)
from PricedItem pricedItem">
<framework:restrictions>
<value>pricedItem.event = #{currentEvent}</value>
</framework:restrictions>
</framework:entity-query>
I can work around it by removing the restriction and adding a where clause to the ejbql,
but have reasons for wanting to use the <framework:restrictions> tag instead.
Here is some of the stack trace I used to determine that an "and" was being
placed into the query by Seam when a "where" should have been created:
Caused by: javax.el.ELException: /events/registration-report.xhtml @29,71
value="#{eventItems}": java.lang.IllegalArgumentException:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: and near line 1, column 879
[select pricedItem, (select
sum(cartEntries.amountCharged) from
com.el.sbo.model.user.Cart as cart join
cart.entries as cartEntries join cartEntries.item as
item where pricedItem.id = item.id)
,(select count(cartEntries.amountCharged)
from com.el.sbo.model.user.Cart as cart
join cart.entries as cartEntries join
cartEntries.item as item where pricedItem.id =
item.id) from
com.el.sbo.model.event.PricedItem pricedItem and pricedItem.event = :el1]
at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
at javax.faces.component.UIData.getValue(UIData.java:582)
... 68 more
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException:
unexpected token: and near line 1, column 879 [select pricedItem,
(select sum(cartEntries.amountCharged)
from com.el.sbo.model.user.Cart as cart join
cart.entries as cartEntries join cartEntries.item as
item where pricedItem.id = item.id)
,(select count(cartEntries.amountCharged)
from com.el.sbo.model.user.Cart as cart
join cart.entries as cartEntries join
cartEntries.item as item where pricedItem.id =
item.id) from
com.el.sbo.model.event.PricedItem pricedItem and pricedItem.event = :el1]
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:617)
at
org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:96)
at
org.jboss.seam.persistence.EntityManagerProxy.createQuery(EntityManagerProxy.java:79)
at
org.hibernate.search.jpa.impl.FullTextEntityManagerImpl.createQuery(FullTextEntityManagerImpl.java:130)
at
org.jboss.seam.persistence.EntityManagerProxy.createQuery(EntityManagerProxy.java:79)
at org.jboss.seam.framework.EntityQuery.createQuery(EntityQuery.java:175)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira