Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 37240 invoked from network); 10 Mar 2008 05:45:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 10 Mar 2008 05:45:59 -0000 Received: (qmail 83229 invoked by uid 500); 10 Mar 2008 05:45:55 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 83201 invoked by uid 500); 10 Mar 2008 05:45:55 -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 83190 invoked by uid 99); 10 Mar 2008 05:45:55 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Mar 2008 22:45:55 -0700 X-ASF-Spam-Status: No, hits=-1.0 required=10.0 tests=NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [192.18.19.7] (HELO sineb-mail-2.sun.com) (192.18.19.7) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Mar 2008 05:45:06 +0000 Received: from fe-apac-06.sun.com (fe-apac-06.sun.com [192.18.19.177] (may be forged)) by sineb-mail-2.sun.com (8.13.6+Sun/8.12.9) with ESMTP id m2A5jfIJ020592 for ; Mon, 10 Mar 2008 05:45:42 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 <0JXI007012GYGN00@mail-apac.sun.com> (original mail from V.Narayanan@Sun.COM) for derby-user@db.apache.org; Mon, 10 Mar 2008 13:45:23 +0800 (SGT) Received: from [129.158.228.180] by mail-apac.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JXI00B5S2N8MG7X@mail-apac.sun.com> for derby-user@db.apache.org; Mon, 10 Mar 2008 13:45:13 +0800 (SGT) Date: Mon, 10 Mar 2008 11:15:09 +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: <47D4CAE5.8020508@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT References: User-Agent: Thunderbird 2.0.0.6 (X11/20071022) X-Virus-Checked: Checked by ClamAV on apache.org Chris wrote: > As you may remember, I have a copy of Derby that came pre-installed > with ColdFusion 8 Developer's Edition. But I want to use Derby with > PHP, so I have installed the 10.3.2.1 binary > distribution and am progressing through /Getting Started with Derby/. > > When I run WwdClient in Activity 4 of the /Self-study tutorial for > users new to Derby/, I get the following error. (For completeness, > the output from running WwdEmbedded comes first.) > > java WwdEmbedded > > org.apache.derby.jdbc.EmbeddedDriver loaded. > Connected to database jdbcDemoDB > Enter wish-list item (enter exit to end): > > exit > Closed connection > Database shut down normally > Getting Started With Derby JDBC program ending. > > 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. > > > I got this error on Activity 3 (with WwdEmbedded), too, but resolved > it by modifying my CLASSPATH. Line 35 of WwdClient.java is: > > String driver = "org.apache.derby.jdbc.ClientDriver"; > > > Does anyone have an idea of what the problem might be? > > Thanks! > Chris 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