Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Fri, 15 Jul 2011 12:41:59 +0000 (UTC)
From: "Rick Hillegas (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <439408829.17053.1310733719973.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1960820816.17007.1310731859872.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Updated] (DERBY-5337) Encountering error when importing to
 table using CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-5337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-5337:
---------------------------------

    Bug behavior facts: [Seen in production]  (was: [Deviation from standard, Crash])

Hi Ranjit,

Could you post the CREATE TABLE statement for the table you are importing into? Thanks.

> Encountering error when importing to table using CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
> -----------------------------------------------------------------------------------
>
>                 Key: DERBY-5337
>                 URL: https://issues.apache.org/jira/browse/DERBY-5337
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.8.1.2
>         Environment: 3GB RAM, Windows XP SP3, Core i-5
>            Reporter: Ranjit Aneesh
>
> I am encountering the following issue when trying to call CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE.
> I am passing the schema name as has been pointed out as a possible cause conflicting with multiple tables with the same name.
> The actual error is :
> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('DBA', 'TEST', 'C:/temp/unload/704.dat', ',', '"', 'UTF-8',0)
> 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.
> This issue I am encountering in the 10.8.1.2 version of derby. I am using embedded driver

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira