com.sybase.jdbc2.jdbc.SybSQLException: 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.

Oracle Community | 3004 | 1 decade ago
  1. 0

    FOR UPDATE can not be used in a SELECT

    Oracle Community | 1 decade ago | 3004
    com.sybase.jdbc2.jdbc.SybSQLException: 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.
  2. 0

    Dynamic SQL

    Google Groups | 1 decade ago | ann_lynn
    com.sybase.jdbc2.jdbc.SybSQLException: Execute cursor 'jconnect_implicit_1' is declared on a procedure which contains a non-SELECT or a SELECT with a COMPUTE clause. For the declaration of this cursor to be legal it should have a single SELECT statement w
  3. 0

    jconnect error using Hibernate on SuneONE 8.1

    Google Groups | 10 years ago | Unknown author
    com.sybase.jdbc2.jdbc.SybSQLException: A wrong datastream has been sent to the server. The server was expecting token 236 but got the token 33. This is an internal error.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    wrong exception message thrown by weblogic  if connection pool is used

    Oracle Community | 1 decade ago | 3004
    com.sybase.jdbc2.jdbc.SybSQLException: tgcitynodeldsal [java] [java]
  6. 0

    Transient Sybase SET CHAINED Tx exception.

    Oracle Community | 1 decade ago | 3004
    com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'sp_validate_data' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode. Hi. It means what it says. Is sp_validate_data your procedure? Sybase stored procedures, by default, are only allowed to run in the chained/unchained (autoCommit(false)/autoCommot(true)) mode in which they were created. To get around this, look up the sybase tool sp_procxmode, and call it with your procedure name(s) to allow Sybase to run them whether you're in a transaction or not. Joe

    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.sybase.jdbc2.jdbc.SybSQLException

      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.

      at com.sybase.jdbc2.tds.Tds.processEed()
    2. com.sybase.jdbc2
      Tds.processEed
      1. com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636)
      1 frame