Reverse Engineering Not Detecting Relationships

[dhana-krishnasamy]

Hi There,

I am trying to reverse engineer a mysql db, Eclipse Hibernate tools 3.7.1.Final-v20140303-0022-B124 does everything but not detecting relationships and not generating any navigation properties.

I have ticked (selected) all the options on Main tab of Code generation screen and on Exporters tab I have just selected Domain code, .hbm.xml and .cfg.xml.

The driver I use is mysql-connector-java (5.1.6)/com.mysql.jdbc.Driver and hibernate dialect is org.hibernate.dialect.MySQLInnoDBDialect.

Any hints are appreciated.

Thanks.

[maxandersen]

does the database actually have foreign keys defined ?

[dhana-krishnasamy]

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 :

breeze.js.samples/java at master · Breeze/breeze.js.samples · GitHub

[maxandersen]

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.

[maxandersen]

do you get any output/logging in the console you can share?

[dhana-krishnasamy]

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.