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)[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