I am using Hibernate 3.2.4 sp1, and MySQL 5, when I save object to DB, Hibernate compose the following SQL:
insert into db.test(id, introtext, fulltext) values (?, ?, ?);
And error occurred when executing this query.
The problem is that the name of the column fulltext is also a keyword in MySQL query.
In case, I compose this query by hand I would put the column name between `` (eg. insert into db.test(`id`, `introtext`, `fulltext`) values (?, ?, ?);).
How do I get out of this error in case I still using Hibernate and cannot change the column name, or write manual QueryBuilder?
|