I have a few annotated classes that I generate the database schema from using hibernate.hbm2ddl.auto=create-drop. This works well for all classes except the Group class, the table for this is not created. However if I add a @Table(name="groups") after @Entity it is created (named "groups"). If I try @Table(name="group") it will not work... Any idea why?

Hibernate version: 3.2.1.ga

Mapping documents:
package com.mypackage;
/* imports */

@Entity
public class Group implements Serializable {
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private int groupid = -1;

@Column( nullable=false, length=32 )
private String name;

/* getters and setters */ }


Name and version of the database you are using: MySQL 5.0.22

Hi daijavad,

since GROUP is a reserved word in SQL it is not a valid tablename (as opposed to GROUPS which isn't a SQL-Keyword), so there should be some kind of SQLException in your log indicating the failed "create"-attempt.

Greets

piet

Thanks piet.t!

I thought it may have something to do with reserved keywords, but MySQL is not complaining when I am creating a table named "group" through the MySQL query browser.

Could there be some escaping missing at some level here?

You're right, it's working when you put the table-name in `...` - but I think that's some specific mysql-Extension of standard-sql, so I think hibernate is right in not using it....

I think I just found the solution to your problem:
you can convince hibernate to quote names in the generated SQL:
Just use a mapping like
<class name="LineItem" table="`Line Item`">....
(observe the backticks `)
hibernate will then quote the name on SQL-generation, it will even choose the right quote-character for your SQL-Dialect.