com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:Duplicate entry '0' for k
来源:互联网 发布:java人才机构 编辑:程序博客网 时间:2024/05/16 19:00
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '0' for key 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
at com.pactera.shopping.model.User.save(User.java:57)
at org.apache.jsp.jsp.login_jsp._jspService(login_jsp.java:74)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
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.Http11AprProcessor.process(Http11AprProcessor.java:879)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1760)
at java.lang.Thread.run(Thread.java:619)
出现上述现象的原因:
mysql数据库中的id号设置为了主键,当后台多次请求时,导致id不唯一;只要将主键id设置为递增的就可以了
0 0
- com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:Duplicate entry '0' for k
- com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1' for
- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '
- com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '2147483
- com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '04140700' for
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate ent
- com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate ent原因
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'Form'
- hibernate保存实体类报错com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException
- 数据库异常com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException
- org.hibernate.exception.com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException
- com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' cannot be n
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxError Exception
- 异常:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
- com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException问题
- Java链表的删除操作
- java synchronized 同一对象多实例线程安全
- linux ls 按文件大小排序
- 看清方向,做正确的选择,比只顾闷头做事更重要~
- 定时执行任务crontab的使用
- com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:Duplicate entry '0' for k
- 实习篇---第九天
- 枚举类型
- (转)如何基于FFMPEG和SDL写一个少于1000行代码的视频播放器
- uva--111History Grading +dp
- struts中select使用java中的enum类型
- 黑马程序员——对象的持久化<=>对象的序列化<=>对象的可串行性
- 统计分析和数据挖掘的应用
- Design for Folder(Mac AppStore)