Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
MIME-Version: 1.0
In-Reply-To: <8A2AE276-1DFD-47EE-A0EB-EAA3FF65CD9F@amphorainc.com>
References: <8A2AE276-1DFD-47EE-A0EB-EAA3FF65CD9F@amphorainc.com>
From: Mike Kienenberger <mkienenb@gmail.com>
Date: Mon, 17 Apr 2017 12:18:10 -0400
Message-ID: <CAM1yOja7rUY2t7Yu9ETav6iV-6jmKjzRS_0Q+b1b1q4vQtQD9g@mail.gmail.com>
Subject: Re: Poorly modeled to-one relationship help
To: user@cayenne.apache.org
Content-Type: multipart/alternative; boundary=001a113d3e205bd926054d5f241a
archived-at: Mon, 17 Apr 2017 16:18:36 -0000

--001a113d3e205bd926054d5f241a
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Set the as "toDep PK" property as true for the db relationship from cost to
cost_ext_info for the COST DbEntity.

https://www.google.com/search?q=3Dcayenne+dependent+primary+key

On Mon, Apr 17, 2017 at 12:11 PM, Ken Anderson <ken.anderson@amphorainc.com=
>
wrote:

> All,
>
>
>
> We have a situation in our database that seems to require some special
> tricks in Cayenne to make work.  One of our developers is having issues
> with the following situation:
>
>
>
> Table                      Primary Key
>
>
>
> cost                        cost_num
>
> cost_ext_info       cost_num
>
>
>
> The cost_ext_info table just has the same primary key that the cost table
> has.  We use custom primary key generation for cost (grabs from another
> table), but how do we setup the relationship so the cost_num is propagate=
d
> from the cost table when we insert both at the same time?
>
>
>
> In WO, I would make the relationship to-many, and it would propagate the
> primary key down.  If we try that in Cayenne, it still tries to fill in t=
he
> primary key of cost_ext_info before propagating apparently (since we=E2=
=80=99re
> getting an error that it can=E2=80=99t create a primary key for cost_ext_=
info).
>
>
>
> Thoughts?  Many thanks in advance.
>
>
>
> Ken
>
>
>
> *Ken Anderson*
>
> CTO Amphora, Inc.
>
> Mobile:   +1 914 262 8540 <(914)%20262-8540>
>
>
>
> [image: id:image001.png@01CE8142.D18AEB10]
>
>
> www.amphorainc.com
>
>
> Confidentiality Notice: This e-mail and accompanying documents contain
> confidential information intended for a specific individual and purpose.
> This e-mailed information is private and protected by law. If you are not
> the intended recipient, you are hereby notified that any disclosure,
> copying, or distribution, or the taking of any action based on the conten=
ts
> of this information, is strictly prohibited.
>

--001a113d3e205bd926054d5f241a--