Hello, like that this naming problem took some hours to discover. Especially because the HypersonicSQLDB 1.8 works great.

With MySQL 5 and the current 3.1rc1 dialect MySQLInnoDB (didn't test the other dialects, yet) the name of the index column yields a SQL syntax error when creating the turn table:

@Entity
class Turn {

// ...

@OneToMany
@IndexColumn(name = "index")
public List<Action> getActions() {
return actions;
}

}

Is there any source/documentation where I can see the "forbidden" words? Is it possible to include those discovered keywords in the Dialects and throw an exception at runtime when they are used?

Cheers,
Christian

If you're volontier to inventory all reserved keywords of every supported database...
But be aware that Oracle has more reserved keywords than the french dictionary has entries

Well I guess that's because we have an academy that takes care of our language.

The list of reserved words in mySQL 5 can be found here:

http://dev.mysql.com/doc/refman/5.0/en/ ... words.html

There are certain ways you can use them still, but I've found it best just to stay away entirely :)