We're doing some proof of concept work and I think ORM tools will be a good fit for it, so I'd like to use the latest version of Hibernate tools when we get started... So far, it looks like we'll be doing the BOTTOM up approach so I'll need to generate HBM mapping files from an existing schema definition.

I've bee using Middlegen 2.1 with MySQL 4.1 to do the job - with limited success: it discovers the tables, but fails to discover any relationships between them. Plus, I hear Middlegen is no longer a supported product, so my question is: are there some Hibernate tools (or otherwise), that can be used as a replacement tool for Middlegen to generate Table Mapping XML files from existing Schema definitions in MySQL or Oracle, etc?

Thanks in advance -
James

Umm...Hibernate Tools?

thx