org.springframework.dao.DataIntegrityViolationException
前台报的错误信息:
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into "GOODS" ("GOODSNAME", "BILLSTATUS", "GOODSDISTRICT", "GOODSPRICE", "GOODSCOUNT", "CREATIONTIME", "ID") values (?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: Could not execute JDBC batch update
报错原因:数据库里的GOODSPRICE字段为number(4,2),整数位只能有两位,添加的时候,输入了错误的数字。