From torque-dev-return-4056-apmail-db-torque-dev-archive=db.apache.org@db.apache.org Thu Apr 01 15:10:11 2004 Return-Path: Delivered-To: apmail-db-torque-dev-archive@www.apache.org Received: (qmail 62027 invoked from network); 1 Apr 2004 15:10:11 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 1 Apr 2004 15:10:11 -0000 Received: (qmail 50355 invoked by uid 500); 1 Apr 2004 15:10:06 -0000 Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 50337 invoked by uid 500); 1 Apr 2004 15:10:05 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 50321 invoked from network); 1 Apr 2004 15:10:05 -0000 Received: from unknown (HELO mail.ilk.de) (194.121.104.8) by daedalus.apache.org with SMTP; 1 Apr 2004 15:10:05 -0000 Received: from scuderia03.VPS.DE (mail.vps.de [212.86.208.21]) by mail.ilk.de with ESMTP id i31F9PO0004778 for ; Thu, 1 Apr 2004 17:09:25 +0200 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C417FB.6A9B33F0" Subject: lockTable Method X-MimeOLE: Produced By Microsoft Exchange V6.0.5762.3 Date: Thu, 1 Apr 2004 17:10:06 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: lockTable Method Thread-Index: AcQX+2rUkSUkfhbJT56prczquYuYQA== From: "Michael Beier" To: 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_001_01C417FB.6A9B33F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, There is a lockTable method in the DB-adapter classes (not in all, only = Oracle, Sapdb and Sybase seems to have used copy and paste, others dont = contain this method or implement it correctly (to make a correct lock = table statement)) , this contains a fixed statement "SELECT next_id = FROM". This can only work on the ID_table, because only there is a = column next_id. This should be "SELECT * FROM" (at least in Oracle and Sybase(respective = MSSQL)) to work for all tables. Can someone confirm this and maybe correct it ? Or is it so by design?(Why?) Michael Beier mbeier@vps.de ------_=_NextPart_001_01C417FB.6A9B33F0--