Hibernate saving User model to Postgres

Question

I'm using Postgres via Hibernate (annotations), but it seems to be falling over dealing with a User object:

12:09:16,442 ERROR [SchemaExport] Unsuccessful: create table User (id  bigserial not null, password varchar(255), username varchar(255), primary key (id)) 12:09:16,442 ERROR [SchemaExport] ERROR: syntax error at or near "User" 

If I run the SQL manually I have to put quotes around the table name as user seems to be a postgres keyword, but how can I convince hibernate to do this itself?

Thanks in advance.

Answer 1

You need to escape the table name when using reserved keywords. In JPA 1.0, there is no standardized way and the Hibernate specific solution is to use backticks:

@Entity @Table(name="`User`") public class User {     ... } 

In JPA 2.0, the standardized syntax looks like this:

@Entity @Table(name="\"User\"") public class User {     ... } 

References

• Hibernate Core documentation
  • 5.4. SQL quoted identifiers
• JPA 2.0 specification
  • 2.13 Naming of Database Objects

Answer 2

User is a key word, find a better name or use quotes: "User". (bad idea imho, but it works if you do it everywhere)