0 Replies Latest reply on Apr 1, 2003 12:41 PM by Don Laidlaw

    DVC column in finder?

    Don Laidlaw Newbie

      JBoss 3.0.3, WinXP

      Is it possible to have a finder find on a column defined in a DVC? When I do this I get CMR errors from the ejb-ql compiler at deployment time:

      org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.UnknownPathException: In path field is not a cmr field: at line 1, column 73. Encountered: "customer" after: "o.")

      Where the query looks like:

      SELECT OBJECT(o) FROM InvoiceHead o WHERE o.customer.number = ?1

      Here, customer is a DVC column, which contains a number getter/setter. The DVC part is working fine. I can findByPrimaryKey and get and set the DVC columns with no errors at all.

      So how do you specify a DVC column in an ejb-ql spec?