SQL syntax error with spring boot

Question

i'm using spring boot, i want to add new "champ", this is the code

                Champ c  = new Champ();
                c.setOrder(1);
                c.setType("RRRR");
                c.setStructurenotification("#AA");
                champservice.AddNewChamp(c);

the table "champ" have fields : "idchamp", "structidstructurenotification" ,"type" and "order".

but i get this error

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 'order, 
structidstructurenotification, type, idchamp)
 values (1, '#AA', 'RRRR', 0' at line 1

i think its because of the "order" it Ordery is a keyword for Order By..change the column name and try — Sachu, May 24 '15 at 11:50

score 3 · Answer 1 · answered May 24 '15 at 11:57

3

Order is a reserve word for Order By. Change the column name to some meaningful name and check.

answered May 24 '15 at 11:57

Sachu

7,555
7
55
94

Thnx...spent 4 days because of `Order` word. I was trying to create table name order – AkshayT Mar 20 '17 at 09:29
@AkshayTaru :) glad it helped – Sachu Mar 21 '17 at 11:36

SQL syntax error with spring boot

1 Answers1