While testing the latest 6.1.6 RC1, I upgraded one of my Roller storage instances to the latest release of the H2 database (H2 2.5.250). H2 2.5.250 is stricter with SQL standards than previous versions and this newer version considers the term VALUE a reserved word for column names.
The table "PUBLIC".ROLLER_PROPERTIES has NAME AND VALUE for columns and so Roller will fail when trying to read the table. Interestingly, H2's backup/restore tools allow the table to be recreated in the latest version "as is" but will produce an error when querying the VALUE column (preventing Roller from starting). Fortunately, H2 provides a workaround: the ";NON_KEYWORDS=VALUE" can be appended to the JDBC URL and all works well thereafter with Roller. Posting this just in case H2 is included in any tests. Best, Richard
