Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. PersistenceBrokerTemplate.store() has thrown a DataIntegrityViolationException
    Unsorted
    0
    0
    0
  2. PreparedStatement.executeInternal() has thrown a MySQLIntegrityConstraintViolationException
    MySQL Connector/J
    104
    130
    23

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'USER_PRINCIPAL_ID' cannot be null
11 matching frames hidden
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2441)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2366)
11 frames hidden

Solution

chinthana11 months ago

Nothing is wrong with the database. When it gives you those errors, it's telling you that you are trying to input "nothing" (null) into a column that doesn't allow it. Fix it by removing the not null constraint or by passing a value to that field.

External results for this pattern (10)

  1. WENLINRONGvia GitHub4 weeks ago
    javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
    Show stack trace
  2. ariehkovlervia GitHub4 weeks ago
    Duplicate entry '6' for key 'PRIMARY' │···························
    Show stack trace
  3. Jonathan Pricevia Google Groups1 month ago
    Could not execute JDBC batch update
    Show stack trace
  4. 吴冉波via Google Groups1 month ago
    Duplicate entry '115-67' for key 'permission_permission_meta_resource_uniq'
    Show stack trace
  5. TTTimWangvia GitHub2 months ago
    Column 'gift_id' cannot be null ; SQL []; Column 'gift_id' cannot be null; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'gift_id' cannot be null
    Show stack trace
  6. cdmvirtvia GitHub2 months ago
    Cannot add or update a child row: a foreign key constraint fails (`mobhunting`.`mh_Bounties`, CONSTRAINT `mh_Bounties_Player_Id_1` FOREIGN KEY (`BOUNTYOWNER_ID`) REFERENCES `mh_Players` (`PLAYER_ID`) ON DELETE CASCADE)
    Show stack trace
  7. hh6plusvia Stack Overflow3 months ago
    Duplicate entry '2750633-163072083-袋-0' for key 'uk_unit_name'
    Show stack trace
  8. Jon Snowvia Stack Overflow3 months ago
  9. cthielenvia GitHub4 months ago
    could not execute statement; SQL [n/a]; constraint [sectionGroup_unique_courseId_termCode]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
    Show stack trace