Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 28063 invoked from network); 15 Dec 2009 14:08:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 15 Dec 2009 14:08:53 -0000 Received: (qmail 83498 invoked by uid 500); 15 Dec 2009 14:08:52 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 83409 invoked by uid 500); 15 Dec 2009 14:08:51 -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 83401 invoked by uid 99); 15 Dec 2009 14:08:51 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Dec 2009 14:08:51 +0000 X-ASF-Spam-Status: No, hits=-4.0 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [192.18.43.133] (HELO sca-es-mail-2.sun.com) (192.18.43.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Dec 2009 14:08:41 +0000 Received: from fe-sfbay-10.sun.com ([192.18.43.129]) by sca-es-mail-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id nBFE8JsQ028298 for ; Tue, 15 Dec 2009 06:08:19 -0800 (PST) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII; format=flowed Received: from conversion-daemon.fe-sfbay-10.sun.com by fe-sfbay-10.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) id <0KUP00F005X0GW00@fe-sfbay-10.sun.com> for derby-user@db.apache.org; Tue, 15 Dec 2009 06:08:19 -0800 (PST) Received: from richard-hillegas-computer.local ([unknown] [129.150.241.84]) by fe-sfbay-10.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) with ESMTPSA id <0KUP00GBM5XRV8F0@fe-sfbay-10.sun.com> for derby-user@db.apache.org; Tue, 15 Dec 2009 06:08:15 -0800 (PST) Date: Tue, 15 Dec 2009 06:08:14 -0800 From: Rick Hillegas Subject: Re: SQLException Table does not exist although just created In-reply-to: <26795124.post@talk.nabble.com> Sender: Richard.Hillegas@Sun.COM To: Derby Discussion Message-id: <4B27984E.4010001@sun.com> References: <26780099.post@talk.nabble.com> <4B26D9FA.40202@sun.com> <26795124.post@talk.nabble.com> User-Agent: Thunderbird 2.0.0.23 (Macintosh/20090812) X-Virus-Checked: Checked by ClamAV on apache.org Hi Bill, You need to use double-quotes rather than single-quotes. See the following section in the Derby Reference Guide: http://db.apache.org/derby/docs/10.5/ref/ref-single.html#crefsqlj34834 Hope this helps, -Rick Wildman wrote: > Thanks, Rick -- that is indeed quite helpful. > > I am a bit unsure of how to specify the table name so that it retains > lower-case. If I quote the name when creating the table; e.g. "create table > 'part_type' ( .... )" then I get a SQL error complaining about the quotes. > Is there another way to specify a table name including casing? > > Thanks! > -Bill > >