From cristiano.rufino at gmail.com Sun Sep 10 12:09:47 2006
Content-Type: multipart/mixed; boundary="===============8482589324335309706=="
MIME-Version: 1.0
From: Cristiano Rufino <cristiano.rufino at gmail.com>
To: hibernate-dev at lists.jboss.org
Subject: [hibernate-dev] many-to-one association no persists
Date: Sun, 10 Sep 2006 13:09:46 -0300
Message-ID: <2f2ae9520609100909t3e98eb2dif235890fcaeb52fc@mail.gmail.com>

--===============8482589324335309706==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

Hello,

I am having a problem to insert or update the Exam object, as follow:

Exam.hbm.xml
[code]

<!DOCTYPE hibernate-mapping PUBLIC
     "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
     "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

 <hibernate-mapping>
 <!--
     Created by the Middlegen Hibernate plugin 2.2

     <a href=3D"http://boss.bekk.no/boss/middlegen/" target=3D"_blank"
rel=3D"nofollow">http://boss.bekk.no/boss/middlegen/</a>
     <a href=3D"http://www.hibernate.org/" target=3D"_blank"
rel=3D"nofollow">http://www.hibernate.org/</a>
 -->

 <class
     name=3D"Exam"
     table=3D"exam"
 >

     <composite-id name=3D"comp_id" class=3D"ExamPK">
         <key-property
             name=3D"cdUnit"
             column=3D"cd_unit"
             type=3D"java.lang.Integer"
             length=3D"4"
         />
         <key-property
             name=3D"cdExam"
             column=3D"cd_exam"
             type=3D"java.lang.Integer"
             length=3D"4"
         />
     </composite-id>

     <many-to-one
         name=3D"pacient"
         class=3D"Pacient"
         not-null=3D"true"
         update=3D"false"
 	insert=3D"false"
     >
         <column name=3D"cd_pacient" />
         <column name=3D"cd_unit" />
     </many-to-one>

 </class>
 </hibernate-mapping>

 [/code]

