java.sql.SQLSyntaxErrorException: SEQUENCE 'SDDPU' does not exist. Error Code: -1 Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException Call: VALUES(NEXT VALUE FOR SDDPU) Query: ValueReadQuery(sql="VALUES(NEXT VALUE FOR SDDPU)") Internal Exception: java.sql.SQLSyntaxErrorException: SEQUENCE 'SDDPU' does not exist. Error Code: -1 Call: VALUES(NEXT VALUE FOR SDDPU) Query: ValueReadQuery(sql="VALUES(NEXT VALUE FOR SDDPU)")

Stack Overflow | Parsa Zarrin | 4 months 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

    GitHub comment 49#148854662

    GitHub | 2 years ago | jbauer180266
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: "USER09462.SEQ_GEN_SEQUENCE" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.17.29 Error Code: -204 Call: VALUES(NEXT VALUE FOR SEQ_GEN_SEQUENCE) Query: ValueReadQuery(sql="VALUES(NEXT VALUE FOR SEQ_GEN_SEQUENCE)")
  2. 0

    GitHub comment 49#148854111

    GitHub | 2 years ago | jbauer180266
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: "USER09462.SEQ_GEN_SEQUENCE" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.17.29 2015-10-17T00:32:08.46+0200 [App/0] ERR Error Code: -204 2015-10-17T00:32:08.46+0200 [App/0] ERR Call: VALUES(NEXT VALUE FOR SEQ_GEN_SEQUENCE) 2015-10-17T00:32:08.46+0200 [App/0] ERR Query: ValueReadQuery(sql="VALUES(NEXT VALUE FOR SEQ_GEN_SEQUENCE)") 2015-10-17T00:32:08.46+0200 [App/0] ERR at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340) 2015-10-17T00:32:08.46+0200 [App/0] ERR at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684) 2015-10-17T00:32:08.46+0200 [App/0] ERR at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
  3. 0

    Problems using merge method to update DB record

    Coderanch | 3 years ago | Jay Tai
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '2' for key 'PRIMARY' Error Code: 1062 Call: INSERT INTO projects_beta2b_projects_beta2b (projects_PROJECTID) VALUES (?) bind => [1 parameter bound] Query: DataModifyQuery(name="projects" sql="INSERT INTO projects_beta2b_projects_beta2b (projects_PROJECTID) VALUES (?)")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problems using merge method to update DB record [Solved] (JSF forum at Coderanch)

    coderanch.com | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '2' for key 'PRIMARY' Error Code: 1062 Call: INSERT INTO projects_beta2b_projects_beta2b (projects_PROJECTID) VALUES (?) bind => [1 parameter bound] Query: DataModifyQuery(name="projects" sql="INSERT INTO projects_beta2b_projects_beta2b (projects_PROJECTID) VALUES (?)")
  6. 0

    Unwinding ADF: EJB DataControl - Configuring Sequential ids using JPA @TableGenerator

    blogspot.com | 4 months ago
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Error Code: 942 Call: UPDATE HR.SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ? bind => [1, DeptNoGenerator] Query: DataModifyQuery(sql="UPDATE HR.SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?")
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.apache.derby.client.am.SqlException

    SEQUENCE 'SDDPU' does not exist.

    at org.apache.derby.client.am.Statement.completeSqlca()
  2. Apache Derby Client JDBC Driver
    Connection.prepareStatement
    1. org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
    2. org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
    3. org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
    4. org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
    5. org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
    6. org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
    7. org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
    8. org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
    9. org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
    10. org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
    11. org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
    12. org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
    12 frames
  3. EclipseLink (non-OSGi)
    EntityManagerImpl.persist
    1. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1556)
    2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1505)
    3. org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:778)
    4. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:619)
    5. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
    6. org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
    7. org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
    8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
    9. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
    10. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
    11. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:281)
    12. org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:197)
    13. org.eclipse.persistence.queries.DataReadQuery.executeDatabaseQuery(DataReadQuery.java:152)
    14. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
    15. org.eclipse.persistence.queries.DataReadQuery.execute(DataReadQuery.java:137)
    16. org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:3214)
    17. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
    18. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
    19. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1737)
    20. org.eclipse.persistence.sequencing.QuerySequence.select(QuerySequence.java:309)
    21. org.eclipse.persistence.sequencing.QuerySequence.updateAndSelectSequence(QuerySequence.java:254)
    22. org.eclipse.persistence.sequencing.StandardSequence.getGeneratedVector(StandardSequence.java:71)
    23. org.eclipse.persistence.sequencing.Sequence.getGeneratedVector(Sequence.java:257)
    24. org.eclipse.persistence.internal.sequencing.SequencingManager$Preallocation_NoTransaction_State.getNextValue(SequencingManager.java:652)
    25. org.eclipse.persistence.internal.sequencing.SequencingManager.getNextValue(SequencingManager.java:1067)
    26. org.eclipse.persistence.internal.sequencing.ClientSessionSequencing.getNextValue(ClientSessionSequencing.java:70)
    27. org.eclipse.persistence.internal.descriptors.ObjectBuilder.assignSequenceNumber(ObjectBuilder.java:361)
    28. org.eclipse.persistence.internal.descriptors.ObjectBuilder.assignSequenceNumber(ObjectBuilder.java:320)
    29. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.assignSequenceNumber(UnitOfWorkImpl.java:486)
    30. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.registerNotRegisteredNewObjectForPersist(UnitOfWorkImpl.java:4290)
    31. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.registerNotRegisteredNewObjectForPersist(RepeatableWriteUnitOfWork.java:518)
    32. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.registerNewObjectForPersist(UnitOfWorkImpl.java:4235)
    33. org.eclipse.persistence.internal.jpa.EntityManagerImpl.persist(EntityManagerImpl.java:496)
    33 frames
  4. com.pluralsight
    ChangeDetails$2.actionPerformed
    1. com.pluralsight.DBManager.insert(DBManager.java:38)
    2. com.pluralsight.ChangeDetails.UpdateActionPerformed(ChangeDetails.java:114)
    3. com.pluralsight.ChangeDetails.access$300(ChangeDetails.java:16)
    4. com.pluralsight.ChangeDetails$2.actionPerformed(ChangeDetails.java:57)
    4 frames
  5. Java RT
    EventDispatchThread.run
    1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
    2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
    3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    6. java.awt.Component.processMouseEvent(Component.java:6516)
    7. javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
    8. java.awt.Component.processEvent(Component.java:6281)
    9. java.awt.Container.processEvent(Container.java:2229)
    10. java.awt.Component.dispatchEventImpl(Component.java:4872)
    11. java.awt.Container.dispatchEventImpl(Container.java:2287)
    12. java.awt.Component.dispatchEvent(Component.java:4698)
    13. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
    14. java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
    15. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
    16. java.awt.Container.dispatchEventImpl(Container.java:2273)
    17. java.awt.Window.dispatchEventImpl(Window.java:2719)
    18. java.awt.Component.dispatchEvent(Component.java:4698)
    19. java.awt.EventQueue.dispatchEventImpl(EventQueue.java:747)
    20. java.awt.EventQueue.access$300(EventQueue.java:103)
    21. java.awt.EventQueue$3.run(EventQueue.java:706)
    22. java.awt.EventQueue$3.run(EventQueue.java:704)
    23. java.security.AccessController.doPrivileged(Native Method)
    24. java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    25. java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
    26. java.awt.EventQueue$4.run(EventQueue.java:720)
    27. java.awt.EventQueue$4.run(EventQueue.java:718)
    28. java.security.AccessController.doPrivileged(Native Method)
    29. java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    30. java.awt.EventQueue.dispatchEvent(EventQueue.java:717)
    31. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
    32. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
    33. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
    34. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
    35. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
    36. java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
    36 frames