com.solarmetric.jdbc.ReportingSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. {prepstmnt 35 SELECT SEQUENCE_VALUE FROM ACT_JDO_SEQUENCE WHERE ID = ? FOR UPDATE AT ISOLATION SERIALIZABLE [params=(String) com.tti.act.inv.resource.PersistentResource]} [code=7305, state=ZZZZZ]

Oracle Community | 3004 | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    FOR UPDATE can not be used in a SELECT

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. {prepstmnt 35 SELECT SEQUENCE_VALUE FROM ACT_JDO_SEQUENCE WHERE ID = ? FOR UPDATE AT ISOLATION SERIALIZABLE [params=(String) com.tti.act.inv.resource.PersistentResource]} [code=7305, state=ZZZZZ]

    Root Cause Analysis

    1. com.solarmetric.jdbc.ReportingSQLException

      FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. {prepstmnt 35 SELECT SEQUENCE_VALUE FROM ACT_JDO_SEQUENCE WHERE ID = ? FOR UPDATE AT ISOLATION SERIALIZABLE [params=(String) com.tti.act.inv.resource.PersistentResource]} [code=7305, state=ZZZZZ]

      at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap()
    2. com.solarmetric.jdbc
      LoggingConnectionDecorator.wrap
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:124)
      1 frame