How to use Space in column name with JPA and Hibernate

Question

I have used in my java DAO class which contains Space in between LANG PREF

 @Column(name = "LANG PREF")
  private String langprefid;

Once my java class runs, I am getting

org.hibernate.exception.SQLGrammarException: Incorrect syntax near the keyword 'as'.

Can anyone help me regarding this problem?

You should rather change the name of the column itself. It's just bad practice to have spaces in column names. — saran3h
– saran3h, Commented Apr 13, 2020 at 11:30

Vlad Mihalcea · Accepted Answer · 2021-01-09 10:50:22Z

18

Manually escaping the reserved keywords

If you're using Hibernate native API, then you can escape them using backticks:

@Column(name = "`LANG PREF`")

If you are using JPA, you can escape with double quotes:

@Column(name = "\"LANG PREF\"")

Automatically escaping reserved keywords

If you want to automatically scape reserved keywords, you can set to true the Hibernate-specific hibernate.globally_quoted_identifiers configuration property:

<property
    name="hibernate.globally_quoted_identifiers"
    value=true"
/>

edited Jan 9, 2021 at 10:50

answered Jul 6, 2015 at 6:43

Vlad Mihalcea

156k85 gold badges599 silver badges984 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vishwas · Accepted Answer · 2015-07-06 06:46:16Z

-2

You can change your code to

import javax.persistence.Column;
@Column(name = "LANG_PREF")
private String langprefid;

answered Jul 6, 2015 at 6:46

Vishwas

781 silver badge6 bronze badges

Collectives™ on Stack Overflow

How to use Space in column name with JPA and Hibernate

2 Answers 2

Manually escaping the reserved keywords

Automatically escaping reserved keywords

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Manually escaping the reserved keywords

Automatically escaping reserved keywords

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related