I am trying to create a simple example for saving a object with two fields (MySQL 5) of which one is an ID. I defined the following in the HBM.XML


and the corresponding SQL that is generated by the org.hibernate.dialect.HSQLDialect is



which does not runs successfully even in MySQL query browser. I am getting exception



I am not sure what is a miss here.

- Samarthya

When I debug and manually edit the query to


in IncrementGenerator class it works fine. What is it that I am doing wrong any idea anyone?

INDEX is a reserved keyword. If you want to use that as the column name, you need to quote with backticks it like this:

Thanks! it does works but when I try to insert some values



I get the same exception

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"INDEX")

Are you using HSQL or MySQL? With MySQL you should use one of the MySQL dialects.

I am using MySQL - Thanks for the tip though!