Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 71273 invoked from network); 12 Nov 2009 12:03:30 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 12 Nov 2009 12:03:30 -0000 Received: (qmail 31663 invoked by uid 500); 12 Nov 2009 12:03:30 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 31595 invoked by uid 500); 12 Nov 2009 12:03:29 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 31587 invoked by uid 99); 12 Nov 2009 12:03:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Nov 2009 12:03:29 +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.6.24] (HELO gmp-eb-inf-2.sun.com) (192.18.6.24) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Nov 2009 12:03:18 +0000 Received: from fe-emea-09.sun.com (gmp-eb-lb-1-fe1.eu.sun.com [192.18.6.7] (may be forged)) by gmp-eb-inf-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id nACC2rfc014619 for ; Thu, 12 Nov 2009 12:02:53 GMT MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) id <0KSZ00J00V91DK00@fe-emea-09.sun.com> for derby-dev@db.apache.org; Thu, 12 Nov 2009 12:02:44 +0000 (GMT) Received: from localhost ([unknown] [129.159.112.134]) by fe-emea-09.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) with ESMTPSA id <0KSZ000NFW4C3KE0@fe-emea-09.sun.com> for derby-dev@db.apache.org; Thu, 12 Nov 2009 12:02:38 +0000 (GMT) Date: Thu, 12 Nov 2009 13:02:34 +0100 From: Knut Anders Hatlen Subject: Re: SQL grammar building In-reply-to: <26315288.post@talk.nabble.com> Sender: Knut.Hatlen@Sun.COM To: derby-dev@db.apache.org Message-id: Organization: Sun Microsystems References: <26315288.post@talk.nabble.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (usg-unix-v) X-Virus-Checked: Checked by ClamAV on apache.org bb00bbyy writes: > Hi, > > I need advice regarding the file sqlgrammar.jj contained in the > impl.sql.compile package. > Well, it seems the file SQLParser.java is produced by some kind of automatic > process using > the file sqlgrammar.jj. I have to modify the SQL parsing to add some fuzzy > query in apache derby. > So can somebody help me and tell me where and how to use this "automatic > process" building SQLParser.java > from sqlgrammar.jj ? Hi Thibault, Derby uses JavaCC (http://javacc.dev.java.net) to generate the parser from sqlgrammar.jj. This is done by the Ant build scripts when Derby is built. See the genParser target in the top-level build.xml file, and how it's used in java/engine/org/apache/derby/impl/sql/build.xml. Hope this helps, -- Knut Anders