trouble with JBOSS-QL... help

[mattp]

Hello Jboss folk --
All was going well until I tried this little bit o code. Now my bean won't deploy & below is the error. Am I writing the JBOSS-QL correctly?

Thank ya!
matt
-----
Matt Pease
FullScreen

2002-07-18 21:33:44,725 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.FssItemEJB.findByCategory] JBossQL:
SELECT p.fssItem
FROM PositionEJB AS p
WHERE p.category = ?1
ORDER BY p.position DESC


2002-07-18 21:33:44,725 ERROR [org.jboss.ejb.EjbModule] Starting failed

org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "1" at line 4, column 24.

Was expecting one of:

<IDENTIFICATION_VARIABLE> ...

<ENTITY_VALUED_PARAMETER> ...

<ENTITY_VALUED_PATH> ...

)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.(JDBCJBossQLQuery.java:46)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createJBossQLQuery(JDBCCommandFactory.java:54)

[mattp]

I figured out my problem... rather than the jboss-ql from before, I tried this & it works... Lovely!

Still getting the hang of this ejbql stuff.

<jboss-ql><![CDATA[
SELECT p.fssItem
FROM CategoryEJB AS c, IN (c.positions) AS p
WHERE c.id = ?1
ORDER BY p.position DESC
]]></jboss-ql>

Thanks-
Matt

[dsundstrom]

The problem is with the parameter type. JBossQL is looking for a parameter of the correct EntityType, which means either a local or remote interface.