大家帮忙看看啊，求解决

Question

java.sql.BatchUpdateException: Incorrect string value: '\xAA\xA1' for column '?§“???' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1693)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1108)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at dao.impl.studentDaoImpl.saveStudents(studentDaoImpl.java:119)
at servicesDao.impl.studentDaoServicesImpl.saveStudents(studentDaoServicesImpl.java:83)
at servlet.fileDeal.fileUpload.excelDeal(fileUpload.java:232)
at servlet.fileDeal.fileUpload.doPost(fileUpload.java:96)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at servlet.filter.encoderFiter.doFilter(encoderFiter.java:27)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
exception.myException: java.sql.BatchUpdateException: Incorrect string value: '\xAA\xA1' for column '?§“???' at row 1
at dao.impl.studentDaoImpl.saveStudents(studentDaoImpl.java:123)
at servicesDao.impl.studentDaoServicesImpl.saveStudents(studentDaoServicesImpl.java:83)
at servlet.fileDeal.fileUpload.excelDeal(fileUpload.java:232)
at servlet.fileDeal.fileUpload.doPost(fileUpload.java:96)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at servlet.filter.encoderFiter.doFilter(encoderFiter.java:27)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xAA\xA1' for column '?§“???' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1693)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1108)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at dao.impl.studentDaoImpl.saveStudents(studentDaoImpl.java:119)
... 20 more
不知道是什么原因

Answer 1

修改一下mysql数据库的编码方式试试。

Answer 2

看看你的sql语句有没有写对，比如这样就会报错：
update table set name = 张三, password = 123456 where id = 1
修改为
update table set name = '张三', password = '123456' where id = 1

Answer 3

谢谢，代码没错，应该是mysql配置差异的问题，在实验室运行的都没问题！

Answer 4

兄弟，这问题解决了吗？我碰到同样问题。
mysql的字符集由latin1改成utf8，之后就出现报此错误。求配置解决过程。