Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 86191 invoked from network); 31 May 2005 05:50:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 31 May 2005 05:50:20 -0000 Received: (qmail 7459 invoked by uid 500); 31 May 2005 05:50:19 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 7430 invoked by uid 500); 31 May 2005 05:50:18 -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 7412 invoked by uid 99); 31 May 2005 05:50:18 -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 gcaddu-derby-user@m.gmane.org designates 80.91.229.2 as permitted sender) Received: from main.gmane.org (HELO ciao.gmane.org) (80.91.229.2) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 30 May 2005 22:50:16 -0700 Received: from list by ciao.gmane.org with local (Exim 4.43) id 1Dczak-0007sS-E5 for derby-user@db.apache.org; Tue, 31 May 2005 07:47:06 +0200 Received: from td9091c54.pool.terralink.de ([217.9.28.84]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 31 May 2005 07:47:06 +0200 Received: from Peter.Nabbefeld by td9091c54.pool.terralink.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 31 May 2005 07:47:06 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: derby-user@db.apache.org From: Peter Nabbefeld Subject: Re: Using triggers and procedures? Date: Tue, 31 May 2005 07:58:34 +0200 Lines: 43 Message-ID: References: <429B3DAF.5070405@bristowhill.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: td9091c54.pool.terralink.de User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.7.3) Gecko/20040910 X-Accept-Language: de, en In-Reply-To: <429B3DAF.5070405@bristowhill.com> Sender: news X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Jean T. Anderson schrieb: > 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? > I just want to give a feedback to my app, if the number of records in the database has changed (independently if I use the embedded db or not). I've now created a function using CREATE FUNCTION APPBUT_USER.TRIGGER_RESIZE(SCHEMA_NAME VARCHAR(255), TABLE_NAME VARCHAR(255)) RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA EXTERNAL NAME 'myFunc' How can I use this function in a trigger? I'm always getting syntax errors. Kind regards Peter Nabbefeld > -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 >> > >