Java Hibernate exception MySQLSyntaxErrorException: You have an error in your SQL syntax

Question

I have hibernate entity and when I try insert it into MySQL database I get exception:

@Entity
public class Pick {
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private int pid;

@OneToOne
private Match_soccer match;

@OneToOne
private Algo1 algo;

@Column(length = 100)
private String pick;

@Column(length = 5)
private double limit;
...

And when I try insert to MySQL database using hibernate:

Pick pick = new Pick();
pick.setMatch(match);
pick.setAlgo(a);
pick.setLimit(2.5);
pick.setPick("under");

PickDAO pd = new PickDAO();
pd.insertMatch(pick);

I get MySQL exception:

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 'limit, match_mid, pick) values (1, 2.5, 9358, 'under')' at line 1

Did you try changing variable name limit to some other ?

Suresh Atta
– Suresh Atta

2015-08-20 13:48:09 +00:00
Commented Aug 20, 2015 at 13:48 — Suresh Atta
– Suresh Atta, Commented Aug 20, 2015 at 13:48
Can you show insertMatch method?

PatrykG
– PatrykG

2015-08-20 13:50:16 +00:00
Commented Aug 20, 2015 at 13:50 — PatrykG
– PatrykG, Commented Aug 20, 2015 at 13:50

Reimeus · Accepted Answer · 2015-08-20 13:56:07Z

3

Limit is a MySQL reserved word. Rename the entity attribute to something else

edited Aug 20, 2015 at 13:56

answered Aug 20, 2015 at 13:51

Reimeus

160k16 gold badges225 silver badges282 bronze badges

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

3 Comments

Suresh Atta Over a year ago

This is what I'm guessing :) +1.

Edgaras Karka Over a year ago

Yes, here was my problem :)

Ian McLaird Over a year ago

Honestly, this seems like a bug in the hibernate dialect for mysql. It's perfectly possible to have a column or table whose name is a reserved word, you just have to quote it properly. The dialect should be smart enough to take care of that for you.

Collectives™ on Stack Overflow

Java Hibernate exception MySQLSyntaxErrorException: You have an error in your SQL syntax

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related