Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 3509 invoked from network); 3 Aug 2007 23:00:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Aug 2007 23:00:13 -0000 Received: (qmail 94635 invoked by uid 500); 3 Aug 2007 23:00:11 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 94610 invoked by uid 500); 3 Aug 2007 23:00:11 -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 94599 invoked by uid 99); 3 Aug 2007 23:00:11 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Aug 2007 16:00:11 -0700 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 david.vancouvering@gmail.com designates 209.85.146.180 as permitted sender) Received: from [209.85.146.180] (HELO wa-out-1112.google.com) (209.85.146.180) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Aug 2007 23:00:06 +0000 Received: by wa-out-1112.google.com with SMTP id k40so1193749wah for ; Fri, 03 Aug 2007 15:59:46 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=uNg3nnA/zAWFpIwetpL3xUClnsr0e7ZoIUmn/MIjBpRxyNnXvQI04dyIxRAQLFv0iRxG7SBw98Mt6T7dL/0hQ3BG6QfgEjK9E+/Q9/M5jmm94c6o0AK+FIofeTSz8dzY8C7Nst6ZgwqVTQc5e4MbcUykFn73gCkTLMWPy1YXAZE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=iQQRQ/dRZbn1ewQE468leqc5uEiEK+KzvB9kQb/m/yJBBU5jZXKqxkfc8p0xhWYSHGhtxHFmvAhrUJIbWhq5UNpVKr8FhGmlvSz/ns7FI7+4uZCuzqrXSK7Fv+04QNr83Yy0cgSsv8IK7T+Am0/17yJQxbRh+4boxreY+Kf/tE8= Received: by 10.114.151.13 with SMTP id y13mr3438206wad.1186181985727; Fri, 03 Aug 2007 15:59:45 -0700 (PDT) Received: by 10.114.120.13 with HTTP; Fri, 3 Aug 2007 15:59:45 -0700 (PDT) Message-ID: <56a83cd00708031559ye6df744pb5bc1a9ef2421727@mail.gmail.com> Date: Fri, 3 Aug 2007 15:59:45 -0700 From: "David Van Couvering" Sender: david.vancouvering@gmail.com To: "Derby Discussion" Subject: Re: DatabaseMetaData.getSearchStringEscape() returns "" In-Reply-To: <79373.79083.qm@web31804.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <79373.79083.qm@web31804.mail.mud.yahoo.com> X-Google-Sender-Auth: a54d27d1fe05dd0b X-Virus-Checked: Checked by ClamAV on apache.org You might try getIdentifierQuoteString() David On 8/3/07, Geoff hendrey wrote: > I need to call DatabaseMetaData.searchStringEscape to determine the escape sequence, but it just returns "". I cneed call DatabasMetaData.getColumns on a table whose name contains an underscore., which is why I need the escape string, Ssince underscore is a reserved search character. > > If there is another way to escape underscore, please let me know. > > -geoff > > >