On Thu, Feb 14, 2008 at 4:30 AM, Knut Anders Hatlen <[EMAIL PROTECTED]> wrote: > Amir Michail <[EMAIL PROTECTED]> writes: > > > On Feb 13, 2008 7:13 PM, Amir Michail <[EMAIL PROTECTED]> wrote: > >> > >> On Feb 13, 2008 3:51 PM, Amir Michail <[EMAIL PROTECTED]> wrote: > >> > Hi, > >> > > >> > What does this error mean? > >> > > >> > ERROR XSCH5: In a base table there was a mismatch between the > >> > requested column number 9 and the maximum number of columns 10. > >> > > >> > This happens when I tried to add a reference to a primary key. > > Hi Amir, > > Could you post the SQL statement you are trying to execute and the > schema for the tables involved? I think the error means that an attempt > to add a column to a table/conglomerate failed because the conglomerate > already has a column with the given id. I think this is an internal > error, and it could be a bug in Derby. >
The integrity check did not reveal any error. But this fails: ij> alter table levels add column shape_id int references shapes; ERROR XSCH5: In a base table there was a mismatch between the requested column number 9 and the maximum number of columns 10. Amir > > >> Do you think my db is corrupted? > > > > What's the command for checking db integrity? > > http://db.apache.org/derby/docs/10.3/adminguide/cadminconsist01.html > > -- > Knut Anders >
