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?