Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: message received from 54.164.171.186
 which is an MX secondary for users@openjpa.apache.org)
Message-ID: <553E7F67.9050606@debooy.eu>
Date: Mon, 27 Apr 2015 20:26:47 +0200
From: Marco de Booij <marco.development@debooy.eu>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.6.0
MIME-Version: 1.0
To: users@openjpa.apache.org
Subject: Re: Mapping a Join Table with Additional Columns
References: <553D0AE0.8050901@debooy.eu>
 <B9B51307-BB0D-4EA0-A835-3553E1632537@yahoo.de>
In-Reply-To: <B9B51307-BB0D-4EA0-A835-3553E1632537@yahoo.de>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable

The problem is that the join-table has a field (AUTEUR_TYPE) that I need=20
to fill. With the ManyToMany I do not have this possibility.

Regards,

Marco

Op 27-04-15 om 13:35 schreef Mark Struberg:
> Why don=E2=80=99t you use a @ManyToMany relation?
>
> LieGrue,
> strub
>
>
>> Am 26.04.2015 um 17:57 schrieb Marco de Booij <marco.development@deboo=
y.eu>:
>>
>> I use Tomee 1.7.1 with openjpa version openjpa-2.4.0-nonfinal-1598334-=
r422266.
>>
>> I have an entity auteurs and an entity boek. They have a ManyToMany re=
lation through the entity auteurs_boeken. In this entity there is a field=
 type to define the type of the relation (writer, illustrations, ...). I =
followed the https://en.wikibooks.org/wiki/Java_Persistence/ManyToMany pa=
ge and came up with the following classes (left out all constructors, get=
ters, and setters):
>>
>> =3D=3D=3D=3D=3D
>> @Entity
>> @Table(name=3D"AUTEURS", schema=3D"BYBLOS")
>> public class AuteurDto
>>     extends Dto implements Comparable<AuteurDto>, Cloneable {
>>   private static final  long  serialVersionUID  =3D 1L;
>>
>>   @Id
>>   @GeneratedValue(strategy=3DGenerationType.IDENTITY)
>>   @Column(name=3D"AUTEUR_ID", nullable=3Dfalse, unique=3Dtrue)
>>   private Long    auteurId;
>>   @Column(name=3D"NAAM", length=3D100, nullable=3Dfalse)
>>   private String  naam;
>>   @Column(name=3D"VOORNAAM", length=3D100)
>>   private String  voornaam;
>>
>>   @OneToMany(cascade=3DCascadeType.ALL, fetch=3DFetchType.LAZY, mapped=
By=3D"auteur")
>>   private List<AuteurBoekDto> boeken;
>> }
>>
>> =3D=3D=3D=3D=3D
>> @Entity
>> @Table(name=3D"BOEKEN", schema=3D"BYBLOS")
>> public class BoekDto extends Dto implements Comparable<BoekDto>, Clone=
able {
>>   private static final  long  serialVersionUID  =3D 1L;
>>
>>   @Id
>>   @GeneratedValue(strategy=3DGenerationType.IDENTITY)
>>   @Column(name=3D"BOEK_ID", nullable=3Dfalse, unique=3Dtrue)
>>   private Long    boekId;
>>   @Column(name=3D"DEEL", precision=3D5, scale=3D0)
>>   private Integer deel;
>>   @Column(name=3D"DRUK", precision=3D3, scale=3D0)
>>   private Integer druk;
>>   @Column(name=3D"ISBN", length=3D13)
>>   private String  isbn;
>>   @Column(name=3D"JAAR_UITGAVE", precision=3D4, scale=3D0)
>>   private Integer jaarUitgave;
>>   @Column(name=3D"SUBDEEL", length=3D2)
>>   private String  subdeel;
>>   @Column(name=3D"TAAL", length=3D2, nullable=3Dfalse)
>>   private String  taal;
>>   @Column(name=3D"TITEL", length=3D100, nullable=3Dfalse)
>>   private String  titel;
>>
>>   @OneToOne(cascade=3DCascadeType.ALL, fetch=3DFetchType.LAZY)
>>   @JoinColumn(name=3D"SERIE_ID", nullable=3Dfalse, updatable=3Dfalse)
>>   private SerieDto  serie;
>>
>>   @OneToMany(mappedBy=3D"boek", fetch=3DFetchType.LAZY)
>>   private List<AuteurBoekDto> auteurs;
>> }
>>
>> =3D=3D=3D=3D=3D
>> @Entity
>> @Table(name=3D"AUTEURS_BOEKEN", schema=3D"BYBLOS")
>> @IdClass(AuteurBoekPK.class)
>> public class AuteurBoekDto
>>     extends Dto implements Comparable<AuteurBoekDto>, Cloneable {
>>   private static final  long  serialVersionUID  =3D 1L;
>>
>>   @Id
>>   private Long    auteurId;
>>   @Id
>>   private Long    boekId;
>>   @Column(name=3D"AUTEUR_TYPE", nullable=3Dfalse, length=3D1)
>>   private String  auteurType;
>>
>>   @ManyToOne
>>   @PrimaryKeyJoinColumn(name=3D"AUTEUR_ID", referencedColumnName=3D"au=
teurId")
>>   private AuteurDto auteur;
>>   @ManyToOne
>>   @PrimaryKeyJoinColumn(name=3D"BOEK_ID", referencedColumnName=3D"boek=
Id")
>>   private BoekDto   boek;
>> }
>>
>> When I fetch the boeken from within the AuteurDto I get the message:
>> <openjpa-2.4.0-nonfinal-1598334-r422266:1599166 fatal user error> org.=
apache.openjpa.persistence.ArgumentException: "eu.debooy.byblos.domain.Au=
teurBoekDto.auteur" defines a target of "auteurId" for column "AUTEUR_ID"=
, but that target does not exist in table "BYBLOS.AUTEURS".
>> I have the same problem on the BoekDto. BoekDto has a OneToOne relatio=
n with SerieDto and when I read the boeken from there I get the correct b=
oeken so I guess that the problem lies with my implementation of the Many=
ToMany. Can someone show me the way to the correct implementation?
>>
>> Regards,
>>
>> Marco
>