Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 91169 invoked from network); 27 Apr 2006 03:03:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 27 Apr 2006 03:03:14 -0000 Received: (qmail 90395 invoked by uid 500); 27 Apr 2006 03:03:14 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 90363 invoked by uid 500); 27 Apr 2006 03:03:13 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 90352 invoked by uid 99); 27 Apr 2006 03:03:13 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Apr 2006 20:03:13 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Apr 2006 20:03:13 -0700 Received: from ajax.apache.org (localhost.localdomain [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 38F0BD49FE for ; Thu, 27 Apr 2006 04:02:52 +0100 (BST) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: derby-commits@db.apache.org Date: Thu, 27 Apr 2006 03:02:52 -0000 Message-ID: <20060427030252.3776.22096@ajax.apache.org> Subject: [Db-derby Wiki] Update of "TriggerImplementation" by DanDebrunner X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The following page has been changed by DanDebrunner: http://wiki.apache.org/db-derby/TriggerImplementation ------------------------------------------------------------------------------ === Possible Changes === * Re-write triggers to not add the indirection through JDBC !ResultSet. Have old/new references in action statements compile to specific !QueryTree nodes that access the data directly from a Derby language !ResultSet. Would need to investigate how to handle existing triggers at upgrade time. * Continue with JDBC approach and add code as required to fix issues, e.g. a internal specific !findColumn implementation that doesn't match JDBC but instead matches column on absolute name. Might still require a wrapper JDBC object. + * Use column position rather than column name to fetch a column value for a row trigger.