I'm using JPA with Hibernate EntityManager. I have an entity called user and I have hbm2ddl enabled. The thing is that user is a Postgres' reversed word so if I'm to use it, say, as my table name, I have to quote it.

I didn't find anyway to do this. Will I have to extend Postgre dialect? Shouldn't the built-in dialectic quote reserved words by default?

Hibernate's SQL:


To be SQL:



Hibernate version: 3.2.4.sp1
Dialect: org.hibernate.dialect.PostgreSQLDialect

Use backticks (`) around table names in your mappings files. Eg.



Now, Hibernate will quote the table name whenever it is used in SQL. Here is more info: http://www.hibernate.org/hib_docs/v3/re ... dentifiers

Thanks, but this is a workaround.. Shouldn't it be built-in the dialect?

I did put surround the table name with \", but then JPA auto-generates broken names like the DDL:



So I guess now I have to explicitly declare every name of tables related to User, right?.. =(

Personally, I wouldn't mind if Hibernate always did put the correct quotes around table and column names. Or at least, if there was a global setting that could turn this on. However, I think the documentation is quite clear on this issue. No backticks -> no quotes. One reason for this behavior may be that quotes changes case-sensitivity in some databases. Eg. in PostgreSQL unquoted names are converted to lower-case.