From torque-user-return-4160-apmail-db-torque-user-archive=db.apache.org@db.apache.org Wed Feb 11 17:06:51 2004 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 94568 invoked from network); 11 Feb 2004 17:06:51 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 11 Feb 2004 17:06:51 -0000 Received: (qmail 69999 invoked by uid 500); 11 Feb 2004 17:06:18 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 69962 invoked by uid 500); 11 Feb 2004 17:06:18 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 69894 invoked from network); 11 Feb 2004 17:06:17 -0000 Received: from unknown (HELO msx.drei.com) (213.94.78.66) by daedalus.apache.org with SMTP; 11 Feb 2004 17:06:17 -0000 Received: from msx.drei.com ([10.249.20.17]) by msx.drei.com with Microsoft SMTPSVC(5.0.2195.6713); Wed, 11 Feb 2004 18:06:19 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: RE: doDelete(Businessobject) doesn't delete the record from the database Date: Wed, 11 Feb 2004 18:06:19 +0100 Message-ID: <90B3A0967470D44CB8FDE74907512328F1B9E4@av1s008.at-work.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: doDelete(Businessobject) doesn't delete the record from the database Thread-Index: AcPwv0lX+IPn4MgCREmNhaM/ZtzzxQAAYFiA From: =?iso-8859-1?Q?=22G=F6schl=2CSiegfried=22?= To: "Apache Torque Users List" X-OriginalArrivalTime: 11 Feb 2004 17:06:19.0693 (UTC) FILETIME=[5E3D35D0:01C3F0C1] 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 Hi Adrian, I came along the same problem with an record having DATE and/or TIMESTAP = with Oracle9i.=20 +) There is an issue with village and Oracle9i - the hh:mm:ss are = truncated +) when you delete doDelete(BOinstance) Torque creates a WHERE clause = with all fields where the timestamps might not match Solution is to doDelete() with the primary key - this is much more = efficient anyway Cheers, Siegfried Goeschl -----Original Message----- From: Tillich, Adrian [mailto:Adrian.Tillich@tui.de] Sent: Wednesday, February 11, 2004 5:50 PM To: 'Apache Torque Users List' Subject: doDelete(Businessobject) doesn't delete the record from the database Hi Folks, I've just realized that Torque simply doesn't always delete records when = I call something like BusinessobjectPeer.doDelete(BOinstance); What I basically do is=20 * create a new record, save it,=20 * then reuse the same instance to do some changes (and save them to the = DB of course), * and afterwards I delete the object (still reusing the same instance). Is there a problem, reusing the object? I'm a bit surprised because the update always works and I don't know how = to fix the problem. Hope someone can help me. Greetings, Adrian --------------------------------------------------------------------- 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