ParseException with EJBQL expression

Hey guys-- I'm really just now getting into using the EJBQLQuery and am having some difficulties. I don't know whether I'm doing something fundamentally wrong or what. Here's my EJBQL expression that I'm trying to get parsed (running 3.0B1): select COUNT(foo) from ProductCollection foo where fo

Referencing ID fields in EJBQL

Hello all-- I am curious to know how (if possible) to reference a PK field using EJBQL. I tried using the normal expression "db:" syntax but as I saw in the source this won't work. EJBQLPathTranslator.processLastPathComponent() appears to assume that the last part of any path will reference eith

Problem with joining two tables, base one empty.

Hi, I've got a problem with a join-query which I can not convert to a set of objects the way I'd like. The problem is that the base table is empty. I'm querying the following 2 tables: SetInstance --- setId PK setInstanceId PK CollectionSetInstance -

Not polymorphic query

Hi Guys, (In Cayenne 2.0 version) Considering the hierarchical class tree to single table example, if I perform this kind of not-polymorphic query: SelectQuery query = new SelectQuery( Manager.class ); I receive this error : "No inheritance - there must be only one override set"