db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5337) Encountering error when importing to table using CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
Date Fri, 24 Feb 2012 21:57:49 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13215970#comment-13215970
] 

Mamta A. Satoor commented on DERBY-5337:
----------------------------------------

With the given information, we have not been able to reproduce the bug. The problem may be
with the import data file not having enough columns per row to match the table columns.
                
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message