#data truncation

[Solved] java.sql.BatchUpdateException: Data truncation

BatchUpdateException is sub class of SQLException. BatchUpdateException occurred when any queries fail during batch update. BatchUpdateException also return the values of counts for each queries update before queries fail.

A SQL queries can fail because of  data constraints violations or syntax issues etc.

Below is some common situation where ConstraintViolationException occurs:

Insert a record…

[Solved] org.springframework.dao. DataIntegrityViolationException: PreparedStatementCallback -Data truncation

Hibernate throws ConstraintViolationException, when tries to insert a row or update particular column or delete records that violate underlying database integrity constraints. Below is some common situation where ConstraintViolationException occurs:

Insert a record with primary key as null.

Insert/ Update primary key value is not unique.

Insert data value size is more than predefine column size.