Re: [h2] compacting an embedded h2 database

2018-01-27 Thread Kerry Sainsbury
Is it feasible to create a new empty database? On 26 January 2018 at 01:53, Famco wrote: > I am using the database in embedded mode, so trieing to execute "shutdown > compact" does not work (I waited 15 minutes on an 1GB File) > For me it looks like H2 is NOT reusing empty

Re: [h2] Data Inconsistencies between H2 DB and the generated SQL

2018-01-27 Thread Kerry Sainsbury
The column with the 'wrong' value is not an auto-increment column, so auto-increment isn't likely to be the problem. Most likely explanation is that something else has changed parent_id from 6 to 2, after the original insert. On 25 January 2018 at 15:50, Anerudh Balaji