org.postgresql.util.PSQLException: ERREUR: la valeur d'une cl? dupliqu?e rompt la contrainte unique ? wrequirement_pkey ? Detail: La cl? ? (wrequirement_id)=(43642) ? existe d?j?. Error Code: 0 Call: INSERT INTO WREQUIREMENT (wrequirement_id, COMPLETENESS, wlevel, wlimit, QUALITY, QUANTITY, wwork) VALUES (?, ?, ?, ?, ?, ?, ?) bind => [7 parameters bound] Query: InsertObjectQuery(WRequirement( 43642 ))

GitHub | fxaeberhard | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    PMG - Unable to duplicate Task

    GitHub | 4 years ago | fxaeberhard
    org.postgresql.util.PSQLException: ERREUR: la valeur d'une cl? dupliqu?e rompt la contrainte unique ? wrequirement_pkey ? Detail: La cl? ? (wrequirement_id)=(43642) ? existe d?j?. Error Code: 0 Call: INSERT INTO WREQUIREMENT (wrequirement_id, COMPLETENESS, wlevel, wlimit, QUALITY, QUANTITY, wwork) VALUES (?, ?, ?, ?, ?, ?, ?) bind => [7 parameters bound] Query: InsertObjectQuery(WRequirement( 43642 ))
  2. 0

    GitHub comment 225#23790468

    GitHub | 4 years ago | fxaeberhard
    org.postgresql.util.PSQLException: ERREUR: la valeur d'une cl? dupliqu?e rompt la contrainte unique ? wrequirement_pkey ? Detail: La cl? ? (wrequirement_id)=(43642) ? existe d?j?. Error Code: 0 Call: INSERT INTO WREQUIREMENT (wrequirement_id, COMPLETENESS, wlevel, wlimit, QUALITY, QUANTITY, wwork) VALUES (?, ?, ?, ?, ?, ?, ?) bind => [7 parameters bound] Query: InsertObjectQuery(WRequirement( 43642 ))
  3. 0

    Eclipse Community Forums: EclipseLink » @Embeddable with Entity relations

    eclipse.org | 1 year ago
    org.postgresql.util.PSQLException: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »entityrelation_pkey« Error Code: 0 Call: INSERT INTO ENTITYRELATION (ID, RELATIONNAME, RELATIONTYPE) VALUES (?, ?, ?) bind => [2, relation2, INTEGER_T] Query: WriteObjectQuery(org.test.entity.EntityRelation@46cd0462)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Eclipse Community Forums: EclipseLink » @Embeddable with Entity relations

    eclipse.org | 9 months ago
    org.postgresql.util.PSQLException: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »entityrelation_pkey« Error Code: 0 Call: INSERT INTO ENTITYRELATION (ID, RELATIONNAME, RELATIONTYPE) VALUES (?, ?, ?) bind => [2, relation2, INTEGER_T] Query: WriteObjectQuery(org.test.entity.EntityRelation@46cd0462)
  6. 0

    No operator matches the given name and argument type(s). You might need to add explicit type casts. -- Netbeans, Postgresql 8.4 and Glassfish

    Stack Overflow | 7 years ago | Sam
    org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 38 Error Code: 0

  1. silex 5 times, last 4 months ago
20 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERREUR: la valeur d'une cl? dupliqu?e rompt la contrainte unique ? wrequirement_pkey ? Detail: La cl? ? (wrequirement_id)=(43642) ? existe d?j?.

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeUpdate
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)[postgresql-9.1-901.jdbc4.jar:na]
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)[postgresql-9.1-901.jdbc4.jar:na]
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)[postgresql-9.1-901.jdbc4.jar:na]
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)[postgresql-9.1-901.jdbc4.jar:na]
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)[postgresql-9.1-901.jdbc4.jar:na]
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)[postgresql-9.1-901.jdbc4.jar:na]
    6 frames
  3. Embedded GlassFish Web
    PreparedStatementWrapper.executeUpdate
    1. com.sun.gjc.spi.base.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:125)[__ds_jdbc_ra.jar:na]
    1 frame
  4. EclipseLink (non-OSGi)
    EntityManagerImpl.flush
    1. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:831)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    2. org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    3. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1494)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    4. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:838)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    5. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    6. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    7. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    8. org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    9. org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    10. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    11. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    12. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    13. org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    14. org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    15. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:472)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    16. org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    17. org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    18. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    19. org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    20. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    21. org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    22. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    23. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    24. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    25. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    26. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    27. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    28. org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    29. org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:191)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    30. org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:136)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    31. org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3799)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    32. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    33. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:636)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    34. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1561)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    35. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:447)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461]
    36. org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:780)[org.eclipse.persistence.jpa.jar:2.3.2.v20111125-r10461]
    36 frames