Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: domain of dombrd@gmail.com designates
 209.85.217.18 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=taPxovnNAnFJEvNIqTGtu+2P1MzyfZiz5k4JntxI2iuMsy5HjWSqqQoPoZXHSJsNkT
         l8DsYY0IU1RK69sdERf1gu7bCXvj+oaSkNqo6UJhyEiNROhFaFm1HZ0FLqoPpxcjMs5v
         K+KGYrYhZzUebLHcf2pWpPzCCHukBpCk2uqWI=
Message-ID: <dc5d39030810030935s7045cf1docffc7efe83fe673c@mail.gmail.com>
Date: Fri, 3 Oct 2008 12:35:14 -0400
From: "Dave Dombrosky" <dombrd@gmail.com>
To: user@cayenne.apache.org
Subject: Re: Getting unmapped PK using EJBQL
In-Reply-To: <dc5d39030810021343u552a511ej57f1cfbe71ec7d2e@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <dc5d39030810021343u552a511ej57f1cfbe71ec7d2e@mail.gmail.com>

Looks like I was slightly wrong about what's happening here.  I can
get the PK just fine if i use the "a.b" path expression I talked about
in the previous post.  However, there is a String that is getting
returned in the query, but not getting set in the Object[] that is
returned from performQuery().

The beginning part of the query ends up looking like this:
    SELECT COUNT(*) AS sc0, t1.foo_id, t2.name AS sc1 FROM...

Yet the sc1 result always ends up being null, even though when I run
the query directly through the DB the column is always not null.

This is starting to look like a bug at this point.  I'll add an issue
in JIRA if I discover more.

-Dave


On Thu, Oct 2, 2008 at 4:43 PM, Dave Dombrosky <dombrd@gmail.com> wrote:
> What is the preferred way to get the PK (or any unmapped column) when
> using an EJBQL query?
>
> If I have a path expression (a.b) that references a table, then the
> query runs to completion.  The only problem here is that the PK column
> doesn't get the sc* alias, so it doesn't get added to the returned
> Object[].  If I try the same path but with ".id" (a.b.id) to reference
> the PK column, then i get the following error:
>
> java.lang.IllegalStateException: Invalid path component: id
> Stack trace
>        * org.apache.cayenne.access.jdbc.EJBQLPathTranslator.processLastPathComponent(EJBQLPathTranslator.java:187)
>        * org.apache.cayenne.access.jdbc.EJBQLPathTranslator.visitPath(EJBQLPathTranslator.java:74)
>        * org.apache.cayenne.ejbql.parser.EJBQLPath.visitChild(EJBQLPath.java:72)
>        * org.apache.cayenne.ejbql.parser.SimpleNode.visit(SimpleNode.java:64)
>        * org.apache.cayenne.access.jdbc.EJBQLSelectColumnsTranslator.visitPath(EJBQLSelectColumnsTranslator.java:105)
>        * org.apache.cayenne.ejbql.parser.EJBQLPath.visitNode(EJBQLPath.java:67)
>        * org.apache.cayenne.ejbql.parser.SimpleNode.visit(SimpleNode.java:60)
>        * org.apache.cayenne.ejbql.parser.SimpleNode.visitChild(SimpleNode.java:84)
>        * org.apache.cayenne.ejbql.parser.SimpleNode.visit(SimpleNode.java:64)
>
> Then if I try prefixing the path expression with "db" (db:a.b.id) I
> get the following error:
>
> java.lang.IllegalStateException: Invalid path component: id
> Stack trace
>        * org.apache.cayenne.access.jdbc.EJBQLPathTranslator.processLastPathComponent(EJBQLPathTranslator.java:187)
>        * org.apache.cayenne.access.jdbc.EJBQLPathTranslator.visitPath(EJBQLPathTranslator.java:74)
>        * org.apache.cayenne.ejbql.parser.EJBQLPath.visitChild(EJBQLPath.java:72)
>        * org.apache.cayenne.ejbql.parser.EJBQLDbPath.visitChild(EJBQLDbPath.java:31)
>        * org.apache.cayenne.ejbql.parser.SimpleNode.visit(SimpleNode.java:64)
>        * org.apache.cayenne.access.jdbc.EJBQLSelectColumnsTranslator.visitPath(EJBQLSelectColumnsTranslator.java:105)
>        * org.apache.cayenne.ejbql.parser.EJBQLPath.visitChild(EJBQLPath.java:72)
>        * org.apache.cayenne.ejbql.parser.EJBQLDbPath.visitChild(EJBQLDbPath.java:31)
>        * org.apache.cayenne.ejbql.parser.SimpleNode.visit(SimpleNode.java:64)
>
> It appears to be using a db-path parser in this last case, but I still
> can't access the column.  What am I doing wrong?
>
> -Dave
>