Werner, we still need SQL scripts. Disadvantage is that we have to create separate scripts for setup (create table) and teardown (drop table) by hand. Advantage is that we do not need to execute them by hand and we do not need to add any script to pom.xml. We can also execute tests against an embedded derby database in eclipse.
I only separated the 2 patches for easier review of changes to code and scripts. If you like to test things, you have to apply both patches.
To get ride of the SQL scripts we will need to extend DDLGEN to be able to specify type and size of columns in mapping. In addition we will need to move definition of default records inserted from scripts to mapping or test cases.
Resolved by using the maven-spl-plugin within the CPACTF POM.