On Thu, Feb 14, 2008 at 10:49 AM, Amir Michail <[EMAIL PROTECTED]> wrote: > 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.
Assuming the db is corrupted (even though the integrity check does not find anything wrong), is there an easy way to reconstruct the db from scratch? Is there a simple procedure I can follow? Amir > > 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 > > >
