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

    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

    Kodo attempts to set PK fields to null on deletion of owning object

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ORA-01407: cannot update ("CS2"."OBLIGATION"."CONTRACT_ID") to NULL {prepstmnt 12985263 UPDATE CS2.OBLIGATION SET CONTRACT_ID = ?, MODIFICATION_ID = ? WHERE CONTRACT_ID = ? AND MODIFICATION_ID = ? [params=(null) null, (null) null, (long) 130, (int) 2]} [code=1407, state=72000]
  3. 0

    Kodo v4.0.0EA2 Bugs List

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ERROR: relation "kodo_sequence_table" does not exist {prepstmnt 31538514 SELECT SEQUENCE_VALUE FROM KODO_SEQUENCE_TABLE WHERE ID = ? FOR UPDATE [reused=0]} [code=0, state=42P01]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    3.0.0RC2 MappingTool producing bad SQL

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'OTHER)' at line 1" {stmnt 30301818: CREATE TABLE TestServiceKeyArray (keyArray BIGINT, parent VARCHAR(255), seqno OTHER)} [code=1064, state=42000]
  6. 0

    mappingtool generates bad DDL for sybase (J2ee tutorial)

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: Can't specify a length or scale on type 'IndexName'. {stmnt 7576378: CREATE TABLE CAR (COLOR IndexName(255) NULL, JDOCLASS IndexName(255) NULL, JDOID NUMERIC(38) NOT NULL, JDOVERSION INT NULL, MAKE IndexName(255) NULL, MODEL IndexName(255) NULL, YEAR0 IndexName(255) NULL, UNQ_INDEX NUMERIC I DENTITY UNIQUE, CONSTRAINT P_CAR PRIMARY KEY (JDOID))} [code=2716, state=ZZZZZ]

    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