Hi all,

we are trying to convert our hibernate project from MSSQL to MySQL but found a problem with the query generation.

Hibernate for instance logs this query:


This results in a syntax error. When I fill in my values, that indeed fails and appears to be the problem of the "Release" column. Trying this (with quoting around "release" does work:



Is there a way I can make hibernate add these backquotes by configuration or is this actually a bug?

btw... I have set the dialect to MySQLInnoDBDialect since I am only using InnoDB tables in MySQL 5.0.41

Thank you for your help,
Steven

Steven, I do think you can name a column in almost anyway you want. I didn't try back quotes but I tried MSSQL brackets and it worked. Give it a try.







Farzad-

There is...
Just include the backquotes in your mapping-file like this:

the good thing about this is: hibernate will automatically use the appropriate quotes for your SQL-Dialect, so for mssql this would result in the column-name being enclosed in brackets, for mySql it should be enclosed in backquotes.

Greets

piet