Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: 
 <CAMkwXW5m-4N4BitBVoNvmNfnViMXcoL5ppf_Q5UrMTF5O_b-JQ@mail.gmail.com>
References: 
 <CAMkwXW5m-4N4BitBVoNvmNfnViMXcoL5ppf_Q5UrMTF5O_b-JQ@mail.gmail.com>
From: Michael Gentry <mgentry@masslight.net>
Date: Mon, 12 Dec 2011 12:08:26 -0500
Message-ID: 
 <CAA-upzrb4jYaFh_FQ4GuoOfbwVaSPpyGveJqVTpzO4VzdX-BDA@mail.gmail.com>
Subject: Re: Problem with inheritance
To: user@cayenne.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hi Mathias,

I believe you are trying to use a currently unimplemented inheritance
mechanism.  Cayenne does not currently support horizontal
(multiple-table) inheritance:

http://cayenne.apache.org/doc/inheritance-overview.html

There are tricks you can do to make working with multiple related
tables easier (such as adding getters/setters in your subclass to
reference the parent), but you cannot currently model this behavior
automatically.

mrg


On Fri, Dec 9, 2011 at 3:00 AM, Mathias Clerc <tlarhices@gmail.com> wrote:
> Hello,
>
> It seems like I have missed something in inheritance in Cayenne.
>
> I have one main table called "Element" with fields id (PK), name and description
> Another table "File" inherits from "Element" with fields ID(PK, FK on
> Element.id) and path.
>
> When I do a context.performIteratedQuery(new
> SelectQuery(Element.class)) The query I see is :
> SELECT t0.ID, t0.DESCRIPTION, t0.NAME, t0.TYPE, t0.ID, t0.ID, t0.PATH
> FROM ELEMENT t0
>
> I tried checking and unchecking the "To Dep PK" field for the relation in ID.
>
> What did I miss ?