Return-Path: <michael@popfrontal.de>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 73485 invoked from network); 29 May 2003 22:21:38 -0000
Received: from moutng.kundenserver.de (212.227.126.185)
  by daedalus.apache.org with SMTP; 29 May 2003 22:21:38 -0000
Received: from [212.227.126.161] (helo=mrelayng.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 19LVmK-0002GP-00
	for torque-user@db.apache.org; Fri, 30 May 2003 00:21:44 +0200
Received: from [217.230.201.147] (helo=yomama)
	by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
	id 19LVmK-0000q6-00
	for torque-user@db.apache.org; Fri, 30 May 2003 00:21:44 +0200
Message-ID: <005401c32639$c05652e0$93c9e6d9@yomama>
From: "Michael Schmitt" <michael@popfrontal.de>
To: <torque-user@db.apache.org>
Subject: Is there any notification mechanism when deleting objects
Date: Fri, 30 May 2003 00:26:37 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hello,
I have aproblem when deleting objects that are referenced by other objects.
My schema looks something like that:

<table name="band">
    <column name="id" required="true" type="INTEGER" primaryKey="true"/>
    <column name="name" required="true" type="VARCHAR" size="255" />
    ...
</table>

<table name="concert">
    <column name="id" required="true" type="INTEGER" primaryKey="true"/>
    <column name="band_id" required="true" type="INTEGER"/>
    ...
    <foreign-key foreignTable="band">
      <reference local="band_id" foreign="id"/>
    </foreign-key>
</table>


Somewhere in my sourcecode I have the following lines:

(1)  Band band = BandPeer.retrieveByPK(123);

This statement is only executed once. The returned Band object will be
kept in memory. In another place I use this object from time to time in
the following way:

(2)  List concerts = band.getConcerts();

Somewhere else (where I don't know anything about the reference) I do the 
following:

(3)  Concert concert = ConcertPeer.retrieveByPK(456);
     ConcertPeer.doDelete(concert);

If thereafter (2) is called again, the deleted Concert object is still 
in the returned list.


Is there any notification mechanism that tells the Band object that it 
should update its concert-list, or at least tells it that it should 
reread the list from the database?


bye,
michael