org.springframework.dao.DataIntegrityViolationException

PreparedStatementCallback; SQL [INSERT INTO ring_info(user_num,calling_num,calling_name, register_date, expired_date, ring_file_name, duration_type, update_date,create_date) VALUES (?, ?, ?, ?,?, ?,?,now(),now())]; Column 'expired_date' cannot be null; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'expired_date' cannot be null

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web11

  • via GitHub by jinwonchoi
    ,
  • via symmetricds by psi_teck
    ,
  • Stack trace

    • org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO ring_info(user_num,calling_num,calling_name, register_date, expired_date, ring_file_name, duration_type, update_date,create_date) VALUES (?, ?, ?, ?,?, ?,?,now(),now())]; Column 'expired_date' cannot be null; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'expired_date' cannot be null at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:86) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:909) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:970) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:980) at com.eclues.ringcatcher.dao.RingInfoDAOImpl.create(RingInfoDAOImpl.java:30) at com.eclues.ringcatcher.ctrl.JSONController.doInviteUser(JSONController.java:354) at com.eclues.ringcatcher.ctrl.JSONController.inviteUser(JSONController.java:291)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    We couldn't find other users who have seen this exception.