db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: SQLException Table does not exist although just created
Date Tue, 15 Dec 2009 16:54:14 GMT
Hi Bill,

It's hard to say without seeing the SQL you used to create the tables 
and the SQL of the query which is failing. You may have another 
capitalization problem here: column names obey the same casing rules as 
table names.

Hope this helps,

Wildman wrote:
> 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 raw message