Unfortunatly I'm having a problem with Hibernate that I cannot find in the documentation or forums.

I have a table in MySQL which holds a column which is named 'fulltext'.

When hibernate generates the SQL for my query the following SQL is generated:

select content0_.fulltext as fulltext ...

however 'fulltext' is considered as a KEYWORD in MySQL.

How can I get Hibernate to generate something similar to this:

select content0_.fulltext as fulltext_field ...

So that it does not interfer with Mysql keywords....

Thx!

use backtick's to quote the column name.