db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "DerbySQLroutines" by DonaldMcLean
Date Fri, 21 Jul 2006 17:18:40 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by DonaldMcLean:
http://wiki.apache.org/db-derby/DerbySQLroutines

------------------------------------------------------------------------------
  
  The table and field names must be given in ALL UPPER CASE. Otherwise you will get "ERROR
XIE0M: Table 'property' does not exist." or "ERROR XIE08: There is no column named: set_id."
  
+ If the number of columns in the data is greater than the number of columns in the insertColumns
list then the extra columns are ignored. However, if the reverse is true then you get this
ugly and nearly meaningless SQL exception: "ERROR 38000: The exception 'SQL Exception: 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."
+ 

Mime
View raw message