problem creating db-table in getting started

mtraceyz Feb 12, 2004 9:51 AM

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.

1. Re: problem creating db-table in getting started

ahardy66 Feb 18, 2004 6:42 AM (in response to mtraceyz)

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.
Actions
2. Re: problem creating db-table in getting started

andrewi Aug 8, 2005 6:42 AM (in response to mtraceyz)

Hi,

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

Please help

tia
Andrew
Actions
3. Re: problem creating db-table in getting started

andrewi Aug 8, 2005 6:46 AM (in response to mtraceyz)

Hi,

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

Andrew
Actions

Go to original post