kiuma wrote:
Hello,
I've the following query
SELECT OBJECT(center) FROM WaActivityCenter center WHERE
center.activities.description = ?1 AND center.status > 0 ORDER BY
center.description
activities and center are in a many to many relation.
during deployment the log is:
Starting failed
org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested
throwable: (org.jboss.ejb.plugins.cmp.ejbql.UnknownPathException: In path cmr
field is collection valued: at line 1, column 75. Encountered: "activities"
after: "center.")
Can anybody help me please?
kiuma
-------------------------------------------------------
This SF.net email is sponsored by:
The Definitive IT and Networking Event. Be There!
NetWorld+Interop Las Vegas 2003 -- Register today!
http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
.
Solved!
SELECT OBJECT(center) FROM WaActivityCenter center, IN(center.activities) activity
WHERE
activity.description = ?1 AND center.status > 0 ORDER BY
center.description
-------------------------------------------------------
This SF.net email is sponsored by:
The Definitive IT and Networking Event. Be There!
NetWorld+Interop Las Vegas 2003 -- Register today!
http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user