I'm trying to change an AS 5.1 setup to use MySQL as the database for JBM, and the database tables are being created as MyISAM, and I would like to alter the DDL to specify ENGINE=INNODB.

I cannot seem to find the stuff anywhere. In the mysql-persistence-service.xml (I just copied the hsqldb one and renamed it), there is a SqlProperties property that populates the tables, and I'm assuming this is where I would add the DDL for creating the tables, but I'm unsure of the syntax, and the documentation doesn't seem to have anything as an example.

The *-persistence-service.xml files were never part of the 5.0.0 beta or CR distributions either - I guess I have come to just expect them to not be there for betas or CRs and just to miraculously show up in GA. ;-)

I remember after 5.0 GA, I have emailed the AS guys for add the JBM examples for AS 5 as they are specifically for AS 5, not for standalone JBM releases. This will benefit both user and release process. At that time I received some questions about if the doc/examples is the good place, and I answered let's put there until we found a better place. And I didn't received a veto since. So I went on and added them. I don't know for a while why they disappeared. Maybe the better place is nowhere? :)