The 0.6 version of our EAR archetype includes a hardcoded version number for the H2 database engine artifact. Recent changes in the [fleXive] trunk (i.e. 3.1-SNAPSHOT) require a newer version of H2, otherwise the initialization of the database will fail with a “Syntax error in SQL statement”.
The fix for existing projects is to fix the version number in your main module’s pom.xml: increase the h2.version property from 1.1.106 to 1.1.117.
To avoid this issue in the future, I moved the H2 dependency to the flexive-h2 artifact. The current snapshot version of the archetype (1.0-SNAPSHOT) therefore no longer includes a dependency on com.h2database.h2, and potential changes in the required H2 version number (always a possibility since H2 development is very active) won’t affect existing projects.
