From: thhal at mailblocks.com (Thomas Hallgren) Date: Tue, 30 Nov 2004 10:42:47 +0100 Subject: [Pljava-dev] Re: worked In-Reply-To: <5F4ED4205E00D6119BFE009027DE39090793EF96@MLSW00103> References: <5F4ED4205E00D6119BFE009027DE39090793EF96@MLSW00103> <41AC4097.3090503@mailblocks.com> Message-ID: Rao, >ERROR: Unable to find static method com.test.HelloWorld.getName with >signature (Lorg/postgresql/pljava/TriggerData;)V > > >The function is working fine if I execute as ordinary function ,I mean >without trigger. >Create function tgfun() returns varchar as 'com.test.HelloWorld.getName' >language java; > > PL/Java requires that all trigger functions take a org.postgresql.pljava.TriggerData argument. So your method must look something like this: public static void getName(TriggerData td) { } Regards, Thomas Hallgren