The problem is that the association with pacient is not pesisting in
the database, due to update=3D"false" insert=3D"false" configuration.
But without this configuration, occour a mapping error:
org.hibernate.MappingException: Repeated column in mapping for entity:
Exam column: cd_unit (should be mapped with insert=3D"false" update=3D"fals=
e").

The exam table have as PK (cd_exam and cd_unit) e the pacient table PK
(cd_pacient and cd_unit).
But I need to persist the reference to pacient when I am insert or
update the exam objet in the database.

Please could anyone help me?

Thanks,
Rufino.

--===============8482589324335309706==
Content-Type: text/html
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"

SGVsbG8sPGJyPgo8YnI+CkkgYW0gaGF2aW5nIGEgcHJvYmxlbSB0byBpbnNlcnQgb3IgdXBkYXRl
IHRoZSBFeGFtIG9iamVjdCwgYXMgZm9sbG93Ojxicj4KPGJyPgpFeGFtLmhibS54bWw8YnI+Cltj
b2RlXTxicj4KPHNwYW4gY2xhc3M9InBvc3Rib2R5Ij48cHJlPiZsdDshRE9DVFlQRSBoaWJlcm5h
dGUtbWFwcGluZyBQVUJMSUM8YnI+ICAgICAmcXVvdDstLy9IaWJlcm5hdGUvSGliZXJuYXRlIE1h
cHBpbmcgRFREIDMuMC8vRU4mcXVvdDs8YnI+ICAgICAmcXVvdDs8YSBocmVmPSJodHRwOi8vaGli
ZXJuYXRlLnNvdXJjZWZvcmdlLm5ldC9oaWJlcm5hdGUtbWFwcGluZy0zLjAuZHRkIj5odHRwOi8v
aGliZXJuYXRlLnNvdXJjZWZvcmdlLm5ldC9oaWJlcm5hdGUtbWFwcGluZy0zLjAuZHRkCjwvYT4m
cXVvdDsgJmd0Ozxicj4gICAgIDxicj4gJmx0O2hpYmVybmF0ZS1tYXBwaW5nJmd0Ozxicj4gJmx0
OyEtLSA8YnI+ICAgICBDcmVhdGVkIGJ5IHRoZSBNaWRkbGVnZW4gSGliZXJuYXRlIHBsdWdpbiAy
LjI8YnI+IDxicj4gICAgICZsdDthIGhyZWY9JnF1b3Q7PGEgaHJlZj0iaHR0cDovL2Jvc3MuYmVr
ay5uby9ib3NzL21pZGRsZWdlbi8iPmh0dHA6Ly9ib3NzLmJla2subm8vYm9zcy9taWRkbGVnZW4v
CjwvYT4mcXVvdDsgdGFyZ2V0PSZxdW90O19ibGFuayZxdW90OyByZWw9JnF1b3Q7bm9mb2xsb3cm
cXVvdDsmZ3Q7PGEgaHJlZj0iaHR0cDovL2Jvc3MuYmVray5uby9ib3NzL21pZGRsZWdlbi8iPmh0
dHA6Ly9ib3NzLmJla2subm8vYm9zcy9taWRkbGVnZW4vPC9hPiZsdDsvYSZndDs8YnI+ICAgICAm
bHQ7YSBocmVmPSZxdW90OzxhIGhyZWY9Imh0dHA6Ly93d3cuaGliZXJuYXRlLm9yZy8iPgpodHRw
Oi8vd3d3LmhpYmVybmF0ZS5vcmcvPC9hPiZxdW90OyB0YXJnZXQ9JnF1b3Q7X2JsYW5rJnF1b3Q7
IHJlbD0mcXVvdDtub2ZvbGxvdyZxdW90OyZndDs8YSBocmVmPSJodHRwOi8vd3d3LmhpYmVybmF0
ZS5vcmcvIj5odHRwOi8vd3d3LmhpYmVybmF0ZS5vcmcvPC9hPiZsdDsvYSZndDs8YnI+IC0tJmd0
Ozxicj4gPGJyPiAmbHQ7Y2xhc3MgPGJyPiAgICAgbmFtZT0mcXVvdDtFeGFtJnF1b3Q7IAo8YnI+
ICAgICB0YWJsZT0mcXVvdDtleGFtJnF1b3Q7PGJyPiAmZ3Q7PGJyPiA8YnI+ICAgICAmbHQ7Y29t
cG9zaXRlLWlkIG5hbWU9JnF1b3Q7Y29tcF9pZCZxdW90OyBjbGFzcz0mcXVvdDtFeGFtUEsmcXVv
dDsmZ3Q7PGJyPiAgICAgICAgICZsdDtrZXktcHJvcGVydHkgPGJyPiAgICAgICAgICAgICBuYW1l
PSZxdW90O2NkVW5pdCZxdW90OyA8YnI+ICAgICAgICAgICAgIGNvbHVtbj0mcXVvdDtjZF91bml0
JnF1b3Q7IAo8YnI+ICAgICAgICAgICAgIHR5cGU9JnF1b3Q7amF2YS5sYW5nLkludGVnZXImcXVv
dDs8YnI+ICAgICAgICAgICAgIGxlbmd0aD0mcXVvdDs0JnF1b3Q7PGJyPiAgICAgICAgIC8mZ3Q7
PGJyPiAgICAgICAgICZsdDtrZXktcHJvcGVydHkgPGJyPiAgICAgICAgICAgICBuYW1lPSZxdW90
O2NkRXhhbSZxdW90OyA8YnI+ICAgICAgICAgICAgIGNvbHVtbj0mcXVvdDtjZF9leGFtJnF1b3Q7
IAo8YnI+ICAgICAgICAgICAgIHR5cGU9JnF1b3Q7amF2YS5sYW5nLkludGVnZXImcXVvdDs8YnI+
ICAgICAgICAgICAgIGxlbmd0aD0mcXVvdDs0JnF1b3Q7PGJyPiAgICAgICAgIC8mZ3Q7PGJyPiAg
ICAgJmx0Oy9jb21wb3NpdGUtaWQmZ3Q7ICAgIDxicj4gPGJyPiAgICAgJmx0O21hbnktdG8tb25l
PGJyPiAgICAgICAgIG5hbWU9JnF1b3Q7cGFjaWVudCZxdW90Ozxicj4gICAgICAgICBjbGFzcz0m
cXVvdDtQYWNpZW50JnF1b3Q7Cjxicj4gICAgICAgICBub3QtbnVsbD0mcXVvdDt0cnVlJnF1b3Q7
PGJyPiAgICAgICAgIHVwZGF0ZT0mcXVvdDtmYWxzZSZxdW90Ozxicj4gCWluc2VydD0mcXVvdDtm
YWxzZSZxdW90Ozxicj4gICAgICZndDs8YnI+ICAgICAgICAgJmx0O2NvbHVtbiBuYW1lPSZxdW90
O2NkX3BhY2llbnQmcXVvdDsgLyZndDs8YnI+ICAgICAgICAgJmx0O2NvbHVtbiBuYW1lPSZxdW90
O2NkX3VuaXQmcXVvdDsgLyZndDsKPGJyPiAgICAgJmx0Oy9tYW55LXRvLW9uZSZndDs8YnI+IDxi
cj4gJmx0Oy9jbGFzcyZndDs8YnI+ICZsdDsvaGliZXJuYXRlLW1hcHBpbmcmZ3Q7PGJyPjxicj4g
Wy9jb2RlXTxicj4gPGJyPlRoZSBwcm9ibGVtIGlzIHRoYXQgdGhlIGFzc29jaWF0aW9uIHdpdGgg
cGFjaWVudCBpcyBub3QgcGVzaXN0aW5nIGluIHRoZSBkYXRhYmFzZSwgZHVlIHRvIHVwZGF0ZT0m
cXVvdDtmYWxzZSZxdW90OyBpbnNlcnQ9JnF1b3Q7ZmFsc2UmcXVvdDsgY29uZmlndXJhdGlvbi4K
PGJyPkJ1dCB3aXRob3V0IHRoaXMgY29uZmlndXJhdGlvbiwgb2Njb3VyIGEgbWFwcGluZyBlcnJv
cjo8c3BhbiBjbGFzcz0icG9zdGJvZHkiPiBvcmcuaGliZXJuYXRlLk1hcHBpbmdFeGNlcHRpb246
IFJlcGVhdGVkIGNvbHVtbiBpbiBtYXBwaW5nIGZvciBlbnRpdHk6PGJyPkV4YW0gY29sdW1uOiBj
ZF91bml0IChzaG91bGQgYmUgbWFwcGVkIHdpdGggaW5zZXJ0PSZxdW90O2ZhbHNlJnF1b3Q7IHVw
ZGF0ZT0mcXVvdDtmYWxzZSZxdW90OykuCjxicj48YnI+VGhlIGV4YW0gdGFibGUgaGF2ZSBhcyBQ
SyAoY2RfZXhhbSBhbmQgY2RfdW5pdCkgZSB0aGUgcGFjaWVudCB0YWJsZSBQSyAoY2RfcGFjaWVu
dCBhbmQgY2RfdW5pdCkuPGJyPkJ1dCBJIG5lZWQgdG8gcGVyc2lzdCB0aGUgcmVmZXJlbmNlIHRv
IHBhY2llbnQgd2hlbiBJIGFtIGluc2VydCBvciB1cGRhdGUgdGhlIGV4YW0gb2JqZXQgaW4gdGhl
IGRhdGFiYXNlLjxicj48YnI+ClBsZWFzZSBjb3VsZCBhbnlvbmUgaGVscCBtZT88YnI+PC9zcGFu
Pjxicj5UaGFua3MsPGJyPlJ1Zmluby48YnI+PC9wcmU+PC9zcGFuPjxicj4K

--===============8482589324335309706==--

From max.andersen at jboss.com Sun Sep 10 12:31:45 2006
Content-Type: multipart/mixed; boundary="===============2324511070221754588=="
MIME-Version: 1.0
From: Max Rydahl Andersen <max.andersen at jboss.com>
To: hibernate-dev at lists.jboss.org
Subject: Re: [hibernate-dev] many-to-one association no persists
Date: Sun, 10 Sep 2006 18:31:30 +0200
Message-ID: <op.tfn76semsj49yt@xam>
In-Reply-To: 2f2ae9520609100909t3e98eb2dif235890fcaeb52fc@mail.gmail.com

--===============2324511070221754588==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

http://forum.hibernate.org

> Hello,
>
> I am having a problem to insert or update the Exam object, as follow:
>
> Exam.hbm.xml
> [code]
>
> <!DOCTYPE hibernate-mapping PUBLIC
>      "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
>      "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
>
>  <hibernate-mapping>
>  <!--
>      Created by the Middlegen Hibernate plugin 2.2
>
>      <a href=3D"http://boss.bekk.no/boss/middlegen/" target=3D"_blank"
> rel=3D"nofollow">http://boss.bekk.no/boss/middlegen/</a>
>      <a href=3D"http://www.hibernate.org/" target=3D"_blank"
> rel=3D"nofollow">http://www.hibernate.org/</a>
>  -->
>
>  <class
>      name=3D"Exam"
>      table=3D"exam"
>  >
>
>      <composite-id name=3D"comp_id" class=3D"ExamPK">
>          <key-property
>              name=3D"cdUnit"
>              column=3D"cd_unit"
>              type=3D"java.lang.Integer"
>              length=3D"4"
>          />
>          <key-property
>              name=3D"cdExam"
>              column=3D"cd_exam"
>              type=3D"java.lang.Integer"
>              length=3D"4"
>          />
>      </composite-id>
>
>      <many-to-one
>          name=3D"pacient"
>          class=3D"Pacient"
>          not-null=3D"true"
>          update=3D"false"
>  	insert=3D"false"
>      >
>          <column name=3D"cd_pacient" />
>          <column name=3D"cd_unit" />
>      </many-to-one>
>
>  </class>
>  </hibernate-mapping>
>
>  [/code]
>
> The problem is that the association with pacient is not pesisting in
> the database, due to update=3D"false" insert=3D"false" configuration.
> But without this configuration, occour a mapping error:
> org.hibernate.MappingException: Repeated column in mapping for entity:
> Exam column: cd_unit (should be mapped with insert=3D"false"  =

> update=3D"false").
>
> The exam table have as PK (cd_exam and cd_unit) e the pacient table PK
> (cd_pacient and cd_unit).
> But I need to persist the reference to pacient when I am insert or
> update the exam objet in the database.
>
> Please could anyone help me?
>
> Thanks,
> Rufino.



-- =

--
Max Rydahl Andersen
callto://max.rydahl.andersen

Hibernate
max(a)hibernate.org
http://hibernate.org

JBoss a division of Red Hat
max.andersen(a)jboss.com


--===============2324511070221754588==--