Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <4AE431A2.2070205@wanadoo.fr>
Date: Sun, 25 Oct 2009 12:08:18 +0100
From: Sylvain Leroux <sl20@wanadoo.fr>
Organization: http://www.chicoree.fr
User-Agent: Thunderbird 2.0.0.23 (Macintosh/20090812)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: ERROR 42X51 class not found
References: <loom.20091024T161532-309@post.gmane.org>
 <4AE31584.70700@amberpoint.com> <loom.20091024T171750-356@post.gmane.org>
 <4AE31EA9.2070001@amberpoint.com> <loom.20091024T182858-987@post.gmane.org>
 <4AE33C18.5050808@apache.org> <loom.20091024T225854-916@post.gmane.org>
In-Reply-To: <loom.20091024T225854-916@post.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

I noticed that you run all your manual tests as root on your unix box (prompt 
sh#). Will the Derby server run under that identity too?

That lets me suspect perhaps a problem with the permissions on your files/folders.

That's a little bit doubtful, since usually /var/lib is readable and traversable 
by everyone. Anyway, as we are in an impasse here,  worth trying to check those 
permissions (ls -l - look for rx on directories and r on files). Then try to run 
the following command on a shell, with CLASSPATH correctly set, and /under the 
identity used by Derby/:
  derby$  java derbyPk.Functions
                         ^^^^^^^^ (/class/ name here!)

If you get "NoSuchMethod: main" the files are readable. So this is definitively 
a Derby problem.
On the other hand, if you still get ClassNotFound exception, check again the 
permissions. If you packaged your files as a JAR, search for a problem with it 
on your server (something wrong while building/copying the JAR?). "jar tvf" 
could give more informations.


On that matters, (should I have put that first ;)? ), I noticed that your class 
path is:
   /var/lib/derby/db-derby-10.5.3.0-bin/lib/
But if you packaged your files as a JAR on your server, shouldn't it be:
   /var/lib/derby/db-derby-10.5.3.0-bin/lib/myjar.jar
                                              ^^^^^^^^^


Nothing really convincing here. I agree. But it should help narrowing the 
problem. Somehow...

Sylvain.


Thomas Hill a �crit :
> derby.Functions is a class and TF_Clients_AI2 a method.
> 
> the java code reads:
> 
> package derbyPk;
> 
> public class Functions {
>    public static void TF_Clients_AI2(int iRowID, String vcClientID, String
> vcClientName) throws SQLException
>    {
>    ...
>    }
> }
> 
> As said all of this worked fine when running the derby Networkserver on
> localhost and with the java code stored in the filesystem on localhost.
> 
> Thanks
> 
> 
> 


-- 
Website: http://www.chicoree.fr