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
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 |