database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
ㆍMS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
MS-SQL Q&A 4335 게시물 읽기
No. 4335
MySQLIntegrityConstraintViolationException 에 대하여
작성자
sukarac
작성일
2008-07-18 11:59
조회수
11,128

com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '2' for key 1

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

        at com.unidocs.database.LoggableStatement.executeUpdate(LoggableStatement.java:368)

        at com.unidocs.action.drm.DrmAction.doInsertPdfSend(DrmAction.java:1452)

        at com.unidocs.servlet.EncPdfDownloadServlet.service(EncPdfDownloadServlet.java:202)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at com.unidocs.commonlib.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:136)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

        at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

        at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)

        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)

        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

        at java.lang.Thread.run(Thread.java:534)


MySQLIntegrityConstraintViolationException 에러가 뭔지 모르겠습니다. 아시는분 답변 좀 부탁드려요~

이 글에 대한 댓글이 총 1건 있습니다.



영어그대로 해석하시면 되는데..

중복된키가 있다고 에러입니다.

PK에 값과 입력되는 PK값이 중복된값이 있는지 확인해보시기 바랍니다.

김병석(byung82)님이 2008-07-19 11:13에 작성한 댓글입니다.
[Top]
No.
제목
작성자
작성일
조회
4338insert문 질문드립니다. [1]
박세진
2008-07-21
4970
4337sql문에 관해서 질문 드립니다 [2]
정명규
2008-07-19
4674
4336이런 쿼리도 가능할까요 [1]
궁금이
2008-07-19
4562
4335MySQLIntegrityConstraintViolationException 에 대하여 [1]
sukarac
2008-07-18
11128
4334일배치로 비교후 인서트 프로시져... [1]
유보현
2008-07-17
4689
4333디비서비스중에 MS-sql 재설치하면...
새미
2008-07-17
4636
4332MSSQL2005와 WinXP 서비스팩3와의 궁합 [1]
2008-07-17
5115
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.017초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다