0 Replies Latest reply on Dec 19, 2002 9:43 AM by Jayendran

    Unknown terminal field

    Jayendran Newbie

      Hi All,

      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.

      Bit Explanation:
      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.