agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

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

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

view thread (6+ messages)  latest in thread

Message-ID: <425D98A2.5030206@mailblocks.com>
Permalink:  ../425D98A2.5030206@mailblocks.com/
Also on:    postgresql.org/message-id/425D98A2.5030206@mailblocks.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Error message java.lang.ClassNotFoundException: 'pljavatriggers.TestTrigger1'
  In-Reply-To: <425D98A2.5030206@mailblocks.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox