Re: [h2] SQL synthax error

Hi, According to my test, if you create the tables in the wrong order, HSQLDB will also throw an exception. In addition to the order of tables, the syntax "... KID int FOREIGN KEY REFERENCES KUNDE(KID),..." is not currently supported in H2. It is also not supported in PostgreSQL, Apache Derby,

Re: [h2] H2 corrupted DB

Hi, FYI this problem is fixed since version 1.4.188. The problem was that if writes were re-ordered, and a power failure occurred, truncate was sometimes done before a previous write. Regards, Thomas On Tuesday, May 5, 2015, Osvaldas Ziukas wrote: > > > 2015 m.

Re: [h2] Re: SQL synthax error

You need to create the Kunde table before the |RESERVIERUNG table. Otherwise it can't create the foreign key (because the table doesn't exist). | On 15/10/2015 6:04 PM, Steve McLeod wrote: Two things I can suggest: 1) You should ask this question on stackoverflow.com, not in this mailing