Re: [h2] Recreate database

Hi, The sequence is OK. With shutdown immediately, the files should be closed (if not, then that would be a bug). However, after shutdown immediately, closing the connection throws an exception (The database has been closed). What you could do is catch and ignore that exception. An alternative

Re: [h2] Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

Hi, I'm afraid I can't tell what the problem is. The database was created with version 1.3.168. I didn't see any temporary tables in the database file. But I'm afraid I would need a reproducible test case in order to help for this case. Regards, Thomas On Thu, Mar 27, 2014 at 8:31 PM, Dieter

[h2] Trigger: ALTER statements failing - Commit or rollback is not allowed

Hi, I have been experimenting with H2 and would like to use the Trigger mechanism to update the structure of a separate table. Problem I am running into is that apparently DDL statements are not allowed from within the scope of the Trigger fire method. In Oracle, this problem has been resolved