Foreign keys missing by reveng, latest drivers

ziphyre · **Joined:** Tue May 27, 2008 7:11 am **Posts:** 5

Hello,

We are starting a new project and the db schema is ready. We are using MySQL 5.0.67 and all our tables are InnoDB. As connector we are using the mysql jdbc connector v.5.1.7.

But still, I'm unable to retrieve foreign keys from db with eclipse (Hibernate Tools plugin)?

We are using Eclipse 3.4 + latest beta of Tools, should I try
with Eclipse 3.3 + stable version of Tools?

Thanks

max · **Posted:** Wed Nov 19, 2008 7:39 am

is the foreign keys actually defined ?

ziphyre · **Joined:** Tue May 27, 2008 7:11 am **Posts:** 5

Yep,

It's about a bug on mysql driver and windows systems.
It's supposed to be case insensitive but if the internal metadata storage and the schema name on the connection url doesn't match, by case basis, it can connect the data but not retrieve the metadata somehow.

I tried to find the bug to post it here, but no lock.

Any way, switching mysql to case sensitive mode, and recreating schema solved the problem...

Thanks