Re: Quick query question

From: Dave Lamy (davelam..mail.com)
Date: Thu Apr 02 2009 - 13:06:37 EDT

  • Next message: Andrey Razumovsky: "Re: Quick query question"

    No, I didn't.. just did the standard Cayenne mapping with a database ID
    column (auto-generated) which of course is not exposed in the Java class.
    What makes this even more fun is that I'm using a generic persistent class
    in several cases, so I don't have concrete Java classes/paths to work with.
    Was hoping to use some sort of pseudo-path like Hibernate's ".id" field in
    hql.

    So far the only real solution to this that I can see is to use a consistent
    PK column naming scheme.. like "ID".. and then use a db:ID path expression.
    But it's not ideal.

    On Thu, Apr 2, 2009 at 12:01 PM, Michael Gentry <mgentr..asslight.net>wrote:

    > Did you map your primary key as a Java attribute? If so, just include it.
    >
    >
    > On Thu, Apr 2, 2009 at 12:53 PM, Dave Lamy <davelam..mail.com> wrote:
    > > I am composing a SelectQuery and want to include an expression to narrow
    > my
    > > results based upon the primary key (just an int ID) as well as other
    > > criteria. I am using the ExpressionFactory to generate the Expressions..
    > > specifically I have
    > >
    > > Expression expr = ExpressionFactory.inExp(<pathToId?>, idCollection);
    > >
    > > Question is: How do I represent the path to the primary key in an
    > > expression string like this?
    > >
    > > Thanks--
    > > Dave
    > >
    >



    This archive was generated by hypermail 2.0.0 : Thu Apr 02 2009 - 13:07:24 EDT