db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ranjit Aneesh (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5337) Encountering error when importing to table using CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
Date Fri, 15 Jul 2011 12:10:59 GMT
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

        

Mime
View raw message