Data truncation: Data truncated for column 'sqDate' at row 1求高手解惑!
public void testCreateBatch(){
List<WyGame> wygameList = new ArrayList<WyGame>();
for(int i = 1;i<11;i++){
WyGame wygame = new WyGame();
wygame.setGameName("xxxxxxxx");
wygame.setXlhType("xxxxxxxx");
wygame.setIsUsed("false");
String xlh = "xxxxxxxxxxxxx";
wygame.setXlh(xlh+i);
wygame.setSqDate(new Date());
wygameList.add(wygame);
}
wygameservice.createBatch(wygameList);
}
执行这个方法会报:
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: Could not execute JDBC batch update; SQL [insert into mychat.wygame (gameName, xlhType, xlh, sqDate, isUsed, id) values (?, ?, ?, ?, ?, ?)]; Data truncation: Data truncated for column 'sqDate' at row 1; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'sqDate' at row 1 这个错误
能成功插入第一条记录,只是之后9条记录没有插入数据库,数据库sqDate字段的类型为date;
求高手解惑,如何解决这个问题。