From derby-user-return-11990-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue Dec 15 16:20:07 2009 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 85799 invoked from network); 15 Dec 2009 16:20:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 15 Dec 2009 16:20:07 -0000 Received: (qmail 28625 invoked by uid 500); 15 Dec 2009 16:20:06 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 28587 invoked by uid 500); 15 Dec 2009 16:20:06 -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 28579 invoked by uid 99); 15 Dec 2009 16:20:05 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Dec 2009 16:20:05 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Dec 2009 16:20:03 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1NKa7j-0000Bc-AE for derby-user@db.apache.org; Tue, 15 Dec 2009 08:19:43 -0800 Message-ID: <26796232.post@talk.nabble.com> Date: Tue, 15 Dec 2009 08:19:43 -0800 (PST) From: Wildman To: derby-user@db.apache.org Subject: Re: SQLException Table does not exist although just created In-Reply-To: <26795557.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: wleue1@nycap.rr.com References: <26780099.post@talk.nabble.com> <4B26D9FA.40202@sun.com> <26795124.post@talk.nabble.com> <4B27984E.4010001@sun.com> <26795557.post@talk.nabble.com> After having fixed the table name capitalization problem, when I attempt to execute the CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE call, I get this error: java.sql.SQLException: The exception 'java.sql.SQLException: Column 'COLUMN2' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'COLUMN2' is not a column in the target table.' was thrown while evaluating an expression. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) This is quite a helpful error message, yes? Can anyone help in interpreting it? Thanks! -Bill -- View this message in context: http://old.nabble.com/SQLException-Table-does-not-exist-although-just-created-tp26780099p26796232.html Sent from the Apache Derby Users mailing list archive at Nabble.com.