You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Jim McNamara <3r...@verizon.net> on 2006/10/04 21:56:55 UTC
re: function classpath not found (cause?)
hi-
I just received my derby text book an hour ago. I was playing around
with the echo commands it had for windows dos and noticed that even
though I had set an environment variable for my eclipse directory (I
followed same procedure laid out in the book for the demo application
that comes with derby) in the CLASSPATH when I do an echo it skips over
that entry. I suspect if I can figure out why in the world it would do
that I may fix the problem.
this makes me angry. i can screw up enough on my own without this.
I have to go to work now. my hobby will have to wait a bit.
if anyone knows why, please help.
thanks - jim
screen prints -
values in my environment variable
c:\derby\lib\derbyclient.jar;c:\derby\lib\derbytools.jar;c:\derby\framew
orks\NetworkServer\bin;c:\eclipse\workspace\budgetcalc\bcalc2;c:\swtjasp
erviewer-1.0.3\swtjasperviewer-1.0.3.jar;
console window showing an echo -
C:\jadeCheckBook>echo
c:\derby\lib\derbyclient.jar;c:\derby\lib\derbytools.jar;c
:\derby\frameworks\NetworkServer\bin;c:\swtjasperviewer-1.0.3\swtjasperv
iewer-1.
0.3.jar;
c:\derby\lib\derbyclient.jar;c:\derby\lib\derbytools.jar;c:\derby\framew
orks\Net
workServer\bin;c:\swtjasperviewer-1.0.3\swtjasperviewer-1.0.3.jar;
batch file echo command -
echo %CLASSPATH%
RE: function classpath not found (cause?)
Posted by Jim McNamara <3r...@verizon.net>.
Hi Daniel-
That solved the problem of the echoing CLASSPATH. If I use start run
cmd I have no problem. If I use a batch file it acts kooky.
The bigger problem still remains though. Even with using start run cmd
and the appropriate directory listed I still get the error as shown
below.
That makes me feel a little better even though I still haven't solved
the main problem.
Thanks very much for your help.
jim
<using start run cmd>
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\HP_Owner>echo %CLASSPATH%
c:\derby\lib\derbyclient.jar;c:\derby\lib\derbytools.jar;c:\derby\framew
orks\Net
workServer\bin;c:\eclipse\workspace\budgetcalc\bcalc2;c:\swtjasperviewer
-1.0.3\s
wtjasperviewer-1.0.3.jar;
C:\Documents and Settings\HP_Owner>cd
c:\derby\frameworks\NetworkServer\bin
C:\derby\frameworks\NetworkServer\bin>java org.apache.derby.tools.ij
ij version 10.1
ij> connect 'jdbc:derby://localhost:1527/c:/derby/lib/myDB; create
=false; user=
user1; password=user1';
ij> connect 'jdbc:derby://localhost:1527/c:/derby/lib/myDB; create
=false; user=
user1; password=user1';
ij> values myInc(5,10);
ERROR 42X51: The class 'MyMathFuncs' does not exist or is inaccessible.
This can
happen if the class is not public. SQLSTATE: XJ001: Java exception:
'MyMathFunc
s: java.lang.ClassNotFoundException'.
ij>
-----Original Message-----
From: Daniel Jue [mailto:teamphy6@gmail.com]
Sent: Wednesday, October 04, 2006 4:05 PM
To: Derby Discussion
Subject: Re: function classpath not found (cause?)
This is just a shot in the dark, I don't know if this is the problem:
On windows, when you update an environment variable from the GUI, any
open CMD windows will not get the update. You have to open a new cmd
or command instance to get the changes. I guess a local copy of the
path variable (and possibly all environment vars) gets pulled into the
cmd instance, and it doesn't check the system for updates.
I don't think this applies if you are setting the environment var from
the cmd window itself, although other instances probably won't get the
change.
Just trying to help,
Dan
On 10/4/06, Jim McNamara <3r...@verizon.net> wrote:
>
>
>
> hi-
>
>
>
> I just received my derby text book an hour ago. I was playing around
with
> the echo commands it had for windows dos and noticed that even though
I had
> set an environment variable for my eclipse directory (I followed same
> procedure laid out in the book for the demo application that comes
with
> derby) in the CLASSPATH when I do an echo it skips over that entry. I
> suspect if I can figure out why in the world it would do that I may
fix the
> problem.
>
>
>
> this makes me angry. i can screw up enough on my own without this.
>
>
>
> I have to go to work now. my hobby will have to wait a bit.
>
> if anyone knows why, please help.
>
> thanks - jim
>
>
>
> screen prints -
>
>
>
> values in my environment variable
>
>
c:\derby\lib\derbyclient.jar;c:\derby\lib\derbytools.jar;c:\derby\framew
orks\NetworkServer\bin;c:\eclipse\workspace\budgetcalc\bcalc2;c:\swtjasp
erviewer-1.0.3\swtjasperviewer-1.0.3.jar;
>
>
>
> console window showing an echo -
>
> C:\jadeCheckBook>echo
> c:\derby\lib\derbyclient.jar;c:\derby\lib\derbytools.jar;c
>
>
:\derby\frameworks\NetworkServer\bin;c:\swtjasperviewer-1.0.3\swtjasperv
iewer-1.
>
> 0.3.jar;
>
>
c:\derby\lib\derbyclient.jar;c:\derby\lib\derbytools.jar;c:\derby\framew
orks\Net
>
> workServer\bin;c:\swtjasperviewer-1.0.3\swtjasperviewer-1.0.3.jar;
>
>
>
> batch file echo command -
>
> echo %CLASSPATH%
Re: function classpath not found (cause?)
Posted by Daniel Jue <te...@gmail.com>.
This is just a shot in the dark, I don't know if this is the problem:
On windows, when you update an environment variable from the GUI, any
open CMD windows will not get the update. You have to open a new cmd
or command instance to get the changes. I guess a local copy of the
path variable (and possibly all environment vars) gets pulled into the
cmd instance, and it doesn't check the system for updates.
I don't think this applies if you are setting the environment var from
the cmd window itself, although other instances probably won't get the
change.
Just trying to help,
Dan
On 10/4/06, Jim McNamara <3r...@verizon.net> wrote:
>
>
>
> hi-
>
>
>
> I just received my derby text book an hour ago. I was playing around with
> the echo commands it had for windows dos and noticed that even though I had
> set an environment variable for my eclipse directory (I followed same
> procedure laid out in the book for the demo application that comes with
> derby) in the CLASSPATH when I do an echo it skips over that entry. I
> suspect if I can figure out why in the world it would do that I may fix the
> problem.
>
>
>
> this makes me angry. i can screw up enough on my own without this.
>
>
>
> I have to go to work now. my hobby will have to wait a bit.
>
> if anyone knows why, please help.
>
> thanks - jim
>
>
>
> screen prints –
>
>
>
> values in my environment variable
>
> c:\derby\lib\derbyclient.jar;c:\derby\lib\derbytools.jar;c:\derby\frameworks\NetworkServer\bin;c:\eclipse\workspace\budgetcalc\bcalc2;c:\swtjasperviewer-1.0.3\swtjasperviewer-1.0.3.jar;
>
>
>
> console window showing an echo –
>
> C:\jadeCheckBook>echo
> c:\derby\lib\derbyclient.jar;c:\derby\lib\derbytools.jar;c
>
> :\derby\frameworks\NetworkServer\bin;c:\swtjasperviewer-1.0.3\swtjasperviewer-1.
>
> 0.3.jar;
>
> c:\derby\lib\derbyclient.jar;c:\derby\lib\derbytools.jar;c:\derby\frameworks\Net
>
> workServer\bin;c:\swtjasperviewer-1.0.3\swtjasperviewer-1.0.3.jar;
>
>
>
> batch file echo command –
>
> echo %CLASSPATH%