Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 10963 invoked from network); 1 Jun 2005 12:07:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Jun 2005 12:07:05 -0000 Received: (qmail 47400 invoked by uid 500); 1 Jun 2005 12:07:00 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 47367 invoked by uid 500); 1 Jun 2005 12:07:00 -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 47322 invoked by uid 99); 1 Jun 2005 12:06:59 -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; Wed, 01 Jun 2005 05:06:57 -0700 Received: from list by ciao.gmane.org with local (Exim 4.43) id 1DdRuI-0004lF-7K for derby-user@db.apache.org; Wed, 01 Jun 2005 14:01:10 +0200 Received: from td9091dd3.pool.terralink.de ([217.9.29.211]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 01 Jun 2005 14:01:10 +0200 Received: from Peter.Nabbefeld by td9091dd3.pool.terralink.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 01 Jun 2005 14:01:10 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: derby-user@db.apache.org From: Peter Nabbefeld Subject: Re: Using triggers and procedures? Date: Wed, 01 Jun 2005 14:11:44 +0200 Lines: 88 Message-ID: References: <20050531142021.95933.qmail@web30608.mail.mud.yahoo.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: td9091dd3.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: <20050531142021.95933.qmail@web30608.mail.mud.yahoo.com> Sender: news X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Suavi Ali Demir schrieb: > You may need to use it in a values clause in the > trigger body: > > VALUES(APPBUT_USER.TRIGGER_RESIZE(schema,table)) > CREATE TRIGGER ... FOR EACH STATEMENT VALUES(...) doesn't work. Will I really have to insert a dummy value into some dummy table to call a procedure or function from a trigger? Regards Peter > Regards, > Ali > > --- Peter Nabbefeld wrote: > >>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 >>>> >>> >>> >> >