Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 43658 invoked from network); 30 May 2005 16:22:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 May 2005 16:22:15 -0000 Received: (qmail 85645 invoked by uid 500); 30 May 2005 16:22:14 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 85610 invoked by uid 500); 30 May 2005 16:22:13 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 85592 invoked by uid 99); 30 May 2005 16:22:13 -0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of jta@bristowhill.com designates 66.75.162.133 as permitted sender) Received: from ms-smtp-01-qfe0.socal.rr.com (HELO ms-smtp-01-eri0.socal.rr.com) (66.75.162.133) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 30 May 2005 09:22:12 -0700 Received: from [192.168.15.53] (cpe-204-210-23-212.san.res.rr.com [204.210.23.212]) by ms-smtp-01-eri0.socal.rr.com (8.12.10/8.12.7) with ESMTP id j4UGM7Ff005518 for ; Mon, 30 May 2005 09:22:08 -0700 (PDT) Message-ID: <429B3DAF.5070405@bristowhill.com> Date: Mon, 30 May 2005 09:22:07 -0700 From: "Jean T. Anderson" User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: Using triggers and procedures? References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N A trigger can't call a procedure, but it can call a user-defined sql function. Could you provide a few more specifics about what your method needs to do? -jean Peter Nabbefeld wrote: > > Hello, > > I want a procedure to be called when a record is added or deleted. > However, Derby doesn't support it, and will not in 10.1 (aacording to > the manual). > > 1. Is there a workaround for this? I want to call some static Java method. > > 2. When will that be supported? > > Kind regards > > Peter Nabbefeld >