Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 3850 invoked from network); 4 Dec 2008 21:44:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Dec 2008 21:44:48 -0000 Received: (qmail 91521 invoked by uid 500); 4 Dec 2008 21:44:55 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 91498 invoked by uid 500); 4 Dec 2008 21:44: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 91484 invoked by uid 99); 4 Dec 2008 21:44:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Dec 2008 13:44:55 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of manu@frogthinker.org designates 66.147.243.8 as permitted sender) Received: from [66.147.243.8] (HELO outboundproxy8.bluehost.com) (66.147.243.8) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 04 Dec 2008 21:43:25 +0000 Received: (qmail 26530 invoked by uid 0); 4 Dec 2008 21:42:50 -0000 Received: from unknown (HELO fast22.fastdomain.com) (74.220.199.22) by outboundproxy7.bluehost.com.bluehost.com with SMTP; 4 Dec 2008 21:42:50 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=frogthinker.org; h=Received:Message-ID:Date:From:Organization:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding:X-Identified-User; b=rGotns8h2N1gpVWUHOZBkxESyPAmYKAqSYs1tH8Zm15UdD9b8P35jDj3erWlzQu8YU0KjK6kjiJSXA70sZqwlpnovNg0WhyIXozxBp2ScLnc7zFHJCEwt/jBV1KC28GH; Received: from c-71-192-35-139.hsd1.ma.comcast.net ([71.192.35.139] helo=[192.168.0.14]) by fast22.fastdomain.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1L8LyY-0006Gi-3B for derby-user@db.apache.org; Thu, 04 Dec 2008 14:43:10 -0700 Message-ID: <49384EF0.7060304@frogthinker.org> Date: Thu, 04 Dec 2008 16:43:12 -0500 From: Emmanuel Cecchet Organization: Frog Thinker User-Agent: Thunderbird 2.0.0.18 (Windows/20081105) MIME-Version: 1.0 To: Derby Discussion Subject: Re: Tomcat derby JSP "java.sql.SQLException: No suitable driver" References: <738B94ED-B6DC-40F8-8754-2D4EC77A3724@gmail.com> <493422BD.2030804@frogthinker.org> <20840073.post@talk.nabble.com> In-Reply-To: <20840073.post@talk.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Identified-User: {2846:fast22.fastdomain.com:frogthin:frogthinker.org} {sentby:smtp auth 71.192.35.139 authed with manu+frogthinker.org} X-Virus-Checked: Checked by ClamAV on apache.org Mike, > Thanks for your reply. I have tried using derby.jar instead of > derbyclient.jar and the result is exactly the same. Is there any more advice > you can give me? > This is certainly a classpath issue. Be careful with classloader inheritance in Tomcat. Where did you copy derby.jar? What version of Tomcat are you using? Emmanuel > > > > > > > > > > > > > > Emmanuel Cecchet-5 wrote: > >> Michael, >> >> You should have derby.jar in the classpath if you want to use embedded >> mode. >> >>> CLASSPATH=\ >>> Applications/apache-tomcat-6.0.18/lib/derbyclient.jar:\ >>> >> derbyclient.jar contains only the JDBC driver code >> (http://db.apache.org/derby/docs/dev/adminguide/tadminappschangingyourclasspath.html) >> >>> <% >>> String driver = "org.apache.derby.jdbc.EmbeddedDriver"; >>> >> Hope this helps, >> Emmanuel >> >> -- >> Emmanuel Cecchet >> FTO @ Frog Thinker >> Open Source Development & Consulting >> -- >> Web: http://www.frogthinker.org >> email: manu@frogthinker.org >> Skype: emmanuel_cecchet >> >> >> >> > > -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: manu@frogthinker.org Skype: emmanuel_cecchet