0 Replies Latest reply on Aug 27, 2004 4:35 AM by David Lopez

    Serializable Finder parameter

    David Lopez Newbie

      I'm using JBoss 3.2.5.

      I have an entity bean with 3 cmp fields:
      - Long id
      - Serializable value
      - String description

      And one of the finders methods signature is:

      java.util.Collection findByIdAndValue(Long anId, Serializable aValue)
      throws javax.ejb.FinderException,java.rmi.RemoteException;

      defined with the following EJB-QL query:

      SELECT OBJECT(o) FROM mySchema AS o
      WHERE o.id=?1 and o.value=?2

      Deploying in JBoss fail with this trace:

      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(o) FROM mySchema AS o WHERE o.id=?1 and o.value=?2'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "o.value" at line 1, column 58.
      Was expecting one of:
      "NOT" ...
      "(" ...
      <COLLECTION_VALUED_PATH> ...
      <STRING_VALUED_PATH> ...
      "CONCAT" ...
      "SUBSTRING" ...
      <BOOLEAN_VALUED_PATH> ...
      <DATETIME_VALUED_PATH> ...
      <ENTITY_VALUED_PATH> ...
      <IDENTIFICATION_VARIABLE> ...
      <NUMERIC_VALUED_PATH> ...
      "LENGTH" ...
      "LOCATE" ...
      "ABS" ...
      "SQRT" ...
      "MOD" ...
      "+" ...
      "-" ...
      <INTEGER_LITERAL> ...
      <FLOATING_POINT_LITERAL> ...
      <NUMERIC_VALUED_PARAMETER> ...
      )

      Mean this trace that JBoss cannot handle a finder whith a Serializable parameter? Or a Serializable field in EJB-QL where clause?

      Thanks,
      eSpencer.