org.postgresql.util.PSQLException: ERROR: > duplicate key > .... > at > org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:331) > > at > org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157) > > at > org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68) > > at > com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99) > > at > com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:158) > > at > com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2561) > > at > com.sun.jts.CosTransactions.CoordinatorTerm.commit(CoordinatorTerm.java:279) > > at > com.sun.jts.CosTransactions.TerminatorImpl.commit(TerminatorImpl.java:250) >

Oracle Community | c_krebs | 6 years ago
  1. 0

    infinite message redelivery in the case of a DatabaseException at commit time

    Oracle Community | 6 years ago | c_krebs
    org.postgresql.util.PSQLException: ERROR: > duplicate key > .... > at > org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:331) > > at > org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157) > > at > org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68) > > at > com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99) > > at > com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:158) > > at > com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2561) > > at > com.sun.jts.CosTransactions.CoordinatorTerm.commit(CoordinatorTerm.java:279) > > at > com.sun.jts.CosTransactions.TerminatorImpl.commit(TerminatorImpl.java:250) >
  2. 0

    [Issue 1597] New - CascadeType.ALL does not work when removing entity - mar...@dev.java.net - net.java.dev.glassfish.issues - MarkMail

    markmail.org | 5 months ago
    org.postgresql.util.PSQLException: ERROR: update or delete on table "ejbtest" violates foreign key constraint "ejbtest_idd_fkey" on table "ejbtest" Detail: Key (id)=(1) is still referenced from table "ejbtest".Error Code: 0 Call:DELETE FROM ejbtest WHERE (id = ?) bind => [1] Query:DeleteObjectQuery(ejb.test.Ejbtest[id=1]) at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437) at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:190) at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:115) at oracle.toplink.essentials.queryframework.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:132) at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609) at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536) at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:123) at oracle.toplink.essentials.queryframework.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:95) at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:95) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219) at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937) at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894) at oracle.toplink.essentials.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:322) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1033) at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:357) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1112) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:2429) at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:177) at oracle.toplink.essentials.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:116) at oracle.toplink.essentials.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:76) at com.sun.enterprise.distributedtx.J2EETransaction.commit(J2EETransaction.java:406) at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:358) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3704) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3483) at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1273) at com.sun.enterprise.webservice.EjbRuntimeEndpointInfo.releaseImplementor(EjbRuntimeEndpointInfo.java:354) at com.sun.enterprise.webservice.Ejb3MessageDispatcher.handlePost(Ejb3MessageDispatcher.java:110) at com.sun.enterprise.webservice.Ejb3MessageDispatcher.invoke(Ejb3MessageDispatcher.java:74) at com.sun.enterprise.webservice.EjbWebServiceServlet.dispatchToEjbEndpoint(EjbWebServiceServlet.java:187) at com.sun.enterprise.webservice.EjbWebServiceServlet.service(EjbWebServiceServlet.java:116)
  3. 0

    I need to add values into postresql in java,

    Stack Overflow | 3 years ago | topal
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "(" Position: 157
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    duplicate key value "sym_data_gap_...

    symmetricds | 5 years ago | *anonymous
    org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "sym_data_gap_pkey" Detail: Key (start_id, end_id)=(25267442, 25267442) already exists.
  6. 0

    ERROR: syntax error at or near "." in copy command using java?

    Stack Overflow | 2 years ago
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "." Position: 27 at

    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

      ERROR: > duplicate key > .... > at > org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:331) > > at > org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157) > > at > org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68) > > at > com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99) > > at > com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:158) > > at > com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2561) > > at > com.sun.jts.CosTransactions.CoordinatorTerm.commit(CoordinatorTerm.java:279) > > at > com.sun.jts.CosTransactions.TerminatorImpl.commit(TerminatorImpl.java:250) >

      at com.sun.jts.CosTransactions.CurrentImpl.commit()
    2. Embedded GlassFish Web
      CurrentImpl.commit
      1. com.sun.jts.CosTransactions.CurrentImpl.commit(CurrentImpl.java:623)
      1 frame