When using a new repository, for production, the idea is to use "validate" and to manually set up the database (using a SQL script created with the "modeshape-jpa-ddl-gen" utility).

The gen utility jar (modeshape-jpa-ddl-gen-2.2.0.Final-jar-with-dependencies.jar) is not currently being included.   Probably need to wrap this with in a build.xml that makes it easier to run.

If there is such utility it should be executed during build process - all other SOA-P components comes with SQL scripts, including those using JPA or Hibernate for db access

Parent: Added: SOA-2271

For ER2, there is a tools directory with the gen jar.    For the next release, will be adding the script generation tooling that will generate all the scripts for the supporting dbs.

The ddl-gen tool is now unbundled with scripts to execute to create ddl.   Also, when modeshape is installed, the predefined supported repositories will be automatically generated.  There will be a directory for each dialect supported containing the create and drop ddl.

MS SQL scripts are missing
Also MySQL should be generated using MySQL 5 dialect to have transactions enabled on the tables - ie. create table ... type=InnoDB;

The fix has been checked into the soa build.   This problem was due to incorrectly entering the dialect for MS.

Verified in ER4