Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 74275 invoked from network); 3 Jan 2008 22:51:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Jan 2008 22:51:40 -0000 Received: (qmail 73498 invoked by uid 500); 3 Jan 2008 22:51:29 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 73122 invoked by uid 500); 3 Jan 2008 22:51:28 -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 73111 invoked by uid 99); 3 Jan 2008 22:51:28 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Jan 2008 14:51:28 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [66.111.4.28] (HELO out4.smtp.messagingengine.com) (66.111.4.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Jan 2008 22:51:05 +0000 Received: from compute1.internal (compute1.internal [10.202.2.41]) by out1.messagingengine.com (Postfix) with ESMTP id 52E0F82FA1 for ; Thu, 3 Jan 2008 17:51:09 -0500 (EST) Received: from web7.messagingengine.com ([10.202.2.216]) by compute1.internal (MEProxy); Thu, 03 Jan 2008 17:51:09 -0500 Received: by web7.messagingengine.com (Postfix, from userid 99) id 31AEA3BA0A; Thu, 3 Jan 2008 17:51:09 -0500 (EST) Message-Id: <1199400669.13215.1229369107@webmail.messagingengine.com> X-Sasl-Enc: YW3DccKwJvaq2qdshxbOkdGOoSpyHkdvXhsK49COCQpp 1199400669 From: "Peter Yuill" To: "Derby Discussion" Content-Transfer-Encoding: 7bit Content-Type: multipart/alternative; boundary="_----------=_1199400669132150"; charset="ISO-8859-1" MIME-Version: 1.0 X-Mailer: MessagingEngine.com Webmail Interface Subject: Re: getImportedKeys() and getTables() return no rows In-Reply-To: <08BFA5ADA9462E4F96E4A31A270FC86B04DF2ED6@USA0300MS02.na.xerox.net> Date: Fri, 04 Jan 2008 09:51:09 +1100 References: <08BFA5ADA9462E4F96E4A31A270FC86B04DF2ED6@USA0300MS02.na.xerox.net> X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --_----------=_1199400669132150 Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="ISO-8859-1" MIME-Version: 1.0 X-Mailer: MessagingEngine.com Webmail Interface Date: Thu, 3 Jan 2008 22:51:09 UT Bruce, I think the problem is that you are assuming schema and table names are case insensitive, and that null equals "". Try: mrs=dbm.getTables(null,"APP",null,null); // not (null,"app",null,null) and mrs=dbm.getImportedKeys(null,"APP","POLICY"); // not ("","APP","policy") Regards, Peter Yuill --_----------=_1199400669132150 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="ISO-8859-1" MIME-Version: 1.0 X-Mailer: MessagingEngine.com Webmail Interface Date: Thu, 3 Jan 2008 22:51:09 UT Re: getImportedKeys() and getTables() return no rows =0D

Bruce,

I think the problem is that you are assuming sc= hema and table names are case insensitive, and that null equals ""= ;. Try:

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 mrs=3Ddbm.g= etTables(null,"APP",null,null); // not (null,"app",null= ,null)

and

= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 mrs=3Ddbm.getImportedKeys(null,"A= PP","POLICY");=A0 // not ("","APP","= ;policy")

Regards,

Pet= er Yuill

 

=0D =0D
=0D =0D =0D --_----------=_1199400669132150--