Jean
Thanks for pointing out the error. Just committed the fix, it will be
fixed in 3.2-RC3
Thomas
On Fri, 7 Oct 2005, Jean T. Anderson wrote:
One problem I discovered in the tutorial (and that repeats in the tests) is
Derby doesn't support creating a table that references another table that
doesn't exist yet. For example, this BOOK create statement fails because the
author table doesn't exist yet (this from
trunks/test/test-project/target/sql/bookstore-schema.sql):
CREATE TABLE book
(
book_id INTEGER NOT NULL,
isbn VARCHAR(15) NOT NULL,
author_id INTEGER NOT NULL,
title VARCHAR(255) NOT NULL,
PRIMARY KEY(book_id),
FOREIGN KEY (author_id) REFERENCES author (author_id)
);
My solution for this for the tutorial was to modify the
src/schema/project-schema.xml to place the BOOK definition at the end, then
it worked great.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
