[Pljava-dev] Error message java.lang.ClassNotFoundException: 'pljavatriggers.TestTrigger1'

From: mspan at di(dot)uoa(dot)gr (Manos Spanoudakis)
To:
Subject: [Pljava-dev] Error message java.lang.ClassNotFoundException: 'pljavatriggers.TestTrigger1'
Date: 2005-04-13 12:44:29
Message-ID: 000b01c54026$8be12450$0301a8c0@manos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Dear *,

I am trying to compose a Trigger using pljava and I am getting the error
message:
java.lang.ClassNotFoundException: 'pljavatriggers.TestTrigger1'

Here are the steps I followed:

1) I created the TestTrigger1.java (belongs to package pljavatriggers..)
file and created testtrigger.jar in the directory
d:\pljavatriggers.
2) Then I created the trigger function with the following code

CREATE OR REPLACE FUNCTION sqlj.testfunction()
RETURNS "trigger" AS
$BODY$ 'pljavatriggers.TestTrigger1.execCommandLine'$BODY$
LANGUAGE 'javau' VOLATILE;
ALTER FUNCTION sqlj.testfunction() OWNER TO xristis;
GRANT EXECUTE ON FUNCTION sqlj.testfunction() TO xristis;
GRANT EXECUTE ON FUNCTION sqlj.testfunction() TO public;

3) The trigger was created

CREATE TRIGGER test_trigger
AFTER INSERT OR UPDATE
ON sqlj."Doctor"
FOR EACH STATEMENT
EXECUTE PROCEDURE sqlj.testfunction();

4) The jar was installed and it was added to classpath... SELECT
sqlj.install_jar('file:D:\\pljavatriggers\\testtrigger.jar','testtrigger',tr
ue);
SELECT sqlj.set_classpath('sqlj','testtrigger');

With no error messages...

When I try to execute an SQL Update query I get the error message
java.lang.ClassNotFoundException: 'pljavatriggers.TestTrigger1' as mentioned
before

Can anyone tell me what I am missing ??

Thanx,
Manos

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Thomas Hallgren 2005-04-13 13:01:19 [Pljava-dev] Error message java.lang.ClassNotFoundException: 'pljavatriggers.TestTrigger1'
Previous Message Edson Luis Gonçalez 2005-04-07 01:38:07 [Pljava-dev] libpljava.dll