Wednesday 11 July 2012

SQL Error: 1064, SQLState: 42000:org.hibernate.exception.SQLGrammarException:

This problem happens when we use any kind of legal word as the name of the table or column. Here, the legal word means a word which is treated by hibernate in a different manner. For instance, if you user the word 'from' as the column name, the same error will occur because the word 'from' is used in the sql (select * from tablename). I advice you to change the column names.

So, it will be better if the reserved keyword is not used as the column name or table name......

One of my favourite java frameworks

Always happy to help you,  my profile in stackoverflow.com.