Reproducing JPA issue with save ()

I am trying to store a simple object in a database, but this creates problems.

This is my class of objects:

@Entity
@Table(name="lines")
public class Line extends GenericModel{

    @Id
    @Column(name="line_id")
    private int id;

    @Column(name="line_text")
    private String text;

    @Column(name="line_postid")
    private int postid;

    @Column(name="line_position")
    private int position;
}

And here is what I have in my controller:

Line l = new Line();
l.setPosition(0);
l.setPostid(4);
l.setText("geen");
l.save();

I am doing the same for other models and I have no problems, only this question gives me problems. When I update my browser, I get: PersistenceException occured : org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

I also added jpa.debugSQL=trueto my configuration, and in my console I get:

Caused by: java.sql.BatchUpdateException: 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 'lines (line_position, line_postid, line_text, line_id) values (0, 4, 'geen', 0)' at line 1

And the browser also shows this: This exception has been logged with id 66k3glbb6but I have no idea where I can view my logs, so if someone could tell me that too?

+3
source share
2 answers

lines is a reserved word in MySQL, you need to avoid it as follows:

@Table(name="`lines`") // Hibernate way

or

@Table(name="\"lines\"") // JPA standard way
+8
source

, @Transactional(readOnly = true).

0

All Articles