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
  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]
  2. 0

    Webstart Issue

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The cursor was not declared.
  3. 0

    Query under Transaction Exception....

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: DB2 SQL error: SQLCODE: -511, SQLSTATE: 42829, SQLERRMC: null {prepstmnt 107840951 SELECT t0.GROUPSETTINGID, t0.ALLOWDRAW, t0.ALLOWSTRIKE, t0.ALLOWTRANSFER, t0.ASCENDONLY, t0.AUTOAPPROVE, t0.BARVISIBLE, t0.DEFAULTLEVELNAME, t0.LASTMODIFY, t0.MAXDRAW, t0.MAXRECHARGE, t0.MAXROWS, t0.MAXSTRIKE, t0.MAXTRANSFER, t0.MINDRAW, t0.MINRECHARGE, t0.MINSTRIKE, t0.MINTRANSFER, t0.GROUPID, t0.RECHARGEABLE, t0.USERTYPEMODIFICATION FROM OLTP.GROUPSETTING t0 INNER JOIN OLTP.ORGANGROUP t1 ON t0.GROUPID = t1.GROUPID WHERE (t1.GROUPID = ?) FOR UPDATE [reused=0]} [code=-511, state=42829]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQL Server error

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: [Microsoft][SQLServer 2000 Driver fo r JDBC]Can't start a cloned connection while in manual transaction mode. {SELECT SEQUENCE_VALUE FROM JDO_SEQUENCE WHERE ID = ?} [code=0, state=08007]
  6. 0

    SQL Server error

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: [Microsoft][SQLServer 2000 Driver fo r JDBC]Can't start a cloned connection while in manual transaction mode. {SELECT SEQUENCE_VALUE FROM JDO_SEQUENCE WHERE ID = ?} [code=0, state=08007]

    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. 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