org.apache.openjpa.util.StoreException: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed. The sequence table is typically created when you run the mappingtool's refresh action on any datastore identity class. If you have not run the mappingtool but want to create the sequence table, run: java org.apache.openjpa.jdbc.kernel.TableJDBCSeq -action add

Oracle Community | 929102 | 5 years ago
  1. 0

    NEED URGENT HELP WITH ENTITY

    Oracle Community | 5 years ago | 929102
    org.apache.openjpa.util.StoreException: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed. The sequence table is typically created when you run the mappingtool's refresh action on any datastore identity class. If you have not run the mappingtool but want to create the sequence table, run: java org.apache.openjpa.jdbc.kernel.TableJDBCSeq -action add
  2. 0

    Using GenerationType.AUTO failes to create OPENJPA_SEQUENCE_TABLE

    Oracle Community | 8 years ago | 647944
    org.apache.openjpa.util.StoreException: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed. The sequence table is typically created when you run the mappingtool's refresh action on any datastore identity class. If you have not run the mappingtool but want to create the sequence table, run: java org.apache.openjpa.jdbc.kernel.TableJDBCSeq -action add
  3. 0

    Using GenerationType.AUTO failes to create OPENJPA_SEQUENCE_TABLE

    Oracle Community | 8 years ago | 647944
    org.apache.openjpa.util.StoreException: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed. The sequence table is typically created when you run the mappingtool's refresh action on any datastore identity class. If you have not run the mappingtool but want to create the sequence table, run: java org.apache.openjpa.jdbc.kernel.TableJDBCSeq -action add
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Using GenerationType.AUTO failes to create OPENJPA_SEQUENCE_TABLE

    Oracle Community | 8 years ago | 647944
    org.apache.openjpa.util.StoreException: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed. The sequence table is typically created when you run the mappingtool's refresh action on any datastore identity class. If you have not run the mappingtool but want to create the sequence table, run: java org.apache.openjpa.jdbc.kernel.TableJDBCSeq -action add
  6. 0

    db:: 4.27::ALES Installation issue p8

    hivmr.com | 11 months ago
    org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00942: table or view does not exist {prepstmnt 1937054 SELECT t0.id, t0.create_id, t0.create_time, t0.description, t0.loc_id, t0.qualified, t0.upd_id, t0.upd_time FROM dir_curr t0 WHERE (t0.qualified = ?) [params=(String) //dir/RootOrg!AdminDir] [reused=0]} [code=942, state=42000]

    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.openjpa.lib.jdbc.ReportingSQLException

      ORA-00942: table or view does not exist {prepstmnt 109 SELECT SEQUENCE_VALUE FROM OPENJPA_SEQUENCE_TABLE WHERE ID = ? FOR UPDATE [params=(int) 0]} [code=942, state=42000]

      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap()
    2. OpenJPA Aggregate Jar
      JDBCStoreManager.assignObjectId
      1. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
      2. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
      3. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:852)
      4. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
      5. org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1430)
      6. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)
      7. org.apache.openjpa.jdbc.kernel.TableJDBCSeq.executeQuery(TableJDBCSeq.java:728)
      8. org.apache.openjpa.jdbc.kernel.TableJDBCSeq.getSequence(TableJDBCSeq.java:470)
      9. org.apache.openjpa.jdbc.kernel.TableJDBCSeq.setSequence(TableJDBCSeq.java:510)
      10. org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:368)
      11. org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4207)
      12. org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4171)
      13. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
      14. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:80)
      15. org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:371)
      16. org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:266)
      17. org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60)
      18. org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:585)
      18 frames
    3. kodo.jdbc.kernel
      KodoJDBCStoreManager.assignObjectId
      1. kodo.jdbc.kernel.KodoJDBCStoreManager.assignObjectId(KodoJDBCStoreManager.java:33)
      1 frame
    4. OpenJPA Aggregate Jar
      BrokerImpl.beforeCompletion
      1. org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:134)
      2. org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:134)
      3. org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:518)
      4. org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:2817)
      5. org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:39)
      6. org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:958)
      7. org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1955)
      8. org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1915)
      9. org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1833)
      9 frames
    5. weblogic.transaction.internal
      ServerTransactionImpl.commit
      1. weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1239)
      2. weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1214)
      3. weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:116)
      4. weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1316)
      5. weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2132)
      6. weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:272)
      7. weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:239)
      7 frames
    6. weblogic.ejb.container
      BaseLocalObject.postInvoke1
      1. weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:622)
      1 frame