Hy Armin,
here is my
#########################
# repository_rollen.xml #
#########################
<class-descriptor
class="de.on_ergy.lakon.data.model.Rollen" table="rollen">
<field-descriptor
name="objId"
column="obj_id"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="false">
</field-descriptor>
....
<!-- m - n über gruppen_rollen zu gruppen -->
<collection-descriptor
name="gruppen"
collection-class=
"org.apache.ojb.broker.util.collections.ManageableArrayList"
element-class-ref="de.on_ergy.lakon.data.model.Gruppen"
auto-retrieve="true"
auto-update="object"
auto-delete="link"
proxy="true"
indirection-table="gruppen_rollen"
>
<fk-pointing-to-this-class column="rollen_obj_id"/>
<fk-pointing-to-element-class column="gruppen_obj_id"/>
</collection-descriptor>
</class-descriptor>
#####################################
# way, storing "Gruppe" and "Rollen" #
#####################################
// store "Rolle"
RollenIfc rolleBenutzerverw = (RollenIfc)
getInstanceOf(RollenIfc.class);
rolleBenutzerverw.setKennzeichen("BENUTZERVERW");
rolleBenutzerverw.setObjId(new
Integer(RollenIfc.ROLLE_BENUTZER_VERWALTUNG));
broker.beginTransaction();
broker.store(rolleBenutzerverw);
broker.commitTransaction();
broker.close();
// instanciate "Gruppe" and referenz to "Rolle"
GruppenIfc gruppeSysAdm = (GruppenIfc) getInstanceOf(GruppenIfc.class);
gruppeSysAdm.setKennzeichen("SYSADMIN");
gruppeSysAdm.setRollen(new Vector());
gruppeSysAdm.getRollen().add(rolleBenutzerverw);
broker.beginTransaction();
broker.store(gruppeSysAdm);
broker.commitTransaction();
broker.close();
Thanks for your help.
Josef
-----Ursprüngliche Nachricht-----
Von: Armin Waibel [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 17. Mai 2006 01:44
An: OJB Users List
Betreff: Re: WG: OJB do delete and insert instead of update
Hi Josef,
could you post the mapping for 'Rollen' too and a code snippet how you
are store 'Gruppen'. Then I can try to reproduce your problem.
regards,
Armin
Josef Wagner wrote:
Hi,
here an example of my DELETE and INSERT problem (OJB 1.0.3):
##################
# repository.xml #
##################
<class-descriptor
class="de.on_ergy.lakon.data.model.Gruppen"
table="gruppen">
<field-descriptor
name="objId"
column="obj_id"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true">
</field-descriptor>
.....
<!-- m - n width gruppen_rollen to rollen -->
<collection-descriptor
name="rollen"
collection-
class="org.apache.ojb.broker.util.collections.ManageableArrayList"
element-class-ref="de.on_ergy.lakon.data.model.Rollen"
auto-retrieve="true"
auto-update="object"
auto-delete="link"
proxy="true"
indirection-table="gruppen_rollen">
<fk-pointing-to-this-class column="gruppen_obj_id"/>
<fk-pointing-to-element-class column="rollen_obj_id"/>
</collection-descriptor>
</class-descriptor>
############################################################################
# output in HSQL LOG when saving the Gruppe width allready existing Rollen
#
############################################################################
INSERT INTO GRUPPEN VALUES(3,'SYSADMIN',NULL,NULL)
DELETE FROM ROLLEN WHERE OBJ_ID=1
INSERT INTO ROLLEN VALUES(1,'BENUTZERVERW',NULL)
DELETE FROM ROLLEN WHERE OBJ_ID=2
INSERT INTO ROLLEN VALUES(2,'VWARTEN',NULL)
DELETE FROM ROLLEN WHERE OBJ_ID=3
INSERT INTO ROLLEN VALUES(3,'TSTAVERW',NULL)
DELETE FROM ROLLEN WHERE OBJ_ID=4
INSERT INTO ROLLEN VALUES(4,'EINSVERW',NULL)
DELETE FROM ROLLEN WHERE OBJ_ID=5
INSERT INTO ROLLEN VALUES(5,'TEILELOESCH',NULL)
DELETE FROM ROLLEN WHERE OBJ_ID=6
INSERT INTO ROLLEN VALUES(6,'PROJVERW',NULL)
DELETE FROM ROLLEN WHERE OBJ_ID=7
INSERT INTO ROLLEN VALUES(7,'KONTRKM',NULL)
DELETE FROM ROLLEN WHERE OBJ_ID=8
INSERT INTO ROLLEN VALUES(8,'KONTRRHTH',NULL)
DELETE FROM ROLLEN WHERE OBJ_ID=9
INSERT INTO ROLLEN VALUES(9,'VERWAEND',NULL)
INSERT INTO ROLLEN VALUES(10,'VERWLOESCH',NULL)
---
INSERT INTO GRUPPEN_ROLLEN VALUES(3,1)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,2)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,3)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,4)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,5)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,6)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,7)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,8)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,9)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,10)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,11)
INSERT INTO GRUPPEN_ROLLEN VALUES(3,12)
What is OJB doing in the first part of the log (DELETE, INSERT...)? Is
there
a problem in my repository.xml?
Thanks a lot for your help!
Josef
-----Ursprüngliche Nachricht-----
Von: Josef Wagner [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 10. Mai 2006 08:49
An: 'OJB Users List'
Betreff: AW: OJB do delete and insert instead of update
Hi Armin,
I'm working with OJB 1.0.3.
Sorry, I have debugged again and see that m-n-handling is ok.
Delete and insert instead of updating takes only affect by updating the
primitive attributes of an object, not in the m-n relation tables.
regards
Josef
Hi Josef,
Josef Wagner wrote:
Hello list,
why does ojb delete and insert when I'm updating an existing entry?
Isn't this way negative in view of performance?
I've seen this concept also by updating m-n relations.
Which version of OJB do you use?
Beside the update of m-n relations when does OJB "delete and insert"
instead of a simply update? Could you describe more detailed?
regards,
Armin
Thanks for your answers
Josef Wagner, Germany
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
