Thanks for opening a Jira. This may be the symptom of the same problem
as the one described in the second part of CAY-1072. We'll take a look.
Andrus
On Jun 10, 2008, at 1:49 PM, Laurent Marchal wrote:
Hi Andrus,
I have tested with Cayenne 3.0M4 and there is a bug transforming an
expression into EJBQL :
I created a ticket : https://issues.apache.org/cayenne/browse/
CAY-1073
ExpressionFactory.notInExp(DailyJob.DEPARTMENT_ID_PROPERTY,
departmentIds);
---> "SMASTER.DEPTID not in (1, 2)"
Then i transform it to EJBQL with Expression.toEJBQL("a")
---> "a.departmentId not in ()"
the IN clause is empty.
Thanks.
Laurent Marchal.
