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 | 3 years ago
  1. 0

    PMG - Unable to duplicate Task

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