Hibernate version:3.2.2.ga

Name and version of the database you are using: mysql


Hi, I try to use schema exporter in my test. The export don't work because one field name is a sql keyword and there is no quote in the generated sql :

GRAVE: Unsuccessful: create table mytable (id bigint not null, int integer, primary key (id))
27 mai 2007 16:48:46 org.hibernate.tool.hbm2ddl.SchemaExport create
GRAVE: Syntax error: Encountered "int" at line 1, column 411.

(I delete all other fields in the trace, so column 411 is not relevant)

The generated sql is incorrect, if it were :

create table mytable (`id` bigint not null, `int` integer, primary key (`id`))

It will work. Is there a way to force the quote in the hbm.xml ?

I precise I can't change the field name.

Edit :

For my test, I tried :

<property name="int_" type="java.lang.Integer">
<column name="`int`" precision="7" scale="0"></column>
</property>

It works for the export but get(MyClass.class, id); don't work because the generated sql is :

select .... myclass0_."int" as int21_0_0_... where myclass0_.id=?

(I delete some information to be more readable)

mysql don't like the " ^^

Do you have the correct Dialect in your hibernate.cfg.xml?:

cause the default translation for backticks are the double quotes.


By the way, you have to maintain your code as is:

For my unit test, I use an embedded database : derby. So the dialect is DerbyDialect.
In production I use mysql dialect.

But you say I have to keep : `int` in my mapping files ? Is it correct for derbyDialect and mysql dialect ?

Yes.
Hibernate Reference:
5.4. SQL quoted identifiers