Hi,

Just registered because I have observed a weird problem (which presumably has something to do with my configuration).

Hibernate version:
3.2.5.ga


Mapping documents:
Simplets example:


Code between sessionFactory.openSession() and session.close():
Using the HibernateTemplate from Spring:


Name and version of the database you are using:
MySQL 5.0.44 (Gentoo Linux patched) on a development laptop.


The generated SQL (show_sql=true):


Hibernate is set to use the MySQL5InnoDBDialect, but the generated SQL does not escape the key column. The word key is reserved in MySQLs dialect, so a MySQL error is returned stating that there is a syntax-error near: "key, value) values (?, ?)"

Of course I have already worked around this by changing the name "key" to something else as that makes life easier for everyone, but I am still wondering if I've missed something in the configuration? Is there some setting to tell Hibernate to escape the column names?

Hi,

seems you're not the only one using reserved words for column-names, since hibernate can handle this. Just look here under "SQL quoted identifiers".

Regards

piet[/url]

Thanks for the quick reply.. must have missed it in the docs :-)

And yes, I agree that it is a bad idea to use reserved words for column names.

From the documentation:

I use annotactions and don't want database specific names in my classes.

I'am facing the same problem with the column "key". Production is running on Postgres and my development environment is running MySql. "key" is not a reserved word on Postgres, but it is on Mysql.

I don't understand why the openQuote form the Dialect isn't used.

Or is there any stetting to force hibernate to use the openQuote and closeQuote?