Hi Chris,
It is a general rule (not a derby rule)
that your classpath should have the jars which contain your classes (or)
the directory that contain your classes
In this case you had to have the jar called derbyclient.jar that
contains the
class (the client driver org.apache.derby.jdbc.ClientDriver) that is needed
to connect to your Derby Network Server.
Glad that it worked :)
Pls feel free to ask any doubts you have along the way, would be a pleasure
to answer
cheers,
Narayanan
Chris wrote:
That doesn't make any sense to me, but it worked. I thought it just
meant the directory when it said "the location of the file".
Thanks!
On Tue, Mar 11, 2008 at 2:34 AM, Narayanan <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Chris wrote:
> On 3/10/08, *Narayanan* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
> <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote:
>
> you are basically trying to run derby in the client/server
mode of
> operation.
>
> You need to have derbyclient.jar in your classpath.
>
> You also need to start the derby network server
>
> You can find instructions on starting the derby network
server here
>
>
http://db.apache.org/derby/docs/dev/adminguide/tadmincbdjhhfd.html
>
>
> Narayanan
>
>
> Sorry, I didn't start from the beginning last time... (DERBY_HOME =
> C:\wamp\derby)
>
> java -jar %DERBY_HOME%\lib\derbyrun.jar server start
> Security manager installed using the Basic server security policy.
> Apache Derby Network Server - 10.3.2.1 <http://10.3.2.1>
<http://10.3.2.1> - (599110)
> started and ready to accept connections on port 1527 at 2008-03-10
> 20:00:20.343 GMT
>
> echo %CLASSPATH%
> .;C:\Program
>
Files\Java\jre1.6.0_01\lib\ext\QTJava.zip;C:\wamp\derby\lib;C:\wamp\derby\bin;C:\Program
> Files\Java\jdk1.6.0_03\bin
>
> echo %PATH%
> *** too long, the important part is: C:\wamp\derby\bin; ***
>
> java WwdClient
>
> >>> Please check your CLASSPATH variable <<<
>
> . . . exception thrown:
>
> ---SQLException Caught---
>
> SQLState: 08001
> Severity: 0
> Message: No suitable driver found for
> jdbc:derby://localhost:1527/jdbcDemoDB;create=true
> Getting Started With Derby JDBC program ending.
You have C:\wamp\derby\lib in your classpath. I think you need to have
C:\wamp\derby\lib\derbyclient.jar.
Narayanan
--
In ALL things, strive for ><>,
Chris
