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:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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%
