david wrote:
Its a JDBC driver issue. So in general it requires MySQL 3.23.43b (or higher) with InnoDB enabled and MM.MySQL 2.0.9 or higher. The table names must be define in lower case, otherwise no relations will be discovered.
Middlegen did supply an early JDBC driver for it with a patch to help but I believe its not longer needed with the latest versions.
I have fixed the problem but its not the JDBC issue. The relationship was generated but I couldn't see it. Because somehow the relationship window is minimised, you have to drag and pull it open to see it. Oh my god, wasted half a day on this.
Don't think complex, think simple. =(