I am trying to deploy a bean with the EJB-QL and I am getting the following error. Could anyone tell what would be the problem in it.
I have a table called game_feature where game_id, attribute_id are compound primary keys and I have one more field attribute_value.
I need to list all the values for the matching game_id, so I have written the following EJB-QL
<![CDATA[SELECT OBJECT(o) FROM game_feature AS o WHERE o.game_id = ?1]]>
But I am gettiing the following exception:
>>2002-12-19 19:57:56,408 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.GameFeatureEJB.findByGameId] EJB-QL: SELECT DISTINCT OBJECT(o) FROM game_feature AS o WHERE o.game_id = ?1
>>2002-12-19 19:57:56,408 WARN [org.jboss.system.ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=GameAttributeLocal
org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.UnknownPathException: Unknown terminal field: at line 1, column 64. Encountered: "game_id" after: "o.")
Could Any one help me out please.