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

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