openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Sutter <>
Subject Re: Foreign key to Unique Key Not working
Date Thu, 07 Jun 2012 19:22:46 GMT
Hi Anu,
The JPA spec indicates that this FK to a non-PK relationship is not
standard across vendors.  From the section on the JoinColumn annotation:

*"If the referencedColumnName element is missing, the foreign key is
assumed to refer to the primary
key of the referenced table.

Support for referenced columns that are not primary key columns of the
referenced table is optional.
Applications that use such mappings will not be portable."

According to the OpenJPA documentation [1], this non-standard join should
be supported, but I have not personally tried it.  You said that you tried
the column reference, but it didn't work..  Was your usage consistent with
the documentation?  Also, what version of OpenJPA are you using?

Good luck,


On Tue, Jun 5, 2012 at 6:18 PM, manushka <> wrote:

> Hello,
> I have a db foreign key pointing to a Unique key and not a Primary key of
> the referenced table,
> Tried column reference but it does not work.
> At the time of the insert on the child record, the INSERT statement shows
> that it is trying to insert the primary key of the referenced table.
> The PK is int where as the unique key is a varchar, so it naturally bombs.
> Is there  away to deal with this scenario or it is not valid for JPA/OPEN
> JPA via the relationships.
> Regards'- Anu
> --
> View this message in context:
> Sent from the OpenJPA Users mailing list archive at

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message