Running Greenhouse on MySQL - working after tweakig!

[knemo]

After a bit of struggle, I finally managed to get it running with MySQL as the backend database. here I my steps:

1. StandardDataSourceConfig - including database.driver and using Apache DBCP
2. pom.xml to include DBCP and MySQL Driver
3. Change the SQL-files to use MySQL compliant syntax, such as BIGINT (instead of identity) and varchar(255) instead of varchar, and some more tweeks with the references
4. Generated a drop-SQL to clean the persisted MySQL (otherwise the upgrader always fails
5. ... possibly some more tweaks I forgot

Are there any plans on supporting a standard profile out of the box as well as the embedded one?

[knemo]

Just came across some more changes I had to do:

1. Changed jdbcTemplate.queryForLong("call identity()");
2. to a quick hack like jdbcTemplate.queryForLong("select max(id) from App");

[kevinqs]

Can you post your code with mysql support?

Thanks.