MySQL的数据插入中抛出如下异常:
[quote]java.sql.BatchUpdateException: Data truncation: Out of range value adjusted for column 'price' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
at com.taoshushu.plib.dao.PdDao.addPdStatic(PdDao.java:136)
at com.taoshushu.plib.catmap.CatMapping.mapCat(CatMapping.java:196)
at com.taoshushu.plib.catmap.CatMapping.main(CatMapping.java:305)[/quote]
MySQL 5.0
JDK 1.6.0_10
经查阅资料,发现导致该异常的原因,已经迁移到新博客:
[url]http://www.mannyisbusy.com/batchupdateexception-data-truncation-oo-range-value/[/url]
[quote]java.sql.BatchUpdateException: Data truncation: Out of range value adjusted for column 'price' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
at com.taoshushu.plib.dao.PdDao.addPdStatic(PdDao.java:136)
at com.taoshushu.plib.catmap.CatMapping.mapCat(CatMapping.java:196)
at com.taoshushu.plib.catmap.CatMapping.main(CatMapping.java:305)[/quote]
MySQL 5.0
JDK 1.6.0_10
经查阅资料,发现导致该异常的原因,已经迁移到新博客:
[url]http://www.mannyisbusy.com/batchupdateexception-data-truncation-oo-range-value/[/url]