I've used Cayenne with a DB that didn't have FK constraints (the DB
basically only had PK uniqueness constraints). Worked fine. Just map
things correctly in the modeler.
mrg
On Fri, Mar 27, 2009 at 12:30 PM, Joseph Schmidt
<joseph_schmidt7..ahoo.com> wrote:
>
> Can Cayenne work (consistently) with relationships where the underlying foreign key constraint is missing? (e.g. when the fields for foreign key are there and respect the standard naming convention - artist_id for the relationship pointing to artists but the constraint is not set ?
>
> I tried to reverse engineer such databases, but if the FK constraints are missing, Cayenne Modeler doesn't seem to recognize them (despite of the naming convention) :(.
> It looks like many existing databases don't use the FK constraints (only the naming convention - e.g. all RoR and similar frameworks based applications).
>
>
> Thanks,
> Joseph.
>
>
>
>
>
>
This archive was generated by hypermail 2.0.0 : Fri Mar 27 2009 - 12:51:20 EDT