From: thhal at mailblocks.com (Thomas Hallgren)
Date: Thu, 14 Apr 2005 00:09:38 +0200
Subject: [Pljava-dev] Error message java.lang.ClassNotFoundException:
	'pljavatriggers.TestTrigger1'
In-Reply-To: <000401c5406f$f4cf48e0$0301a8c0@manos>
References: <000401c5406f$f4cf48e0$0301a8c0@manos>
Message-ID: <425D98A2.5030206@mailblocks.com>

Manos,
Take a look at your ClassNotFoundException once more. Do you see the 
leading single quote just before the name of the class? This qoute stems 
from the $body$ '...' $body$ that you're using. Essetially you get two 
single qoutes at the beginning and two at the end. PostgreSQL strips the 
outer quotes and delivers the rest to PL/Java as a method name. I 
suggest you remove the $body$ on both sides.

A couple of other suggestions.
- The CLASSPATH visible to the backend should *only* contain the 
pljava.jar. Alternatively it could be empty and instead set using 
pljava.classpath in postgresql.conf.
- Your execCommandLine(TriggerData) method must be static or PL/Java 
will fail to find it.
- Don't use the sqlj schema for user defined stuff. It should be 
regarded as reserved for PL/Java. The sqlj schema as a whole will be 
uninstalled if you redeploy pljava.

Regards,
Thomas Hallgren