org.springframework.jdbc.BadSqlGrammarException: bad SQL grammar

Question

I am getting the following error in my code:

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad 
SQL grammar [insert into bulletins (date, name, subject, note, approved) values 
(?, ?, ?, ?, ?)]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxError 
Exception: Unknown column 'date' in 'field list'

This line is in my Spring controller.

bulletinDAO.writeBulletin(bulletin);

The actual place in my DAO class where I'm trying to write using Hibernate.

public void writeBulletin(Bulletin bulletin) {
    try {
        Session session = sessionFactory.openSession();
        Transaction tx = session.beginTransaction();
        session.save(bulletin);
        tx.commit();
    } catch (Exception e) {
        System.out.println(e.toString());
    }
}

Here is my model class.

    @Entity
    @Table(name="login")
    public class Bulletin {
        @Id
        @Column(name="id")
        @GeneratedValue
        private int id;

        @Column(name="bulletin_date")
        private String date;

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

        @Column(name="subject")
        private String subject;

        @Column(name="note")
        private String note;

        @Column(name="approved")
        private boolean approved;

        // Getters and setters follow
}

Finally, here is the layout of the table.

+---------------+---------------+------+-----+---------+----------------+
| Field         | Type          | Null | Key | Default | Extra          |
+---------------+---------------+------+-----+---------+----------------+
| id            | int(11)       | NO   | PRI | NULL    | auto_increment |
| bulletin_date | varchar(10)   | YES  |     | NULL    |                |
| name          | varchar(30)   | YES  |     | NULL    |                |
| subject       | varchar(50)   | YES  |     | NULL    |                |
| note          | varchar(2500) | YES  |     | NULL    |                |
| approved      | tinyint(1)    | YES  |     | NULL    |                |
+---------------+---------------+------+-----+---------+----------------+

neo108 neo108 · Accepted Answer · 2014-09-15T23:34:55

There must be something wrong with your getters and setters.

I would recommend changing the property name from date to bulletinDate. And then set & get it correctly...

 @Column(name="bulletin_date")
 private String bulletinDate;

 public String getBulletinDate() {
    return bulletinDate;
 }
 public void setBulletinDate(String bulletin_date) {
    this.bulletinDate = bulletin_date;
 }

org.springframework.jdbc.BadSqlGrammarException: bad SQL grammar

2 Answers