db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: IJ out of memory
Date Tue, 14 Aug 2007 14:41:15 GMT
> Failed Statement is: ALTER TABLE logicproperty
>   ADD CONSTRAINT r_186
>   FOREIGN KEY
>    ( zone_id )
>   REFERENCES zone
>   ON DELETE CASCADE

You can include the foreign key constraints in the
initial table definition itself, instead of creating the
table and then adding the constraints to it later.

Do you still get the OutOfMemory problem if you include
all the foreign key constraints in the table definition itself,
rather than as separate ALTER TABLE statements?

Also, can you share the entire create_db.sql script?

thanks,

bryan



Mime
View raw message