Error with enum field Hibernate + MySQL

Question

I'm trying to include an enum field to my entity using @Enumerated, Here is my code :

@Entity
public class Frequency extends AbstractModel {
	
	@Column(nullable = true)
	@Enumerated(EnumType.STRING)
	protected DayOfWeek dayOfWeek;

	@Enumerated(EnumType.STRING)
	protected IntervalEnum interval;
}

But when building my project, I get the error :

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'interval varchar(255), primary key (id)) engine=MyISAM' at line 1

It's the enum which is responsible of the error, but why ?

public enum IntervalEnum {
	D,
	W,
	M;
}

I'm using Hibernate 5.2.16 + MySQL 5.7 + Spring boot 1.5.12

Thank you

slemoine · Accepted Answer · 2018-04-12 14:13:56Z

2

Interval is a reserved keyword for mysql

Use @Column to specify a valid name on

protected IntervalEnum interval;

edited Apr 12, 2018 at 14:13

answered Apr 12, 2018 at 12:12

slemoine

3773 silver badges8 bronze badges

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

2 Comments

slemoine Over a year ago

ok isn't interval a protected mysql keyword ? Can you try to rename it or put the @Column with other name ?

error Over a year ago

You are right, Interval is a reserved keyword. I changed the name of the field and it worked.

Collectives™ on Stack Overflow

Error with enum field Hibernate + MySQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related