does the database actually have foreign keys defined ?
Of course it does. I actually created created db from this example , the example already has mapping files. But I'm trying to see if hibernate reengineering can generate same mapping files.
DB files :
sorry for asking about it but in most cases the issues with missing relationships is that users using mysql don't actually have the foreign keys defined.
I'll need to try it but normally if you use recent mysql driver AND mysql database this should just work.
do you get any output/logging in the console you can share?
No worries. There are not many log statements found. Just when I generate revengg file I get the below logs
2014-08-25 18:06:53,119 WARN Worker-15 org.hibernate.cfg.reveng.JDBCReader - The JDBC driver didn't report any primary key columns in nextid. Asking rev.eng. strategy
2014-08-25 18:06:53,155 WARN Worker-15 org.hibernate.cfg.reveng.JDBCReader - Rev.eng. strategy did not report any primary key columns for nextid
I tried upgrading MySql Driver version to 5.1.32 and tools version to 4.3.1.CR1. The mysql version is 5.6.17. No luck.