Quoting with Hibernate

Bogdoll · **Posted:** Mon Nov 17, 2003 8:30 am

Hi

If have a table name called user. Because this table name is often a sql identifier, I want to quote the name. How do I do that with Hibernate.

Within the Dialect the quote char is specified, but how do I enforce Hibernate to use these quotes? (Hibernate 2.0.3).

Thanks.

Ciao
Dieter

emmanuel · **Posted:** Mon Nov 17, 2003 8:40 am

From the 4.3 section

Quote:

You may force Hibernate to quote an identifier in the generated SQL by enclosing the table or column name in backticks in the mapping document. Hibernate will use the correct quotation style for the SQL Dialect (usually double quotes, but brackets for SQL Server and backticks for MySQL).

<class name="LineItem" table="`Line Item`">
<id name="id" column="`Item Id`"/><generator class="assigned"/></id>
<property name="itemNumber" column="`Item #`"/>
...
</class>