problem creating db-table in getting started

[mtraceyz]

I can'e get the db tables created. I have l;ooked through the previous posts, but can't find one that sheds light on this problem.

I have run all the ant scripts successfully through assemble-app.
I have modified the hsql-ds.xml as described.

However, when I run db-create-table, I get an error:
SQL Error at line 69: java.sql.EQLException: Integrity constraint violation: SYS_REF_SYS_FK_1_3 table: INVOICE in statement

I am not sure how to debug this. I looked at the hsql-create-table.sql file to see what was happening at line 69. It is the last statement in the file:
INSERT INTO next_tx_id
VALUES (1)

Any help will be appreciated.

[ahardy66]

It seems like you are trying to insert stuff that already exists.

Have you tried getting rid of the data and starting again? There's a couple of comments in the getting-started about doing that which I remember reading.

[andrewi]

Hi,

I'm getting the same thing but can't see anything about clearing the data.

Please help

tia
Andrew

[andrewi]

Hi,

I went into HSQL Database Manager dropped ITEM & INVOICE tables, tried creating and all is well.

Andrew