#java.sql.batchupdateexception

[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.

JDBC SQL Classes

The JDBC SQL classes and interfaces remain in two Java packages : java.sql and javax.sql:

java.sql :- This package contains classes and interfaces designed with traditional client-server architecture in mind. Its functionality is focused primarily on basic database programming services such as creating connections, executing statements and prepared statements, and running batch…