Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 7660 invoked from network); 1 Aug 2007 14:10:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Aug 2007 14:10:49 -0000 Received: (qmail 72562 invoked by uid 500); 1 Aug 2007 14:10:48 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 72526 invoked by uid 500); 1 Aug 2007 14:10:48 -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 72517 invoked by uid 99); 1 Aug 2007 14:10:48 -0000 Received: from Unknown (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 07:10:48 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=RCVD_IN_WHOIS_INVALID,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of pandiri@students.iiit.ac.in designates 196.12.53.11 as permitted sender) Received: from [196.12.53.11] (HELO students.iiit.ac.in) (196.12.53.11) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 14:10:39 +0000 Received: from students.iiit.ac.in (localhost.localdomain [127.0.0.1]) by students.iiit.ac.in (8.14.1/8.13.0) with ESMTP id l71EAuTC014665 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 1 Aug 2007 19:40:56 +0530 Received: from localhost (pandiri@localhost) by students.iiit.ac.in (8.14.1/8.14.1/Submit) with ESMTP id l71EAuci014662 for ; Wed, 1 Aug 2007 19:40:56 +0530 Date: Wed, 1 Aug 2007 19:40:56 +0530 (IST) From: Ravinder Reddy Pandiri To: derby-dev@db.apache.org Subject: reg: DatabaseMetaData.getTables() In-Reply-To: Message-ID: References: <56a83cd00706081436s47ad6e1fma2db1f1e7ff19701@mail.gmail.com> <4697D43B.2050601@sbcglobal.net> <54ac72d70707132329w5a9ddbbeu80d1126e6384fccf@mail.gmail.com> <469E4A90.1030301@amberpoint.com> <46A13D20.4090703@sbcglobal.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-yoursite-MailScanner-Information: Please contact the IIIT Server Room for more information X-yoursite-MailScanner: Found to be clean X-yoursite-MailScanner-From: pandiri@students.iiit.ac.in X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No hi, In one of the JUnit test cases I have the following code. Statement s = createStatement(); DatabaseMetaData databaseMetaData; databaseMetaData = getConnection().getMetaData(); ResultSet rs1 = databaseMetaData.getTables("", null, "%", null); I am getting the syntax error in the last line. The Error is: Syntax error: Encountered "ORDER" at line 1, column 815 plzz help me in this regards. Thank U in advance. -- ****************************************************************************** Every problem that has been solved can be solved again in a better way - Ravinder Reddy ******************************************************************************* -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.