Announcement Announcement Module
No announcement yet.
Running Greenhouse on MySQL - working after tweakig! Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Running Greenhouse on MySQL - working after tweakig!

    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?

  • #2
    Some more changes

    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");


    • #3
      Can you post your code with mysql support?