Return-Path: 
 <torque-user-return-4512-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 2590 invoked from network); 25 Mar 2004 09:08:00 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 25 Mar 2004 09:08:00 -0000
Received: (qmail 92213 invoked by uid 500); 25 Mar 2004 09:07:44 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 92198 invoked by uid 500); 25 Mar 2004 09:07:44 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 92180 invoked from network); 25 Mar 2004 09:07:43 -0000
Received: from unknown (HELO zwei.siemens.at) (193.81.246.12)
  by daedalus.apache.org with SMTP; 25 Mar 2004 09:07:43 -0000
Received: from bavc001a.bav.siemens.ro (pix6-pri.frust.net [193.81.246.198]
 (may be forged))
	by zwei.siemens.at (8.12.9/8.12.8) with ESMTP id i2P8geK0001228
	for <torque-user@db.apache.org>; Thu, 25 Mar 2004 09:42:41 +0100
Received: from RO1CV02D ([163.242.239.126]) by bavc001a.bav.siemens.ro with
 SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13)
	id HS9RJV81; Thu, 25 Mar 2004 10:42:08 +0200
From: "Alexandru Dovlecel" <alexandru.dovlecel@siemens.com>
To: "'Apache Torque Users List'" <torque-user@db.apache.org>
Subject: RE: torque delete
Date: Thu, 25 Mar 2004 10:42:35 +0200
Message-ID: <000501c41245$1f76f6b0$7eeff2a3@ro1cv02d>
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_NextPart_000_0006_01C41255.E2FFC6B0"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.6604 (9.0.2911.0)
In-Reply-To: <90B3A0967470D44CB8FDE74907512328F1BA54@av1s008.at-work.local>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-MS-TNEF-Correlator: 000000008E5A1E5AD1B2A746B9D86ED1E464D835447F3D00
Importance: Normal
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

------=_NextPart_000_0006_01C41255.E2FFC6B0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Is it possible to use a criteria to delete the object? And, if possible, is
a bad solution? Is it working slowly? 

Thanks,
Alex 

> Hi Guo,
> 
> I'm not sure if the '*' in your XML schema should be there 
> but you have two options to delete. Either using the primary 
> key and or the whole object. Both options should work for you .
> 
> Cheers,
> 
> Siegfried Goeschl
> 
> -----Original Message-----
> From: Sheng Guo [mailto:sheng@in.tum.de]
> Sent: Wednesday, March 24, 2004 9:03 PM
> To: Apache Torque Users List
> Subject: Re: torque delete
> 
> 
> Hi,
> 
> This try failed,  I got the same error message:
> 
> org.apache.torque.TorqueException: You must specify KeyDef attributes 
> for this TableDataSet in order to delete a Record.
> 
> I added the code, which is bold, in the XML-Schema file:
> 
> <table name="sys_contact_category2sys_contact" 
> javaName="SYSContactCategory2SYSContact">
>         <column name="sys_contact_id" *primaryKey="true" 
> *required="true" type="BIGINT"/>
>         <column name="sys_contact_category_id"* primaryKey="true"* 
> required="true" type="INTEGER"/>
>         <foreign-key foreignTable="sys_contact">
>             <reference foreign="id" local="sys_contact_id"/>
>         </foreign-key>
>         <foreign-key foreignTable="sys_contact_category">
>             <reference foreign="id" local="sys_contact_category_id"/>
>         </foreign-key>
>     </table>
> 
> The peer classes were successfully created, but the problem was not 
> solved. Did I do anything wrong with the XML-Schema?
> 
> Thanks
> 
> Guo
> 
> 
> 
> Sheng Guo wrote:
> 
> > Hi,
> >
> > Thanks for this advice, actually the relation table doesn't 
> have any 
> > primary keys, it has only two foreign keys from the other 
> two tables. 
> > Now I am trying to fix the XML-Schema, so that the foreign 
> keys in the 
> > relation table are also primary keys. I don't know, if it 
> will work, 
> > but I'll try it, and let you know.
> >
> > Thanks a lot
> >
> > Guo
> >
> > Kostyantyn Shchekotykhin wrote:
> >
> >> Hi Sheng,
> >> KeyDef means primary key. It says to you that the primary 
> key of the 
> >> table was not found and Torque is unable to identify records to 
> >> delete. If you'll poste some details, i'll try to help you more.
> >>
> >> Regards,
> >> Kostya
> >>
> >> Sheng Guo wrote:
> >>
> >>> Hi,
> >>>
> >>> I am a new user of Torque, and I tried to delete some 
> records from a 
> >>> relation table ( which holds the n:m relation of the other two 
> >>> tables), but it failed,
> >>>
> >>> the exception said:
> >>>
> >>> org.apache.torque.TorqueException: You must specify KeyDef 
> >>> attributes for this TableDataSet in order to delete a Record.
> >>>
> >>> what does it mean, and how can I specify KeyDef attributes?
> >>>
> >>> Thanks
> >>>
> >>> Guo
> >>>
> >>>
> >>> 
> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >>> For additional commands, e-mail: torque-user-help@db.apache.org
> >>>
> >>
> >> 
> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >> For additional commands, e-mail: torque-user-help@db.apache.org
> >>
> >>
> >
> >
> >
> > 
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> >
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org


------=_NextPart_000_0006_01C41255.E2FFC6B0
Content-Type: text/plain; charset=us-ascii

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
------=_NextPart_000_0006_01C41255.E2FFC6B0--