How to resolved SQL syntax error by using entity in spring boot?

Question

I have this order entity. When I use an API to save order, it has this error:

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 (address, created_date, email, full_name, guid, phone_number, price, usern'

I don't know why it has an error. My schema still working alright. Please help me!

@Entity(name = "order")
public class Order {

    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "order_id")
    @Id
    private int id;

    private String guid;

    @Column(name = "username")
    private String userName;

    @Column(name = "full_name")
    private String fullName;

    private String address;

    @Column(name = "phone_number")
    private String phoneNumber;

    private String email;

    private double price;

    @Column (name = "created_date")
    private Date createdDate;

    @OneToMany(cascade = CascadeType.ALL, mappedBy = "order")
    private List<OrderProduct> listProductOrders = new ArrayList<>();

}

I don't know why it has an error. - order is a reserved word in SQL context and it should be quoted — Lukasz Szozda
– Lukasz Szozda, Commented Dec 12, 2019 at 16:39

Mohit Singh · Accepted Answer · 2019-12-12 21:53:51Z

1

order is a reserved word you need to provide a different name to your table.

answered Dec 12, 2019 at 21:53

Mohit Singh

5322 silver badges11 bronze badges

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

2 Comments

泉泉占柱 Over a year ago

Then I must rename the table "order". :sosad:

Mohit Singh Over a year ago

No other option, faced the same issue :)

Collectives™ on Stack Overflow

How to resolved SQL syntax error by using entity in spring boot?

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