I have been using the MyEclipseIDE to reverse engineer a set of hibernate 3.2 data objects and DAO's using Annotations.

My issue revolves around adding MySQL backticks (`) to table, catalog and column names in order to insure that MySQL queries run properly in situations where names conflict with SQL keywords.

Upon reading the JIRA issue:

http://opensource.atlassian.com/project ... e/HHH-2660

I have taken the course of using a 'fixup' script after object generation to insure that the identifiers are backticked properly.

In HHH-2660 it seems that the developer stance is to add these backticks to the mappings or annotations.

My question is: Should SQL Vendor specific code be added to the mappings this way? This makes the Hibernate mappings configuration non-cross platform!

It seems to me that this should be handled by Hibernate when the MySQLDialect is used.

Any thoughts?

If you enclose the identifier in backticks in your mapping hibernate should generate SQL using the correct identifier depending on the dialect used - so nothing DB-specific here....

Regards

piet