java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction

Oracle Community | 807581 | 1 decade ago
  1. 0

    SET TRANSACTION must be first statement of transaction

    Oracle Community | 1 decade ago | 807581
    java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
  2. 0

    When do connections from the connection poll get released?

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
  3. 0

    java.sql.SQLException: ORA-01453: SET TRANSACTION

    Oracle Community | 1 decade ago | 551398
    java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Stored Procedure

    Google Groups | 1 decade ago | ksenji
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00905: object KSENJI.KSENJI is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  6. 0

    SQL command not properly ended (in Oracle)

    Google Groups | 2 decades ago | Teresa Redmond
    java.sql.SQLException: ORA-00933: SQL command not properly ended

  1. rp 1 times, last 2 weeks ago
26 unregistered visitors
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. java.sql.SQLException

    ORA-01453: SET TRANSACTION must be first statement of transaction

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
    4 frames
  4. Oracle jdbc
    OracleConnection.setTransactionIsolation
    1. oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
    2. oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
    3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
    4. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:737)
    5. oracle.jdbc.driver.OracleConnection.setTransactionIsolation(OracleConnection.java:1081)
    5 frames
  5. Connectors Runtime
    Jdbc20XaAllocator$ConnectionWrapper.setTransactionIsolation
    1. com.sun.enterprise.resource.Jdbc20XaAllocator$ConnectionWrapper.setTransactionIsolation(Jdbc20XaAllocator.java:196)
    1 frame