Mailing-List: contact cayenne-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cayenne-user@incubator.apache.org
Received-SPF: pass (asf.osuosl.org: domain of blacknext@gmail.com designates
 64.233.166.181 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=nzzapYgLWd0422paZOT/kJDOkRcr1W9imNgJhrayWUGoKThfGYFFTtJyQJ/7qE8g9C0Sph8ynlCn5G1ax06WUGM5wuOB9YKTLqF3SI187qafSFh2pStE4Tz1g12mwg18aARCudv9OukmGD/OUiZcHsWJi9+WjQZsh3xkj36f4TQ=
Message-ID: <f65b8ae30605290737j1f1c9den9a4fdcc1bf9a7f7f@mail.gmail.com>
Date: Mon, 29 May 2006 10:37:55 -0400
From: "Michael Gentry" <blacknext@gmail.com>
To: cayenne-user@incubator.apache.org
Subject: Re: Type for class designator column when using STI?
In-Reply-To: <4477AB7D.8010900@pfrog.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <4477AB7D.8010900@pfrog.com>

You should be able to use integers or strings (or others, but those
are the most practical).

When mapping to a legacy schema we have, I mapped PSEnumeratedItem as
a subclass of PSItem.  Set the Java class (I think the superclass is
automatically set when you use the pulldown to specify the parent) to
your desired class, and in the qualifier enter you criteria.  For
example, mine is:

moniker =3D "ES"

But you could easily have an integer listed in there.  Cayenne should
automatically create the correct class instance for you when it reads
from the DB.

Also, make sure you initialize the correct values when you create new
objects (Cayenne doesn't do this for you automatically).  For example:

public class PSEnumeratedItem extends _PSEnumeratedItem
{
  public void setPersistenceState(int state)
  {
    super.setPersistenceState(state);

    // if object was just created, initialize values
    if (state =3D=3D PersistenceState.NEW)
    {
       setMoniker("ES");
    }
  }
}

/dev/mrg

PS. My qualifier (they have to differ) for PSItem is: moniker =3D "QQ"
PPS. I don't remember if it is required that the parent has a qualifier.


On 5/26/06, Jeff de Vries <jdevries@pfrog.com> wrote:
> Does it matter what data type the "class designator column" is when
> using STI?  Are there any expectations on the values in the class
> designator column? For example, can you use an integer column, with 1
> meaning Employee, 2 meaning Manager, 3 meaning Customer, etc?  Does
> Cayenne know what class to instantiate by looking at the qualifier
> expression?
>
> Thanks,
> Jeff de Vries
>
>