com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'SEQUENCE'. Error Code: 208 Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ? bind => [50, SEQ_GEN] Query: DataModifyQuery()

Oracle Community | 807574 | 8 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Cannot insert a row into a SQL Server table

    Oracle Community | 8 years ago | 807574
    com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'SEQUENCE'. Error Code: 208 Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ? bind => [50, SEQ_GEN] Query: DataModifyQuery()

    Root Cause Analysis

    1. com.microsoft.sqlserver.jdbc.SQLServerException

      Invalid object name 'SEQUENCE'. Error Code: 208 Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ? bind => [50, SEQ_GEN] Query: DataModifyQuery()

      at oracle.toplink.essentials.exceptions.DatabaseException.sqlException()
    2. oracle.toplink.essentials
      DatasourceCallQueryMechanism.executeNoSelectCall
      1. oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:311)
      2. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:654)
      3. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:703)
      4. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:492)
      5. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:452)
      6. oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:690)
      7. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
      8. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:214)
      9. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:257)
      9 frames