From derby-user-return-8855-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Mar 12 00:44:53 2008 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 95853 invoked from network); 12 Mar 2008 00:44:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 12 Mar 2008 00:44:53 -0000 Received: (qmail 810 invoked by uid 500); 12 Mar 2008 00:44:49 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 786 invoked by uid 500); 12 Mar 2008 00:44:49 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 775 invoked by uid 99); 12 Mar 2008 00:44:49 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Mar 2008 17:44:49 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=NORMAL_HTTP_TO_IP,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.18.19.6] (HELO sineb-mail-1.sun.com) (192.18.19.6) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Mar 2008 00:44:10 +0000 Received: from fe-apac-06.sun.com (fe-apac-06.sun.com [192.18.19.177] (may be forged)) by sineb-mail-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id m2C0iNMX000587 for ; Wed, 12 Mar 2008 00:44:26 GMT Received: from conversion-daemon.mail-apac.sun.com by mail-apac.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0JXL00F01DXWAY00@mail-apac.sun.com> (original mail from V.Narayanan@Sun.COM) for derby-user@db.apache.org; Wed, 12 Mar 2008 08:44:14 +0800 (SGT) Received: from [192.168.1.2] ([122.167.18.248]) by mail-apac.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JXL00BH3E1KMH1G@mail-apac.sun.com> for derby-user@db.apache.org; Wed, 12 Mar 2008 08:44:14 +0800 (SGT) Date: Wed, 12 Mar 2008 06:14:10 +0530 From: Narayanan Subject: Re: Activity 4 Error: No suitable driver found... In-reply-to: Sender: V.Narayanan@Sun.COM To: Derby Discussion Message-id: <47D7275A.8040401@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT References: <47D4CAE5.8020508@sun.com> <47D63615.6050407@sun.com> User-Agent: Thunderbird 2.0.0.6 (X11/20071022) X-Virus-Checked: Checked by ClamAV on apache.org 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 > wrote: > > Chris wrote: > > On 3/10/08, *Narayanan* > > >> 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 > - (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